Generate B2B leads by industry & location with Google Places API and Google Sheets
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs when someone submits an n8n form (“Enter your Query”). Along the way it connects Google Sheets. It also calls maps.googleapis.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Enter your Query”).
- Text Search Page (HTTP Request): calls maps.googleapis.com
- Has Next Page? (Page 2) (If): checks a condition and branches into true / false
- Merge: merges the data from its input branches
- Wait: pauses before continuing
- Split Out: splits a list into separate items
- Text Search Page (HTTP Request): calls maps.googleapis.com
- Get Place Details (HTTP Request): calls maps.googleapis.com
- Has Next Page? (Page 3) (If): checks a condition and branches into true / false
- Format the Output for Google Sheets (Code): runs custom JavaScript code
- Wait: pauses before continuing
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: maps.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 (8)
- HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - n8n Form Trigger
n8n-nodes-base.formTrigger - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
How it works 1. A form trigger accepts an Industry + Location query (e.g. Accountants London). 2. Text Search Page 1 calls Google Places Text Search to return results and a nextpagetoken. 3. Conditional checks + 5s wait nodes fetch page 2 and page 3 when a…