Validate phone numbers in Google Sheets using 1Lookup

Description

Quick Overview This workflow runs hourly to read leads from Google Sheets, validates each unprocessed phone number using 1Lookup, and writes the status, line type, DNC flag, recommended action, and a timestamp back to the same sheet. How it works Runs every hour on a schedule. Reads rows from a Google Sheets worksheet and uses a configured column name (default Phone) to find each lead’s phone number. Filters out rows with an empty phone value or an existing phone_status so only unchecked numbers are processed. Sends each phone number to 1Lookup for validation and continues even if a lookup fails. Prepares update values including phone_status (or ERROR on failure), line_type, dnc_listed, action, and checked_at. Updates the original Google Sheets row by matching on row_number so only the validation columns change. Setup Add Google Sheets credentials in n8n and select the target spreadsheet and sheet tab in both Google Sheets nodes. Install the 1Lookup community node (@momentum-labs/n8n-nodes-1lookup) if needed and create a 1Lookup API credential using your API key. Ensure your sheet includes a row_number field and add columns for phone_status, line_type, dnc_listed, action, and checked_at. Update the phone_column value in the Settings step if your phone field is not named Phone. An n8n automation workflow template by 1Lookup.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets

Capabilities

• 1 nodes

Information