Email daily revenue ops briefs with Google Sheets, Supabase, and Claude
Ready for 3.0What this workflow does
This workflow has 18 nodes and runs on a schedule (cron 0 7 * * *) (plus 1 other trigger). Along the way it connects Supabase and Google Sheets. It also calls api.anthropic.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 7 * * *) (plus 1 other trigger).
- Fetch Active Clients (Supabase): get many
- Check Signup Information (Code): runs custom JavaScript code
- Loop Over Clients (Loop Over Items (Split in Batches)): loops over the items in batches
- Add Client to Supabase (Supabase): uses Supabase
- Read Revenue from Sheets (Google Sheets): uses Google Sheets
- Build Success Notification (Code): runs custom JavaScript code
- Reply with Insert Error (Respond to Webhook): sends the response back to the webhook caller
- Calculate Stats and Spot Anomalies (Code): runs custom JavaScript code
- Reply with Success (Respond to Webhook): sends the response back to the webhook caller
- Email Welcome Message (Send Email): sends an email over SMTP
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.anthropic.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 (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Supabase
n8n-nodes-base.supabase - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Send Email
n8n-nodes-base.emailSend - No Operation, do nothing
n8n-nodes-base.noOp - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick overview This workflow sends daily operations briefs by reading each client’s revenue data from Google Sheets, analyzing week-over-week performance, generating a short summary with Anthropic Claude, emailing the brief via SMTP, and logging results in…