{"product_id":"validate-us-phone-numbers-in-n8n-searchbug-google-sheets","title":"Validate US Phone Numbers in n8n: Searchbug + Google Sheets","description":"\u003ch3\u003eValidate US Phone Numbers in n8n—then enrich and log results to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis 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 \u003cstrong\u003eSearchbug Phone Validator (api_lnp3)\u003c\/strong\u003e, and appends carrier\/line-type and compliance flags to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives input\u003c\/strong\u003e from an n8n \u003cem\u003eForm Trigger\u003c\/em\u003e: either one phone number or a CSV upload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes\u003c\/strong\u003e submissions as single-entry vs bulk CSV and normalizes the field to a consistent \u003ccode\u003ephone\u003c\/code\u003e value.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters invalid records\u003c\/strong\u003e to avoid unnecessary API calls—only \u003cstrong\u003e10-digit US phone numbers\u003c\/strong\u003e proceed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSanitizes\u003c\/strong\u003e each phone by stripping non-numeric characters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and enriches\u003c\/strong\u003e each number using the Searchbug API endpoint \u003ccode\u003eapi_lnp3\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts key fields\u003c\/strong\u003e from the Searchbug JSON response (or marks the lookup as failed) and \u003cstrong\u003eflattens\u003c\/strong\u003e results for storage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets\u003c\/strong\u003e in a tab you configure, including fields like \u003ccode\u003ephone_type\u003c\/code\u003e, \u003ccode\u003ecarrier\u003c\/code\u003e, \u003ccode\u003evoip\u003c\/code\u003e, \u003ccode\u003ednc\u003c\/code\u003e, \u003ccode\u003etcpa\u003c\/code\u003e, \u003ccode\u003eported\u003c\/code\u003e, \u003ccode\u003estate\u003c\/code\u003e, and timestamps such as \u003ccode\u003evalidated_at\u003c\/code\u003e and \u003ccode\u003evalidation_status\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVerify and enrich phone numbers entered through an \u003cstrong\u003en8n-powered signup or lead form\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRun \u003cstrong\u003ebulk list hygiene\u003c\/strong\u003e for outbound campaigns by validating 10-digit US numbers and recording VoIP\/DNC\/TCPA flags.\u003c\/li\u003e\n  \u003cli\u003eMaintain a lightweight \u003cstrong\u003ephone intelligence log\u003c\/strong\u003e for SaaS operations, sales, or compliance workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearchbug integration:\u003c\/strong\u003e HTTP Request node calling \u003ccode\u003eapi_lnp3\u003c\/code\u003e with your Searchbug \u003ccode\u003eco_code\u003c\/code\u003e and \u003ccode\u003epass\u003c\/code\u003e in query parameters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e append rows to a pre-created sheet\/tab using the expected header columns (e.g., \u003ccode\u003eformatted_phone\u003c\/code\u003e, \u003ccode\u003elata\u003c\/code\u003e, \u003ccode\u003elocal_time\u003c\/code\u003e, \u003ccode\u003ecnam\u003c\/code\u003e, etc.).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003eform trigger\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869895975091,"sku":"N8N-18435","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/r8AIjDmeGeDgAUw4pIONn_seWxG1Mp.png?v=1787130585","url":"https:\/\/buyflowscripts.com\/products\/validate-us-phone-numbers-in-n8n-searchbug-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}