Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Build local business lead lists with SpecStream and Google Sheets
On form submission, SpecStream searches the live web for businesses matching a trade and city, then writes names, websites, phones and source pages to Google Sheets.
What it does
## Build a lead list of every local business in a city Type a trade and a city into the form. The workflow asks SpecStream for every match from the live web (maps, directories, each business's own site) and writes the rows to Google Sheets: name, website, phone, and the page each row came from. A Maps search stops at about 120 places. This keeps going until it has the number you asked for, up to 10,000. ### How it works 1. The form collects the trade, the city, an optional condition and your maximum price. 2. SpecStream reads the request and quotes the most it can cost. Nothing is spent yet. 3. If the quote is at or below your maximum, the workflow approves it. If not, it stops and tells you the price. 4. It checks every 30 seconds until the run ends, then writes one row per business to your sheet. ### Set up (5 minutes) 1. Get a free API key at specstream.ai under Agents & API. New accounts get $10 of work free, no card. 2. In n8n, create a Bearer Auth credential with the key and pick it in the five SpecStream HTTP nodes. 3. Connect Google Sheets and choose an empty sheet in Add rows to your sheet. The first run writes the headers. 4. Open the form URL from Describe the list and submit it. ### Price 10¢ a business for a plain list with phone and website, 30¢ when it has to meet a condition such as a rating. The workflow approves a quote only when it is at or below your maximum. You pay for the matches, and a run that finds nothing is free.
The steps
- Describe the list
- Write the request
- Read the request
- Clear enough to price?
- Stop: reword the request
- Get the price
- Within your maximum?
- Stop: price above your maximum
- Approve and start
- Wait 30 seconds
- Check progress
- Finished?
- Get every row
- One row per business
15 steps in total.
Similar automations
Data Sync & ETLSend daily federal grant digests to Slack and Google Sheets with SpecStream21 stepsWeb Scraping & ResearchAudit Google Maps local leads with Apify Local Lead Audit and Google Sheets8 stepsAI Agents & AssistantsRoute Chats to Local Ollama Models with Private Router7 stepsLead Generation & EnrichmentTurn company lists into verified prospect emails with Hunter.io and Google Sheets15 steps