İçeriğe geç
YENİPazar yeri ve ekibin: geliştirdiğini sat; planlar ve değişiklikler sen görmeden önce test edilsin. Yeniliklere bak

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

  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

Benzer otomasyonlar