Kütüphane / Potansiyel Müşteri Yaratma ve Zenginleştirme
Potansiyel Müşteri Yaratma ve Zenginleştirme
1Lookup ile Google Sheets'teki potansiyel müşteri telefon numaralarını doğrula
Her saat bir potansiyel müşteri Google Sheet'ini tarar, kontrol edilmemiş telefon numaralarını 1Lookup ile doğrular (durum, hat türü, Do Not Call, işlem) ve sonuçları her satıra geri yazar.
Ne yapar
## 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.
Adımlar
- Every hour
- Settings
- Read leads
- Only unchecked rows with a phone
- Validate phone number
- Prepare sheet values
- Write results to sheet
Benzer otomasyonlar
MCP Sunucuları ve AraçlarıOne Simple API Yardımcı Araçları MCP Sunucusu Olarak11 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeGoogle Sheets'teki kişiler için sosyal medya bağlantılarını bulma8 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeOpenAI, Twilio, Gmail ve Google Sheets ile web sitesi iletişim formu potansiyel müşterilerini filtrele39 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeCRM potansiyel müşterilerini BatchData ile puanla, Slack'e uyar8 adım