Scrape and enrich Google Maps business leads with ScrapeUnblocker and Google Sheets
UnknownWhat this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Scrapeunblocker (community). It also calls nominatim.openstreetmap.org over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Keyword & City (Edit Fields (Set)): sets 2 fields: keyword, city
- Scrape Unblocker: uses Scrape Unblocker
- Extract Map Listings (Code): runs custom JavaScript code
- Clean & Dedupe Leads (Code): runs custom JavaScript code
- Loop over Leads (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Adresses (HTTP Request): calls nominatim.openstreetmap.org
- Parse the output (Code): runs custom JavaScript code
- Save Leads to Sheet (Google Sheets): append
Services it uses
HTTP calls to: nominatim.openstreetmap.org
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-scrapeunblocker is verified or supports 3.0 (used in ScrapeUnblocker).
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Scrape Unblocker
n8n-nodes-scrapeunblocker.scrapeUnblocker - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Quick Overview This workflow scrapes Google Maps search results for a chosen keyword and city using ScrapeUnblocker, extracts and deduplicates business leads, reverse-geocodes each listing’s coordinates with OpenStreetMap Nominatim, and appends the enriched…