AI-powered Google Maps business scraper with enrichment & export to 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 24 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects OpenRouter Chat Model and Google Sheets.
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Search Google Maps with query (HTTP Request): calls an HTTP API
- Loop over queries (Loop Over Items (Split in Batches)): loops over the items in batches
- Scrape URLs from results (Code): runs custom JavaScript code
- Execute scraper for query (Execute Sub-workflow): calls another n8n workflow
- Filter: keeps only the items that match a condition
- Update row in sheet (Google Sheets): update
- Remove Duplicate URLs (Remove Duplicates): removes duplicate items
- Wait: waits 20 minutes
- Loop over URLs (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 11 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 (15)
- Remove Duplicates
n8n-nodes-base.removeDuplicates - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Wait
n8n-nodes-base.wait - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Aggregate
n8n-nodes-base.aggregate - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge
From the author
Overview This workflow automates the discovery, extraction, enrichment, and storage of business information from Google Maps search queries using AI tools, scrapers, and Google Sheets. It is ideal for: Lead generation agencies Local business researchers…