n8n Workflow: Google Reviews Automation with Supabase, Claude Sonnet & Slack

Turn new Google reviews into approved, published responses—automatically

This n8n workflow runs every three hours to detect new Google Business Profile reviews, dedupe and log them in Supabase, analyze sentiment with Claude Sonnet, draft concise replies, and send higher-risk cases to Slack for human approval before publishing via an HTTP endpoint.

What this workflow does

• Scheduled review ingestion: Triggers every 3 hours to fetch the latest reviews (demo data you can replace with the Google Business Profile Reviews API).
• Deduping with Supabase: Checks the Supabase reviews table for existing review IDs and filters duplicates/unprocessed items.
• AI analysis & drafting: Processes each new review one at a time using Anthropic to classify sentiment, topics, and urgency, then drafts a concise public reply.
• Escalation safeguards: Routes by sentiment and runs an additional AI escalation check plus rule-based safeguards to decide whether human approval is required.
• Structured logging: Saves the full review record—analysis, drafted reply, priority, and statuses—into the Supabase reviews table.
• Slack approval loop: For risky cases, posts the review + proposed response to Slack and waits for an approve/reject decision via a resume link (with a timeout).
• Publish & insight capture: Approved replies are published through a configured HTTP endpoint (replace with the Google Business Profile Reply API). The workflow updates statuses in Supabase and stores per-review feedback in feedback_insights.

Use cases

• Maintain a consistent, fast response cadence to customer Google reviews without manual triage.
• Reduce reputational risk by routing negative/urgent reviews to Slack approval before posting.
• Build a searchable internal feedback history using Supabase insights for ongoing improvement.

Technical details

• n8n nodes / logic: if, set, code, wait, slack, switch.
• Data storage: Supabase tables: reviews and feedback_insights.
• AI: Anthropic (Claude Sonnet) for sentiment/topic/urgency analysis and draft replies.
• Publishing: HTTP endpoint for replies (swap to Google Business Profile Reply API).