Extract leads from Google Maps into Google Sheets using the Places API
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs when someone submits an n8n form (“Scrape Google Maps leads”) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls places.googleapis.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Scrape Google Maps leads”) (plus 1 other trigger).
- Merge: merges the data from its input branches
- Get rows in QUERIES (Google Sheets): uses Google Sheets
- Google Places Search (HTTP Request): calls places.googleapis.com (POST)
- Discard empty queries (Filter): keeps only the items that match a condition
- Split Out: splits a list into separate items
- Map Places Fields (Edit Fields (Set)): sets 11 fields: source_id, name, address…
- Append or update lead row (Google Sheets): append or update
- If: checks a condition and branches into true / false
- Mark Query as Scraped (Google Sheets): update
Services it uses
HTTP calls to: places.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 (9)
- HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - n8n Form Trigger
n8n-nodes-base.formTrigger - Filter
n8n-nodes-base.filter - If
n8n-nodes-base.if
From the author
Who is this for This workflow is designed for sales teams, marketing professionals, and business developers who want to automate lead generation. It is ideal for budget-conscious individuals or small businesses looking to collect structured contact…