Find local GMB leads with 1-star reviews using Apify and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs when someone submits an n8n form (“GMB Lead Finder”). Along the way it connects Google Sheets. It also calls api.apify.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“GMB Lead Finder”).
- Build Search Query (Edit Fields (Set)): sets 3 fields: search_query, location, googleSheetId
- Start Apify Scraper Run (HTTP Request): calls api.apify.com (POST)
- Poll Apify Run Status (HTTP Request): calls an HTTP API
- Run Completed? (If): checks a condition and branches into true / false
- Run Succeeded? (If): checks a condition and branches into true / false
- Wait: waits 10 seconds
- Fetch Scraped Dataset (HTTP Request): calls an HTTP API
- Stop and Error: stops the run with an error
- Has 1-Star Reviews? (If): checks a condition and branches into true / false
- Create Tab for This Run (Google Sheets): create
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Wait
n8n-nodes-base.wait - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Stop and Error
n8n-nodes-base.stopAndError
From the author
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…