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

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building. Relevant for managed services and support workflows.

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 AlekSystem. 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.

Best fit

Need another direction?