{"product_id":"n8n-workflow-validate-phone-numbers-in-google-sheets-1lookup","title":"n8n Workflow: Validate Phone Numbers in Google Sheets (1Lookup)","description":"\u003ch3\u003eValidate Phone Numbers in Google Sheets automatically—using 1Lookup (n8n Workflow: “Validate Phone Numbers in Google Sheets (1Lookup)”)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs hourly to read leads from your Google Sheets, validate each unprocessed phone number with \u003cstrong\u003e1Lookup\u003c\/strong\u003e, and write back the results—status, line type, DNC flag, recommended action, and a timestamp.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every hour\u003c\/strong\u003e via a Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads lead rows\u003c\/strong\u003e from a Google Sheets worksheet and uses a configured phone column name (default: \u003cem\u003ePhone\u003c\/em\u003e) to fetch the phone number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips already-checked entries\u003c\/strong\u003e by filtering out rows where the phone value is empty or where \u003cem\u003ephone_status\u003c\/em\u003e already exists.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates each phone number\u003c\/strong\u003e using the \u003cstrong\u003e1Lookup community node\u003c\/strong\u003e (\u003ccode\u003e@momentum-labs\/n8n-nodes-1lookup\u003c\/code\u003e), continuing even if a lookup fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares update fields\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cem\u003ephone_status\u003c\/em\u003e (or \u003cem\u003eERROR\u003c\/em\u003e on failure)\u003c\/li\u003e\n      \u003cli\u003e\u003cem\u003eline_type\u003c\/em\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cem\u003ednc_listed\u003c\/em\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cem\u003eaction\u003c\/em\u003e\u003c\/li\u003e\n      \u003cli\u003e\n\u003cem\u003echecked_at\u003c\/em\u003e timestamp\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the original row\u003c\/strong\u003e in Google Sheets by matching on \u003cem\u003erow_number\u003c\/em\u003e, so only the validation columns change.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnsure your marketing or sales lead pipeline has up-to-date, validated contact numbers in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eRun recurring n8n phone number validation so new rows are automatically checked without manual review.\u003c\/li\u003e\n  \u003cli\u003eUse the returned \u003cem\u003ednc_listed\u003c\/em\u003e flag and \u003cem\u003eaction\u003c\/em\u003e to support compliance-oriented workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e Schedule Trigger, Google Sheets, \u003ccode\u003e@momentum-labs\/n8n-nodes-1lookup\u003c\/code\u003e (1Lookup community node), plus supporting nodes like Set\/Filter\/Sticky Note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e Configure Google Sheets credentials and select the spreadsheet + sheet tab in both Google Sheets nodes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchema expectations:\u003c\/strong\u003e Your sheet must include \u003cem\u003erow_number\u003c\/em\u003e and columns for \u003cem\u003ephone_status\u003c\/em\u003e, \u003cem\u003eline_type\u003c\/em\u003e, \u003cem\u003ednc_listed\u003c\/em\u003e, \u003cem\u003eaction\u003c\/em\u003e, and \u003cem\u003echecked_at\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomization:\u003c\/strong\u003e Update \u003cem\u003ephone_column\u003c\/em\u003e in the Settings step if your phone field isn’t named \u003cem\u003ePhone\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217926607027,"sku":"N8N-20809","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/eg-OgASNSickgbi8xuCLp_CAFacyhA.png?v=1791883575","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-validate-phone-numbers-in-google-sheets-1lookup","provider":"N8N Commerce","version":"1.0","type":"link"}