Generate a weekly business metrics report with Stripe, Notion, Sheets, Claude, SendGrid, and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 13 nodes and runs on a schedule (cron 0 8 * * 1) (plus 1 other trigger). Along the way it connects Google Sheets, Anthropic Chat Model, SendGrid and Slack.
How it runs
Trigger: On a schedule (cron 0 8 * * 1) (plus 1 other trigger).
- Compute Date Windows (Code): runs custom JavaScript code
- Send Error Email (SendGrid): work with mail
- Stripe: This Week Revenue (Code): runs custom JavaScript code
- Notion: Pipeline This Week (Code): runs custom JavaScript code
- GSheets: Ops Metrics (Google Sheets): uses Google Sheets
- Aggregate All Metrics (Code): runs custom JavaScript code
- Claude: Write Executive Narrative (Basic LLM Chain): sends a prompt to an LLM, with model: Anthropic Chat Model
- Build HTML Report (Code): runs custom JavaScript code
- Send via SendGrid (SendGrid): work with mail
- Slack: uses Slack
Services it uses
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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - SendGrid
n8n-nodes-base.sendGrid - Slack
n8n-nodes-base.slack - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Stop compiling your weekly business report by hand. Let automation pull the numbers, and let Claude write the narrative. Every Monday morning, this workflow fetches last week's revenue from Stripe, pipeline data from Notion, and operational metrics from…