Библиотека / Генерация и обогащение лидов
Генерация и обогащение лидов
Составление списков локальных бизнес-лидов с SpecStream и Google Sheets
После отправки формы SpecStream ищет в интернете компании по виду деятельности и городу, затем записывает названия, сайты, телефоны и исходные страницы в Google Sheets.
Что делает
## 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.
Шаги
- 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.
Похожие автоматизации
Синхронизация данных и ETLSend daily federal grant digests to Slack and Google Sheets with SpecStreamШагов: 21Генерация и обогащение лидовГенерация лидов из Google Maps в Google SheetsШагов: 36Генерация и обогащение лидовГенерация лидов из Google Maps в Google SheetsШагов: 50Генерация и обогащение лидовСбор лидов из Google Maps с Bright Data и GeminiШагов: 20