Workflow Flow
Schedule Trigger (Monday 8am)
↓
Parallel Data Pull
┌────┬────┬────┐
Stripe GA4 CRM
↓
Aggregate + Structure Data
↓
OpenAI — Generate Narrative
↓
Format as HTML Email
↓
┌─────┬─────┐
Email Slack Notion
Send Post Save Nodes Required
| Node | Purpose |
|---|---|
| Schedule Trigger | Monday 8am, your timezone |
| HTTP Request (×3) | Stripe, GA4, CRM data pull |
| Code | Aggregate and normalize metrics |
| OpenAI Chat | Write executive narrative from data |
| HTTP Request (Resend) | Email report to stakeholders |
| Slack | Post summary card |
| Notion | Archive full report |
ROI Calculation
| Before | After |
|---|---|
| 3–5h of manual data pulling per week | 0 minutes |
| Reports delayed until midweek | In your inbox Monday 8am sharp |
| Inconsistent format week-to-week | Identical structured format always |
Configuration Variables
STRIPE_SECRET_KEY Revenue and MRR data
GA4_PROPERTY_ID Traffic and conversion data
OPENAI_API_KEY Narrative generation
REPORT_RECIPIENTS Comma-separated email list
NOTION_DATABASE_ID For archiving reports