{"product_id":"n8n-workflow-google-reviews-automation-with-supabase-claude-sonnet-slack","title":"n8n Workflow: Google Reviews Automation with Supabase, Claude Sonnet \u0026 Slack","description":"\u003ch3\u003eTurn new Google reviews into approved, published responses—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every three hours to detect new Google Business Profile reviews, dedupe and log them in \u003cstrong\u003eSupabase\u003c\/strong\u003e, analyze sentiment with \u003cstrong\u003eClaude Sonnet\u003c\/strong\u003e, draft concise replies, and send higher-risk cases to \u003cstrong\u003eSlack\u003c\/strong\u003e for human approval before publishing via an HTTP endpoint.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled review ingestion:\u003c\/strong\u003e Triggers every 3 hours to fetch the latest reviews (demo data you can replace with the \u003cem\u003eGoogle Business Profile Reviews API\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduping with Supabase:\u003c\/strong\u003e Checks the Supabase \u003ccode\u003ereviews\u003c\/code\u003e table for existing review IDs and filters duplicates\/unprocessed items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI analysis \u0026amp; drafting:\u003c\/strong\u003e Processes each new review one at a time using Anthropic to classify \u003cstrong\u003esentiment, topics, and urgency\u003c\/strong\u003e, then drafts a concise public reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalation safeguards:\u003c\/strong\u003e Routes by sentiment and runs an additional AI escalation check plus rule-based safeguards to decide whether human approval is required.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStructured logging:\u003c\/strong\u003e Saves the full review record—analysis, drafted reply, priority, and statuses—into the Supabase \u003ccode\u003ereviews\u003c\/code\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack approval loop:\u003c\/strong\u003e For risky cases, posts the review + proposed response to Slack and waits for an \u003cstrong\u003eapprove\/reject\u003c\/strong\u003e decision via a resume link (with a timeout).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublish \u0026amp; insight capture:\u003c\/strong\u003e Approved replies are published through a configured \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e (replace with the Google Business Profile Reply API). The workflow updates statuses in Supabase and stores per-review feedback in \u003ccode\u003efeedback_insights\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a consistent, fast response cadence to customer Google reviews without manual triage.\u003c\/li\u003e\n  \u003cli\u003eReduce reputational risk by routing negative\/urgent reviews to Slack approval before posting.\u003c\/li\u003e\n  \u003cli\u003eBuild a searchable internal feedback history using Supabase insights for ongoing improvement.\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 \/ logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003ewait\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e Supabase tables: \u003ccode\u003ereviews\u003c\/code\u003e and \u003ccode\u003efeedback_insights\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e Anthropic (Claude Sonnet) for sentiment\/topic\/urgency analysis and draft replies.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishing:\u003c\/strong\u003e HTTP endpoint for replies (swap to Google Business Profile Reply API).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46206053548211,"sku":"N8N-20779","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2O1b1xNkN4emXNRVb6Aue_DUmLgEx7.png?v=1791796180","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-reviews-automation-with-supabase-claude-sonnet-slack","provider":"N8N Commerce","version":"1.0","type":"link"}