Automates scraping local GMB listings, filters for 1-star reviews, and exports structured leads to Google Sheets per run.
This AI agent automatically gathers local Google My Business listings using Apify's Google Maps Scraper. It then filters results to only include listings with at least one 1-star review. Finally, it exports the matched leads to a dedicated Google Sheet tab named per run, ready for outreach.
Automates data collection, filtering, and export for outreach.
Collects search parameters from the built-in form (business type and location).
Launches the Apify Google Maps Scraper run and monitors progress until completion.
Filters results to retain only listings with at least one 1-star review.
Creates a new Google Sheets tab named {query}-{timestamp} and appends all matching leads.
Includes full lead data: business name, GMB URL, city/address, primary/alternate phone numbers, email (if available), and 1-star review count.
Notifies you when the run completes and provides access to the new sheet.
This AI agent automates the process of identifying underperforming local businesses and exporting actionable leads to a structured sheet.
A simple three-step flow from query to usable leads.
Enter the business type and location in the built-in form to define the search parameters for the AI agent.
The AI agent starts the Apify Google Maps Scraper and polls for completion until results are ready.
The AI agent retains only 1-star listings, creates a new sheet tab named {query}-{timestamp}, and appends full lead data.
One supporting sentence with short explanation.
Scenario: A marketing agency needs 12 plumber leads in Miami, FL. The AI agent runs for 25 minutes, returns 12 qualifying listings with 1-star reviews and contact data, and creates a new Google Sheet tab named plumber-miami-20260427 containing business name, URL, address, phones, email (if available), low-rated review URL, and total 1-star count.
One supporting sentence.
Need scalable lists of local businesses with poor online reputations to pitch reputation-management services.
Want targeted lists of underperforming businesses to offer review-management services.
Seek new outreach targets and reputation cleanup opportunities.
Require quick access to local leads for outreach campaigns.
Need a reliable data source for local business contacts and review data.
Want to add a new service line around local business reputation and lead gen.
One supporting sentence with short explanation.
Fetches local business listings and review data based on the query.
Creates a per-run tab and appends all lead data for outreach.
One supporting sentence with short explanation.
One supporting sentence with short explanation.
This AI agent automates locating local businesses with 1-star Google reviews, collects essential lead data, and exports it to a per-run Google Sheet tab. It uses Apify's Google Maps Scraper to retrieve listings, filters to those with negative feedback, and formats the results for outreach. The workflow is designed to be repeatable, auditable, and ready for immediate use in reputation-management campaigns.
You need an Apify account to use the Google Maps Scraper and a Google account with Google Sheets access. The AI agent stores results only in your Google Sheet workspace and does not publish data externally. Credentials are used solely to drive the scraper and to write results into your sheet.
For each lead, you’ll get the business name, GMB profile URL, city/address, primary and alternate phone numbers, email if available, the lowest-ranked 1-star review URL, the 1-star review count, and the per-run timestamp. This data is appended to a per-run Google Sheet tab to support outreach and reporting.
Yes. The built-in form accepts the business type and location, and those parameters drive the scraper within the AI agent. You can adjust the target keywords and geography between runs, and each run creates a fresh, timestamped tab for organized tracking.
Yes. You can run separate executions for different locations. Each run creates its own tab, keeping data isolated and easy to audit. This makes it straightforward to compare performance across cities and campaigns.
If a run yields no 1-star results, the AI agent logs the outcome and completes without creating a per-run tab. You still receive a completion notification, but the sheet will not be updated with leads until a new run returns qualifying data.
Support focuses on setup and run troubleshooting for Apify and Google Sheets integration. You can adjust query parameters, monitor run status, and re-run as needed. If issues arise, you can reconfigure and initiate a new run with updated parameters.
Automates scraping local GMB listings, filters for 1-star reviews, and exports structured leads to Google Sheets per run.
