Перейти к содержанию
НОВОЕМаркетплейс и trig8n Agent: продавайте то, что создали, и получайте планы и изменения, проверенные до того, как вы их увидите. Что нового

Библиотека / Генерация и обогащение лидов

Генерация и обогащение лидов

Составление списков локальных бизнес-лидов с 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.

Шаги

  1. Describe the list
  2. Write the request
  3. Read the request
  4. Clear enough to price?
  5. Stop: reword the request
  6. Get the price
  7. Within your maximum?
  8. Stop: price above your maximum
  9. Approve and start
  10. Wait 30 seconds
  11. Check progress
  12. Finished?
  13. Get every row
  14. One row per business

Всего шагов: 15.

Похожие автоматизации