Extract business emails from Google Maps to Google Sheets for lead generation
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 14 nodes and runs when a chat message arrives. Along the way it connects Google Sheets.
How it runs
Trigger: When a chat message arrives.
- Scrape Google Maps (HTTP Request): calls an HTTP API
- Extract URLs (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Remove Duplicates: removes duplicate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Wait: pauses before continuing
- Scrape Site (HTTP Request): calls an HTTP API
- Filter: keeps only the items that match a condition
- Wait: waits 1 seconds
- Split Out: splits a list into separate items
…plus 3 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 (9)
- Remove Duplicates
n8n-nodes-base.removeDuplicates - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger
From the author
How it Works This workflow builds a free lead generation system that scrapes emails from Google Maps listings and exports them directly into Google Sheets. It’s built in n8n using HTTP requests and JavaScript—no paid APIs required. Here’s what it does at a…