Companies with contacts, city by city — into a spreadsheet

The scenario searches the map for companies by your query, pulls email and contacts from their sites and files a ready base into a spreadsheet — with no duplicates.

  • Company search across a list of cities
  • Email and contacts — from the site page
  • Duplicates are filtered out automatically
  • A ready base in asproCloud
Set it up for yourselfScriptera

How it works

To move data from asproCloud to automatically, use a ready-made scenario — no manual exports.

  1. Starts when: When Executed by Another Workflow
  2. Then: already scraped
  3. Then: Array all Companies scraped
  4. Then: Searchword
  5. Then: search Place
  6. Then: Split Out
  7. Then: Place Details
  8. Check: Places already scraped
  9. If yes: Get Impressum-URL
  10. Check: Loop Over Items3
  11. Check: Successfully scraped Impressumpages?
  12. Check: Loop Over Items1
  13. Check: Email not Empty
  14. Then: Edit Fields1
  15. Then: Write in DB
  16. Then: Relevant Infos from Impressum
  17. Then: Wait
  18. Then: Get Impressum HTML
  19. Then: HTML
  20. Then: Wait2
  21. Then: OpenAI Chat Model
  22. Starts when: When clicking ‘Execute workflow’
  23. Then: Airtable2
  24. Check: Filter5
  25. Check: Loop Over Items2
  26. Then: Execute Workflow
  27. Then: Airtable1

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

Similar scenarios