🎣 Enrich leads from Google Sheets with ScraperCity emails, phones, and validation
⚡ 29 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Who is this for
This template is for B2B sales teams, SDRs, growth marketers, and founders who maintain a spreadsheet of prospects and need verified contact details — emails and mobile numbers — without manual research.
How it works
- Reads a list of contacts (first name, last name, company domain) from a Google Sheet.
- Formats the contacts and submits them to the ScraperCity Email Finder API to discover business email addresses.
- Polls until the email-finder job completes, then downloads and parses the results.
- Submits the found emails to the ScraperCity Mobile Finder API to look up phone numbers.
- Polls until the mobile-finder job completes, then downloads and parses results.
- Submits all found emails to the ScraperCity Email Validator API for deliverability and catch-all checks.
- Polls until validation completes, merges all enriched data together, and writes the final enriched rows back to a Google Sheet.
How to set up
- Add your ScraperCity API key as an HTTP Header Auth credential named “ScraperCity API Key”.
- Set your input Google Sheets document ID and sheet name in the “Configure Workflow” node.
- Set your output Google Sheets document ID and sheet name in the same node.
- Click “Execute workflow” to run.
Requirements
- ScraperCity account with Email Finder, Mobile Finder, and Email Validator products enabled.
- Google Sheets OAuth2 credential connected to n8n.
- Input sheet with columns: first_name, last_name, domain.
How to customize the workflow
- Swap Google Sheets for Airtable or a webhook trigger.
- Add a Filter node after validation to keep only emails with status “valid”.
- Extend the output Set node to include additional fields from either API response.
🔗 Nodes Used
Google Sheets, HTTP Request, Filter
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File