Build local business lead lists with SpecStream and 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 15 nodes and runs when someone submits an n8n form (“Build a local business lead list”). Along the way it connects Google Sheets. It also calls api.specstream.ai over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Build a local business lead list”).
- Write the request (Edit Fields (Set)): sets 3 fields: request, count, max_cents
- Read the request (HTTP Request): calls api.specstream.ai (POST)
- Clear enough to price? (If): checks a condition and branches into true / false
- Get the price (HTTP Request): calls api.specstream.ai (POST)
- Stop: reword the request (Stop and Error): stops the run with an error
- Within your maximum? (If): checks a condition and branches into true / false
- Approve and start (HTTP Request): calls api.specstream.ai (POST)
- Stop: price above your maximum (Stop and Error): stops the run with an error
- Wait: waits 30 seconds
- Check progress (HTTP Request): calls an HTTP API (GET)
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.specstream.ai
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)
- 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 - Stop and Error
n8n-nodes-base.stopAndError - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick Overview This workflow collects a business type and city via an n8n form, uses the SpecStream API to price and run a web-based business search, then writes the resulting business details (including website, phone, and source URL) into Google Sheets. How…