Log nearby businesses from OpenStreetMap to Google Sheets by proximity
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 (“Local business discovery by proximity”). Along the way it connects Google Sheets.
How it runs
Trigger: When someone submits an n8n form (“Local business discovery by proximity”).
- Settings (Edit Fields (Set)): sets 7 fields: nominatimUrl, overpassUrl, userAgent…
- Geocode location (Nominatim) (HTTP Request): calls an HTTP API
- Location found? (If): checks a condition and branches into true / false
- Build Overpass query (Code): runs custom JavaScript code
- Find businesses (Overpass) (HTTP Request): calls an HTTP API (POST)
- Normalize businesses (Code): runs custom JavaScript code
- Append to results sheet (Google Sheets): append
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 (7)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Quick overview This workflow collects a location and business search criteria via an n8n form, geocodes the location with OpenStreetMap Nominatim, finds nearby matching businesses using the Overpass API, and appends normalized results (including website…