Generate business leads from Google Maps & Places API 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 workflow has 9 nodes and runs when someone submits an n8n form (“Generate Leads”). Along the way it connects Google Sheets. It also calls maps.googleapis.com and places.googleapis.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Generate Leads”).
- Main Set (Edit Fields (Set)): sets 4 fields: location, googleApiKey, maxResults…
- Get Location Coordinates (HTTP Request): calls maps.googleapis.com
- Prepare Search Data Set (Edit Fields (Set)): sets 6 fields: latitude, longitude, businessType…
- Search Google Places (HTTP Request): calls places.googleapis.com (POST)
- Split Results (Split Out): splits a list into separate items
- If: checks a condition and branches into true / false
- Format Lead Data (Edit Fields (Set)): sets 13 fields: businessName, address, phone…
- Append row in sheet (Google Sheets): append
Services it uses
HTTP calls to: maps.googleapis.com, 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 (6)
- HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - n8n Form Trigger
n8n-nodes-base.formTrigger - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets
From the author
Overview This workflow automates the process of generating niche-specific business leads from Google Maps, leveraging the Google Places API and Google Sheets for seamless data collection and storage. Who Is This For? - Business owners, marketers, sales teams,…