Automate lead generation from Google Search & Maps to Google Sheets
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 36 nodes and runs when a chat message arrives. Along the way it connects Google Sheets. It also calls googleapis.com over HTTP.
How it runs
Trigger: When a chat message arrives.
- Setting Pagination (Code): runs custom JavaScript code
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Prepare Query for Maps (Code): runs custom JavaScript code
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Loop for Multiple Page Search (Loop Over Items (Split in Batches)): loops over the items in batches
- Set URL for Validation (Edit Fields (Set)): sets 1 field: URL
- Scrape Google Maps (HTTP Request): calls an HTTP API
- Set URL Validaiton (Edit Fields (Set)): sets 1 field: URL
- If: checks a condition and branches into true / false
- Custom Google Search API (HTTP Request): calls googleapis.com
…plus 25 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.com
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 (11)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Remove Duplicates
n8n-nodes-base.removeDuplicates - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter - Wait
n8n-nodes-base.wait - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge
From the author
This n8n template from Intuz provides a complete solution to automate on-demand lead generation. It acts as a powerful scraping agent that takes a simple chat query, scours both Google Search and Google Maps for relevant businesses, scrapes their websites for…