Validate US Phone Numbers in n8n: Searchbug + Google Sheets

Validate US Phone Numbers in n8n—then enrich and log results to Google Sheets

This n8n workflow takes a single US phone number (or a bulk CSV via an n8n form), validates and normalizes it, looks it up with the Searchbug Phone Validator (api_lnp3), and appends carrier/line-type and compliance flags to Google Sheets.

What this workflow does

• Receives input from an n8n Form Trigger: either one phone number or a CSV upload.
• Routes submissions as single-entry vs bulk CSV and normalizes the field to a consistent phone value.
• Filters invalid records to avoid unnecessary API calls—only 10-digit US phone numbers proceed.
• Sanitizes each phone by stripping non-numeric characters.
• Validates and enriches each number using the Searchbug API endpoint api_lnp3.
• Extracts key fields from the Searchbug JSON response (or marks the lookup as failed) and flattens results for storage.
• Appends to Google Sheets in a tab you configure, including fields like phone_type, carrier, voip, dnc, tcpa, ported, state, and timestamps such as validated_at and validation_status.

Use cases

• Verify and enrich phone numbers entered through an n8n-powered signup or lead form.
• Run bulk list hygiene for outbound campaigns by validating 10-digit US numbers and recording VoIP/DNC/TCPA flags.
• Maintain a lightweight phone intelligence log for SaaS operations, sales, or compliance workflows.

Technical details

• Searchbug integration: HTTP Request node calling api_lnp3 with your Searchbug co_code and pass in query parameters.
• Google Sheets: append rows to a pre-created sheet/tab using the expected header columns (e.g., formatted_phone, lata, local_time, cnam, etc.).
• n8n nodes used: if, set, code, sticky note, form trigger, http request.