Find local businesses with one-star reviews

From a city and niche the scenario gathers business data from the maps, keeps those with one-star reviews and drops the lead list into a dedicated sheet tab.

  • Warm leads — businesses with bad reviews
  • You set just the city and niche
  • A separate tab for each query
  • A ready list instead of manual searching
n8n Form
Set it up for yourselfScriptera

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: GMB Lead Form
  2. Then: Build Search Query
  3. Then: Start Apify Scraper Run
  4. Then: Poll Apify Run Status
  5. Check: Run Completed?
  6. If yes: Run Succeeded?
  7. If yes: Fetch Scraped Dataset
  8. Check: Has 1-Star Reviews?
  9. If yes: Create Tab for This Run
  10. Then: Transform & Format GMB Data
  11. Then: Write Results to Sheet
  12. If no: Stop and Error
  13. If no: Wait Before Retry

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