AutomationMart
Home/Browse/Find local GMB leads with 1-star reviews using Apify and Google Sheets
n8n

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

n8nn8n13 modulesv1.0
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
Find local GMB leads with 1-star reviews using Apify and Google Sheets workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Who is this for? This workflow is ideal for virtual assistants, researchers, developers, automation specialists, and data analysts who need to regularly extract and organize structured product information (like books) from a website. It’s especially useful for those working with catalog-based websites who want to automate extraction and delivery of clean, sorted data. --- 🧩 What problem is this solving? Manually copying product listings like book titles and prices from a website into a spreadshe

Free

✍️ AI agent to create Linkedin posts for blog promotion with GPT-4o

Tags: Automation, AI, Marketing, Content Creation Context I’m a Supply Chain Data Scientist and content creator who writes regularly about data-driven optimization, logistics, and sustainability. Promoting blog articles on LinkedIn used to be a manual task — until I decided to automate it with N8N and GPT-4o. This workflow lets you automatically extract blog posts, clean the content, and generate a professional LinkedIn post using an AI Agent powered by GPT-4o — all in one seamless automation. &

Free

Send leads to Google Sheets and to your iOS device for new Facebook Lead Ads leads

Automatically send notifications and add new Facebook Lead Ads leads to Google Sheets. Keep your team updated with instant iOS alerts for every lead.

Free

Organize your YouTube video database with Google Sheets

Effortlessly manage and track your YouTube video collection using Google Sheets. Save time with a structured, easy-to-access database, making it simple to organize, find, and analyze your content for improved efficiency and performance.

Free

Save new posts from Canny to a Google Sheets spreadsheet

Every time there is a new post in Canny, Make will automatically create a new row in your Google Sheets spreadsheet. The template uses this [example spreadsheet](https://goo.gl/eEPPai).

Free

Extract purchase orders from Gmail using Gemini AI and save to Google Sheets

AI-Powered Email to Purchase Order Workflow Automatically scan your inbox for new purchase order requests, extract order details using Gemini AI, and log them into Google Sheets — all without manual effort. --- ✨ Core Capabilities - ⏱ Runs every minute to check unread emails - 📧 Filters emails by subject - 🤖 Uses Gemini AI to summarize email content & extract structured order details - 📅 Formats dates into ISO calendar weeks - 📊 Adds product data from Google Sheets to complete order info

Free

YouTube Videos to Viral X Threads by Keywords (using Gemini & Claude)

Who is this for? Content creators, marketers, and social media managers who want to turn high-performing YouTube videos into viral X (Twitter) threads using keywords (without manual research). Perfect for anyone looking to systematically create engaging social content from proven video sources. --- What problem does it solve? Finding viral content ideas and writing engaging threads is time-consuming and hit-or-miss. This workflow automates the entire process: discovers high-performing YouTube vi

Free

Research Kuaishou creator videos from a keyword with JustOneAPI

Quick overview Use this n8n workflow template to search Kuaishou creators by keyword and get their published video list with JustOneAPI.This template is for creator research teams, marketing teams, creator operations teams, analysts, and automation builders who want to turn a Kuaishou keyword into a structured list of creator videos inside n8n. How it works 1. The workflow starts with a single configuration node where you add your JustOneAPI token and the keyword you want to research. 2. It then

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free