{"product_id":"n8n-workflow-find-google-maps-businesses-w-unanswered-reviews","title":"N8N Workflow: Find Google Maps Businesses w\/ Unanswered Reviews","description":"\u003ch3\u003eFind Google Maps businesses with unanswered reviews—automatically\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inputs via POST webhook\u003c\/strong\u003e: accepts a category and location, plus optional rating\/review count\/result limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes parameters\u003c\/strong\u003e, then creates a \u003cem\u003erunning\u003c\/em\u003e request record in \u003cstrong\u003eSupabase (Postgres)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes Google Maps reviews with Apify\u003c\/strong\u003e (Google Maps Reviews Scraper) for the provided search term and captures errors if the scrape fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroups reviews by business\u003c\/strong\u003e and identifies low-star (≤2) reviews that have \u003cstrong\u003eno owner response\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores and ranks opportunities\u003c\/strong\u003e using your minimum rating and review-count thresholds, then stores the top results in Supabase as \u003cstrong\u003eopportunities\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Google Sheet report\u003c\/strong\u003e, writes ranked opportunities into it, and shares the sheet publicly as read-only.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns results to the webhook\u003c\/strong\u003e with the ranked list and the \u003cstrong\u003eGoogle Sheet URL\u003c\/strong\u003e, and marks the request as completed in Supabase.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLocal marketing teams identifying businesses with \u003cem\u003eunanswered negative reviews\u003c\/em\u003e to prioritize outreach.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators running automated research pipelines for lead generation by location and category.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building repeatable n8n workflows that turn scraped Google Maps data into actionable lists.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools\u003c\/strong\u003e: webhook, code, postgres, http request, Google Drive, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: \u003cstrong\u003eApify\u003c\/strong\u003e (HTTP Header Auth token: \u003cem\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/em\u003e), \u003cstrong\u003eSupabase Postgres\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e OAuth.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired tables\u003c\/strong\u003e: create \u003ccode\u003eautomation_requests\u003c\/code\u003e and \u003ccode\u003eopportunities\u003c\/code\u003e with the expected columns.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081434910899,"sku":"N8N-19864","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/AhZcCcLfT2K5qny7BflwF_SSJmMKWM.png?v=1790241266","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-find-google-maps-businesses-w-unanswered-reviews","provider":"N8N Commerce","version":"1.0","type":"link"}