Generate business leads with OpenStreetMap data and save 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 22 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- HTTP Request: calls an HTTP API
- Execute Workflow (Execute Sub-workflow): calls another n8n workflow
- Extract List (Edit Fields (Set)): sets or maps fields
- Wait: pauses before continuing
- Split Out: splits a list into separate items
- Set Output Fields (Edit Fields (Set)): sets or maps fields
- Organize Data (Code): runs custom JavaScript code
- Has No Website? (If): checks a condition and branches into true / false
- Append Items (No Website and/not Email) (Merge): merges the data from its input branches
…plus 9 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 (14)
- Wait
n8n-nodes-base.wait - No Operation, do nothing
n8n-nodes-base.noOp - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Filter
n8n-nodes-base.filter - Merge
n8n-nodes-base.merge - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Who is this template for? This n8n lead generation workflow template is designed for business owners, marketers, sales professionals, and entrepreneurs who need to generate targeted business leads without paying for expensive APIs or third-party services. The…