A company list by industry and city — straight into a sheet

Give the form an industry and a city — the scenario walks the directory, collects names, phones, websites and addresses and writes them as rows into your sheet.

  • One line in: the industry and the city
  • It collects not just names but phones and websites too
  • Several pages of results are walked, not just the first
  • A ready call list — with no copy-pasting
n8n FormGoogle
Set it upScriptera

How it works

To pass leads from Affinity to Web Form automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: Submit Search Query
  2. Then: Text Search Page 1
  3. Check: Has Next Page? (Page 2)
  4. If yes: Wait 5s (1)
  5. Then: Text Search Page 2
  6. Check: Has Next Page? (Page 3)
  7. If yes: Wait 5s (2)
  8. Then: Text Search Page 3
  9. Check: Merge All Pages
  10. Then: Split out the Results
  11. Then: Get Place Details
  12. Then: Format the Output for Google Sheets
  13. Then: Append rows in the Google Sheet

You can launch this Affinity + Web Form integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios