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
At a glance
Find local GMB leads with 1-star reviews using Apify and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 13
- Price
- Free
- Version
- v1.0

About this workflow
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 1. 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 YOURTOKEN) 2. Google Sheets credential — Connect a Google Sheets OAuth2 account in n8n 3. Sheet ID — Open the Build Search Query node and replace YOURGOOGLESHEETIDHERE with your Google Sheet ID (found in the sheet URL: docs.google.com/spreadsheets/d/{SHEETID}/edit) 4. 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
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Scrape books from URL with Dumpling AI, clean HTML, save to Sheets, email as CSV
✍️ AI agent to create Linkedin posts for blog promotion with GPT-4o
Send leads to Google Sheets and to your iOS device for new Facebook Lead Ads leads
Organize your YouTube video database with Google Sheets
Save new posts from Canny to a Google Sheets spreadsheet
Extract purchase orders from Gmail using Gemini AI and save to Google Sheets
YouTube Videos to Viral X Threads by Keywords (using Gemini & Claude)
Research Kuaishou creator videos from a keyword with JustOneAPI
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you