Manage Google reviews with Claude Sonnet, Supabase, and Slack
Needs changesWhat this workflow does
This AI workflow has 29 nodes and runs on a schedule (every 3 hours). Along the way it connects Supabase, Slack and Anthropic Chat Model. It also calls httpbin.org over HTTP.
How it runs
Trigger: On a schedule (every 3 hours).
- Get New Reviews (Code): runs custom JavaScript code
- Check Existing Review (Supabase): get many
- Filter Unprocessed Reviews (Code): runs custom JavaScript code
- Loop Over Reviews (Loop Over Items (Split in Batches)): loops over the items in batches
- Analyze Review with AI (AI Agent): runs an AI agent, with model: Anthropic Chat Model
- Generate AI Response (AI Agent): runs an AI agent, with model: Anthropic Chat Model
- Review Sentiment Router (Switch): routes items into 3 branches
- Positive Review (Edit Fields (Set)): sets 2 fields: review_path, response_strategy
- Neutral Review (Edit Fields (Set)): sets 2 fields: review_path, response_strategy
- Negative Review (Edit Fields (Set)): sets 2 fields: review_path, response_strategy
…plus 14 more steps. See the full node list below.
Services it uses
HTTP calls to: httpbin.org
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Analyze Review with AI (v1.7), Generate AI Response (v1.7), AI Escalation Check (v1.7)…: replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Analyze Review with AI (v1.7), Generate AI Response (v1.7), AI Escalation Check (v1.7), Generate Feedback Insight (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Supabase
n8n-nodes-base.supabase - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic
From the author
Quick overview This workflow runs every three hours to dedupe and log new customer reviews in Supabase, uses Anthropic to analyze sentiment and draft public replies, requests Slack approval for risky cases, publishes approved responses via an HTTP endpoint,…