Find local GMB leads with 1-star reviews using Apify and Google Sheets

Overview

Automatically scrapes Google My Business listings using Apify's Google Maps Scraper, filters results to businesses with 1-star reviews, and exports structured lead data into a dedicated Google Sheet tab per run.

Ideal for agencies and freelancers identifying local businesses with poor online reputations — potential leads for reputation management or review response services.

How it works

1. Fill in the built-in form with a business type (e.g. "plumber") and location (e.g. "Miami, FL") 2. The workflow launches the Apify Google Maps Scraper actor and polls every 10 seconds until the run completes 3. Results are filtered — only businesses with at least one 1-star review continue 4. A new tab is created in your Google Sheet named {query}-{timestamp} and all matching leads are appended with full contact and review data

What you get per lead

- Business Name and GMB profile URL - City / Address - Primary and alternative phone number - Business email (if available) - Negative review URL (lowest-ranked review link) - Negative review URL with image attached - Total 1-star review count

Set up steps