Generate a weekly business metrics report with Stripe, Notion, Sheets, Claude, SendGrid, and Slack

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 Google Sheets aggregates everything into a single structured dataset, hands it to Claude Sonnet 4 for executive analysis, and delivers a styled HTML report to your inbox before you've had your first coffee.

---

How it works

The workflow runs in five sequential stages:

1. Trigger & Date Setup Fires every Monday at 08:00. Computes last week's date window in your configured business timezone using Luxon, outputting ISO timestamps, Unix epochs, and milliseconds so every downstream node speaks the same time format without conversion.

2. Data Collection Fetches from three sources in sequence: - Stripe: Cursor-based pagination retrieves every charge in the window no 100 record cap, no missed revenue - Notion: Queries your Deals database with a date filter and a built-in 350ms rate-limit delay between pages to stay safely under the Notion API ceiling - Google Sheets: Reads the latest row from your ops metrics sheet for tickets closed, NPS score, and uptime percentage

3. Aggregation Normalises all three sources into a single structured item: gross and net revenue, refunds, transaction count, total and probability-weighted pipeline value, deal count by stage, and all operational KPIs. Every field has a safe fallback so missing data never crashes the report.