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

Description

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

Fill in the built-in form with a business type (e.g. "plumber") and location (e.g. "Miami, FL")
The workflow launches the Apify Google Maps Scraper actor and polls every 10 seconds until the run completes
Results are filtered — only businesses with at least one 1-star review continue
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

Apify credential — Create a free account at apify.com, generate an API token, and add it as an HTTP Header Auth credential in n8n named Apify Token (header name: Authorization, value: Bearer YOUR_TOKEN)
Google Sheets credential — Connect a Google Sheets OAuth2 account in n8n
Sheet ID — Open the Build Search Query node and replace YOUR_GOOGLE_SHEET_ID_HERE with your Google Sheet ID (found in the sheet URL: docs.google.com/spreadsheets/d/{SHEET_ID}/edit)
Activate the workflow — your unique form URL will appear in the Form Trigger node

Requirements

Apify account (free tier includes ~$5 monthly usage credits — enough for dozens of searches)
Google account with Google Sheets access