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

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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
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.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.