Build a company base from maps by niche and city into a table

The scenario collects companies from maps by niche and city, cleans duplicates and stores the contacts in a table.

  • A company base by niche and city
  • Phones and addresses — straight into a table
  • Duplicates removed automatically
  • Minutes instead of days of manual work
n8n FormScrape Business Data from Google MapsGoogle Sheets
Connect the data collector and runScriptera

How it works

To connect firecrawl and Web Form, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Form Submission Trigger
  2. Then: Generate City List
  3. Then: Categorize Service Type
  4. Then: Separate Data by City
  5. Check: Process Cities in Batches
  6. Then: Get Existing Business Data
  7. Then: Check for Duplicate Entries
  8. Check: Process Duplicates in Batches
  9. Then: Find Duplicate Row Number
  10. Then: Delete Duplicate Row
  11. Then: Scrape Business Data from Google Maps
  12. Check: Check Scraping Status
  13. If yes: Check Data Collection Status
  14. Then: Wait for Rate Limiting
  15. Check: Check if Data Ready
  16. If yes: Fetch Scraped Data
  17. Then: Save Business Data to Sheet
  18. Then: Claude AI Model for Cities
  19. Then: Claude AI Model for Categories

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

Similar scenarios