N8N Workflow: Find Google Maps Businesses w/ Unanswered Reviews

Find Google Maps businesses with unanswered reviews—automatically

This n8n workflow takes a business category and location via webhook, scrapes recent Google Maps reviews using Apify, and ranks businesses that received low-star reviews (≤2) with no owner reply—then saves the opportunities in Supabase and publishes a shared Google Sheet with the results.

What this workflow does

• Receives inputs via POST webhook: accepts a category and location, plus optional rating/review count/result limits.
• Validates and normalizes parameters, then creates a running request record in Supabase (Postgres).
• Scrapes Google Maps reviews with Apify (Google Maps Reviews Scraper) for the provided search term and captures errors if the scrape fails.
• Groups reviews by business and identifies low-star (≤2) reviews that have no owner response.
• Scores and ranks opportunities using your minimum rating and review-count thresholds, then stores the top results in Supabase as opportunities.
• Creates a Google Sheet report, writes ranked opportunities into it, and shares the sheet publicly as read-only.
• Returns results to the webhook with the ranked list and the Google Sheet URL, and marks the request as completed in Supabase.

Use cases

• Local marketing teams identifying businesses with unanswered negative reviews to prioritize outreach.
• SaaS operators running automated research pipelines for lead generation by location and category.
• Automation engineers building repeatable n8n workflows that turn scraped Google Maps data into actionable lists.

Technical details

• n8n nodes/tools: webhook, code, postgres, http request, Google Drive, sticky note.
• Integrations: Apify (HTTP Header Auth token: Authorization: Bearer <YOUR_APIFY_TOKEN>), Supabase Postgres, Google Sheets OAuth, Google Drive OAuth.
• Required tables: create automation_requests and opportunities with the expected columns.