Summarize Google Reviews into monthly owner digests with Claude and Supabase
Ready for 3.0What this workflow does
This AI workflow has 28 nodes and runs on a schedule (every month at 08:00) (plus 3 other triggers). Along the way it connects Google Business Profile, Anthropic and Microsoft Outlook. It also calls mybusinessbusinessinformation.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every month at 08:00) (plus 3 other triggers).
- Get Reviews (Google Business Profile): get many (review)
- Load Test Set (Code): runs custom JavaScript code
- List Locations With Names (HTTP Request): calls mybusinessbusinessinformation.googleapis.com
- Normalize Reviews (Code): runs custom JavaScript code
- Run Config (Code): runs custom JavaScript code
- Fetch Stored (HTTP Request): calls an HTTP API
- Select Unclassified (Code): runs custom JavaScript code
- Has New Reviews? (If): checks a condition and branches into true / false
- Build Classify Prompt (Code): runs custom JavaScript code
- Fetch Last Report (HTTP Request): calls an HTTP API
…plus 14 more steps. See the full node list below.
Services it uses
HTTP calls to: mybusinessbusinessinformation.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Business Profile
n8n-nodes-base.googleBusinessProfile - Code
n8n-nodes-base.code - Anthropic
@n8n/n8n-nodes-langchain.anthropic - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview Pulls Google Business Profile reviews, classifies each one with Claude, stores them in Supabase, and emails the owner a monthly plain-English digest via Outlook. Every count, disagreement and trend is computed in code, never by the model, so…