A company contact database from Google Maps

The scenario searches Google Maps by your queries, pulls contacts from company sites, scores them and files the best per company into Ldap.

  • Company search on your queries — automatic
  • Contacts pulled straight from their sites
  • Duplicates removed, best contact kept
  • A ready list — in Ldap
Set it upScriptera

How it works

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

  1. Starts when: Run workflow
  2. Check: Loop over queries
  3. Then: Search Google Maps with query
  4. Then: Check for Next Page Token
  5. Check: Has Next Page?
  6. If no: Extract Places Data
  7. Then: Split Out Places
  8. Check: Filter Operational Businesses
  9. Check: Check if Website Exists
  10. If yes: Fetch Website HTML
  11. Then: Extract Contact Links
  12. Check: Filter Contact Links
  13. Then: Fetch Contact Page HTML
  14. Then: Combine Homepage and Contact HTML
  15. Then: Extract Emails from HTML
  16. Check: Filter Valid Emails
  17. Then: Group by Business
  18. Then: Score and Rank Emails
  19. Then: Sort by Email Quality
  20. Then: Keep Best Email Only
  21. Then: Remove Duplicate Emails
  22. Check: Merge Emails with Business Data
  23. Check: Merge All Businesses
  24. Then: Remove Duplicate Businesses
  25. Then: Append to Google Sheets

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

Similar scenarios