Find and verify business emails with ScraperCity, OpenAI, Google Sheets, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 17 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI Chat Model and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Configuration (Edit Fields (Set)): sets 9 fields: scrapercity_finder_url, scrapercity_status_url, scrapercity_download_url…
- Get contacts from Sheet (Google Sheets): uses Google Sheets
- Build contacts payload (Aggregate): combines items into one
- Submit to ScraperCity (HTTP Request): calls an HTTP API (POST)
- Wait: pauses before continuing
- Check job status (HTTP Request): calls an HTTP API
- Route by job status (Switch): routes items into 2 branches
- Download results (HTTP Request): calls an HTTP API
- Extract results from CSV (Extract from File): extracts data from a file
- Normalize result fields (Code): runs custom JavaScript code
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - Extract from File
n8n-nodes-base.extractFromFile - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow reads contacts from Google Sheets, finds and verifies their business emails via the ScraperCity Email Finder API, generates a short personalized icebreaker with OpenAI, appends the enriched leads to another Google Sheet, and…