Enrich outbound leads in Google Sheets with Firecrawl, Hunter, and GPT-5.6
UnknownWhat this workflow does
This AI workflow has 55 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets, OpenRouter Chat Model, Hunter and Dropcontact and 2 more.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Table Settings (Edit Fields (Set)): sets 11 fields: batch_size, max_credits_per_run, min_verifier_score…
- Read Pending Rows (Google Sheets): uses Google Sheets
- Pick Batch (Code): runs custom JavaScript code
- Loop Rows (Loop Over Items (Split in Batches)): loops over the items in batches
- Summarize Run (Code): runs custom JavaScript code
- Check Run Budget (Code): runs custom JavaScript code
- Format Run Report (Code): runs custom JavaScript code
- Row Needs Work (If): checks a condition and branches into true / false
- Email Run Report (Gmail): uses Gmail
- Has Website (If): checks a condition and branches into true / false
…plus 37 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @mendable/n8n-nodes-firecrawl is verified or supports 3.0 (used in Scrape Homepage, Scrape About Page, Search Company Domain).
Nodes used (15)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Firecrawl
@mendable/n8n-nodes-firecrawl.firecrawl - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Hunter
n8n-nodes-base.hunter - Dropcontact
n8n-nodes-base.dropcontact - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow runs on a schedule (or manually) to enrich pending leads in Google Sheets by finding a company domain and decision-maker, scraping and researching the website with Firecrawl and OpenRouter, verifying emails via a Hunter and…