Enrich leads from Google Sheets with ScraperCity emails, phones, and validation

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.