Библиотека / Генерация и обогащение лидов
Генерация и обогащение лидов
Проверка телефонных номеров лидов в Google Sheets с помощью 1Lookup
Запускается каждый час над Google Sheet с лидами, проверяет непроверенные номера телефонов через 1Lookup (статус, тип линии, Do Not Call, действие) и записывает результаты обратно в каждую строку.
Что делает
## 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.
Шаги
- Every hour
- Settings
- Read leads
- Only unchecked rows with a phone
- Validate phone number
- Prepare sheet values
- Write results to sheet
Похожие автоматизации
Серверы и инструменты MCPУтилиты One Simple API как MCP-серверШагов: 11Генерация и обогащение лидовПоиск ссылок на соцсети для контактов в Google SheetsШагов: 8Генерация и обогащение лидовФильтрация заявок из контактной формы сайта с помощью OpenAI, Twilio, Gmail и Google SheetsШагов: 39Генерация и обогащение лидовОценка лидов CRM через BatchData и оповещение в SlackШагов: 8