Back to Templates
Who is this for
This workflow is for B2B sales teams, growth hackers, and revenue operators who need a reliable, low-cost pipeline of verified leads from Apollo.io -- without manually exporting CSVs or hitting Apollo's export limits. If you are prospecting into a specific industry, job title, or company size, this workflow automates the entire sourcing and storage process.
How it works
- You configure your target audience once in the "Configure Search Parameters" node (job titles, industry, company size, lead count).
- The workflow sends a scrape request to ScraperCity's Apollo filter endpoint, which pulls verified contacts at $0.0039 per contact.
- Because scrapes run asynchronously and can take 10-60 minutes, the workflow polls ScraperCity every 60 seconds until the job completes.
- Once the scrape succeeds, the workflow downloads the results, parses the CSV data, removes duplicates, and appends clean rows to your Google Sheet.
How to set up
- Create a ScraperCity account at scrapercity.com and copy your API key.
- In n8n, create an "Header Auth" credential named "ScraperCity API Key" with the header name "Authorization" and value "Bearer YOUR_KEY".
- Connect your Google Sheets OAuth2 credential.
- Set your Google Sheet document ID and sheet name in the "Save Leads to Google Sheets" node.
- Edit the "Configure Search Parameters" node with your target filters.
Requirements
- ScraperCity account (scrapercity.com)
- Google Sheets OAuth2 credential
- A Google Sheet with headers matching the contact fields
How to customize the workflow
- Change job titles, industry, company size, and lead count in "Configure Search Parameters".
- Swap Google Sheets for HubSpot, Airtable, or a webhook to push leads directly into your CRM.
- Add a Slack notification node after the final write step to alert your team when new leads arrive.