Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Lead Generation & Enrichment

Lead Generation & Enrichment

Validate lead phone numbers in Google Sheets using 1Lookup

Runs hourly over a Google Sheet of leads, validates unchecked phone numbers with 1Lookup (status, line type, Do Not Call, action) and writes the results back to each row.

What it does

## Validate phone numbers in Google Sheets with 1Lookup ## Who it's for Sales and marketing teams who keep leads in Google Sheets and lose time calling dead, wrong or landline numbers. ## How it works 1. Every hour, the workflow reads your lead sheet. 2. It skips rows that have no phone number or were already checked. 3. The 1Lookup node validates each number: active or not, line type (mobile, landline or VoIP), Do Not Call listing, and a recommended action (APPROVE, REVIEW or BLOCK). 4. The results go back into the same row, so you can sort and filter the sheet by them. ## How to set up 1. Start a 7-day free trial at app.1lookup.io, then copy your API key from the API Keys page. 2. In n8n, add a 1Lookup API credential with that key. The 1Lookup node is verified by n8n: on n8n Cloud, search for 1Lookup in the nodes panel. On a self-hosted instance, install @momentum-labs/n8n-nodes-1lookup once from Settings > Community Nodes. 3. Add these column headers to your sheet: phone_status, line_type, dnc_listed, action, checked_at. 4. Open both Google Sheets nodes and pick your spreadsheet and tab. 5. In Settings, type the name of your phone column (default Phone). ## Requirements - A 1Lookup API key (the 7-day free trial includes one) - A Google account with access to the sheet ## How to customize - Swap the Schedule Trigger for a Google Sheets Trigger to check rows as soon as they are added. - Add a Filter after Validate phone number to send only mobile numbers to your SMS tool.

The steps

  1. Every hour
  2. Settings
  3. Read leads
  4. Only unchecked rows with a phone
  5. Validate phone number
  6. Prepare sheet values
  7. Write results to sheet

Similar automations