🎣 Build local business lead lists with SpecStream and Google Sheets
⚡ 1 views · 🎣 Lead Generation & Enrichment
Description
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 it works
- Receives a form submission with the business type, city, optional condition, desired number of businesses, and a maximum budget.
- Builds a single request sentence and sends it to SpecStream to parse into a runnable query.
- Requests a SpecStream price quote for the desired number of results and stops with an error if the request is not runnable or the quote exceeds the provided maximum price.
- Approves the quote to start the SpecStream execution and polls SpecStream every 30 seconds until the run is no longer queued, planning, or running.
- Fetches all result rows from SpecStream with pagination, flattens each row into one item with business fields plus Source, Read at, and a link to the SpecStream list.
- Appends the rows into the selected Google Sheets spreadsheet and worksheet, inserting new columns if extra fields are returned.
Setup
- Create a SpecStream API key and add it to an n8n HTTP Bearer Auth credential used by the SpecStream HTTP Request steps.
- Connect a Google Sheets credential and select the target spreadsheet and worksheet in the Google Sheets append step.
- Open the n8n form URL for the workflow, submit a test request, and confirm the resulting rows appear in your sheet.
🔗 Nodes Used
Google Sheets, HTTP Request, Stop and Error, n8n Form Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File