Extract and qualify local business leads and draft cold emails with OpenAI, Apify and Hunter
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI, Hunter and Apify (community) and 1 more.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get dataset items (Apify): work with datasets
- Limit: keeps the first few items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Scrape Home (HTTP Request): calls an HTTP API
- Scrape Lead Website (HTML): parses or builds HTML
- Lead Qualification Agent (OpenAI): uses OpenAI
- Hunter: email verifier
- Filter: keeps only the items that match a condition
- Search (Tavily): uses Tavily
- Lead Normalize Agent (OpenAI): uses OpenAI
…plus 4 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 2 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Get dataset items).
- Check that @tavily/n8n-nodes-tavily is verified or supports 3.0 (used in Search).
Nodes used (12)
- HTML
n8n-nodes-base.html - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Apify
@apify/n8n-nodes-apify.apify - Manual Trigger
n8n-nodes-base.manualTrigger - Limit
n8n-nodes-base.limit - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi - Hunter
n8n-nodes-base.hunter - Tavily
@tavily/n8n-nodes-tavily.tavily
From the author
AI-Powered Business Lead Scraping, Qualification & Outreach System Description Search → Scrape → Qualify → CRM → Email Draft Automation Categories: Lead Generation, Sales Automation, AI Enrichment, Revenue Ops --- This workflow automatically finds local…