Marketing & Sales · Tip
n8n Zero-Cost AI Lead Generation Workflow
An n8n automation pipeline for scraping and verifying business leads using Gemini
This automation blueprint uses self-hosted or cloud n8n alongside Google Gemini to generate targeted search queries, scrape contact information, and verify emails into Google Sheets. It splits the workload across parent and child workflows to handle batching and deduplication without commercial scraping tools. It provides a free framework for continuous B2B prospect discovery.
How it works
Multi-stage lead scraping and verification workflow architecture in n8n:
- Parent Automation:
- Trigger: Schedule Trigger / Manual trigger.
- Target Data: Reads target industry and location from a Google Sheet.
- Brain: Uses an AI Agent node connected to Google Gemini Chat Model to generate search queries in structured JSON format.
- Processing: Formats output with a Code node, loops over items, and executes the Child Automation via an Execute Workflow node.
- Child Automation:
- Trigger: Execute Workflow Trigger.
- Web Scraping: Sends HTTP requests based on the generated search queries to pull raw web data.
- Cleaning: Uses Filter and Remove Duplicates nodes.
- Extraction: Loops through items to extract business emails, phone numbers, website URLs, and social media profile links, then appends them to Google Sheets.
- Email Verifier:
- Trigger: Schedule / Sheet update trigger.
- Validation: Checks deliverability and validates enriched email addresses.
- Storage: Updates the lead verification status directly in Google Sheets.
What it's for
- Scrape targeted business contact info based on specific niches and locations
- Generate search queries automatically using Gemini AI
- Filter and deduplicate raw lead lists before adding them to Google Sheets
- Verify scraped email addresses before running outreach campaigns
Key points
- Parent workflow that reads target criteria from Google Sheets and prompts Gemini for queries
- AI Agent node generating structured JSON search queries
- Child workflow using HTTP Request nodes to scrape prospective business contacts
- Data cleaning nodes to filter results and remove duplicate records
- Extraction of business emails, phone numbers, websites, and social links
- Verification workflow to test email deliverability directly in Google Sheets
Pricing
Free blueprint; uses free tiers of n8n, Gemini API, and Google Sheets
Details
- Type
- Tip
- Category
- Marketing & Sales
- Topic
- Lead Generation
- Open source
- No
- Platforms
- Self-hosted, Web
- For
- Growth marketers, sales teams, and agency owners looking for no-cost lead generation
- Alternative to
- Apollo.io, Clay, PhantomBuster
- Tags
- n8n, leadgen, automation, scraping, gemini, workflows
Why it was saved
- @pranathi.rai: Enables automated scraping of thousands of business leads with contact details and verified emails each week without paying for commercial scraping subscriptions.
Compare
Related
Cloud scraping and monitoring service for Instagram audience and contact data
Real-time B2B search engine for verified emails, phone numbers, and leads
Free Skool community sharing AI automation workflows, tutorials, and business systems.
Open-source agent workflow finding leads on Quora and exporting to Google Sheets
Step-by-step terminal workflow for building scored B2B lead lists
A cold outreach tactic targeting angry competitor reviewers mid-churn.
Updated