Find nearby ZIP codes by radius with Searchbug and Google Sheets
Ready for 3.0What this workflow does
This workflow has 15 nodes and runs when someone submits an n8n form (“Zip Code in Radius Search”). Along the way it connects Google Sheets. It also calls data.searchbug.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Zip Code in Radius Search”).
- Single or Bulk? (If): checks a condition and branches into true / false
- Normalize Input (Edit Fields (Set)): sets 3 fields: Zip, Distance, Min Population
- Extract CSV (Extract from File): extracts data from a file
- Set Search Input (Edit Fields (Set)): sets 3 fields: ZIP, DIST, MIN_POP
- Validate Input (If): checks a condition and branches into true / false
- Zip Code in Radius API (HTTP Request): calls data.searchbug.com (POST)
- Set Invalid Row (Edit Fields (Set)): sets 4 fields: message, api_status, zip…
- Check Results (If): checks a condition and branches into true / false
- Attach Search Context (Edit Fields (Set)): sets 4 fields: center_zip, requested_distance, min_population…
- No Results (Edit Fields (Set)): sets 2 fields: message, api_status
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: data.searchbug.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 (7)
- n8n Form Trigger
n8n-nodes-base.formTrigger - If
n8n-nodes-base.if - Extract from File
n8n-nodes-base.extractFromFile - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow collects a ZIP code and a mile radius from an n8n form, queries the Searchbug Zip Code in Radius API for matching ZIP codes, and appends each result — city, state, distance, population, and business counts — as its own row in…