Bibliothek / Lead-Generierung & Anreicherung
Lead-Generierung & Anreicherung
Lead-Telefonnummern in Google Sheets mit 1Lookup validieren
Läuft stündlich über ein Google Sheet mit Leads, validiert ungeprüfte Telefonnummern mit 1Lookup (Status, Leitungstyp, Do Not Call, Aktion) und schreibt die Ergebnisse zurück in jede Zeile.
Was sie bewirkt
## 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.
Die Schritte
- Every hour
- Settings
- Read leads
- Only unchecked rows with a phone
- Validate phone number
- Prepare sheet values
- Write results to sheet
Ähnliche Automatisierungen
MCP-Server & ToolsOne-Simple-API-Hilfsprogramme als MCP-Server11 SchritteLead-Generierung & AnreicherungCRM-Leads mit BatchData bewerten und Slack alarmieren8 SchritteLead-Generierung & AnreicherungSocial-Media-Links für Kontakte in Google Sheets finden8 SchritteLead-Generierung & AnreicherungKontaktformular-Leads der Website mit OpenAI, Twilio, Gmail und Google Sheets filtern39 Schritte