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. An n8n automation workflow template by Poghos Adamyan.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• http-request
• code

Capabilities

• 3 nodes
• 1 views

Information