n8nStripeGoogle SheetsOpenAI

Weekly KPI Report from Sheets + Stripe

An auto-generated owner's dashboard delivered to the inbox every Monday morning.

Difficulty: AdvancedTypical price: $600–$1,500

n8n nodes used

Schedule TriggerStripeGoogle SheetsOpenAIGmail

The problem it solves

Owners drown in dashboards and end up checking none. A single weekly email with the numbers that matter — plus a one-paragraph AI summary of what changed — is what they actually read.

Tools you'll need

Schedule Trigger — fires every Monday at 7am
Stripe node — pulls revenue, MRR, churn, refunds
Google Sheets node — pulls ops KPIs (leads, conversion, NPS)
OpenAI node — writes the plain-English summary
Gmail node — sends the formatted HTML email

Build steps in n8n

Check each step as you complete it — your progress is saved automatically in this browser.

0 of 7 steps complete0%

1Schedule Trigger: weekly, Monday 07:00 in the owner's timezone.
2Stripe node: list charges + subscriptions for last 7 days; Code node calculates MRR, new MRR, churned MRR, refund rate.
3Google Sheets node: read the ops tab for leads created, demos booked, conversion rate, NPS.
4Compare to the previous 7 days; compute deltas and % change.
5OpenAI node: pass all metrics + deltas → return a 4-sentence executive summary highlighting the 1 thing to celebrate and the 1 thing to fix.
6HTML template node assembles a clean email: summary on top, a metrics table, deltas color-coded.
7Gmail node sends to the owner (and optional CC to leadership).

Premade n8n workflow

Skip the setup — download this workflow and import it into your n8n instance.

Download workflow.json

Import in n8n: Workflows → Import from file. Then add your own credentials to each node.

What to charge

$600 for Stripe + one Sheet. $1,200–$1,500 with multi-source pulls (Stripe, GA4, HubSpot, Sheets), a hosted HTML dashboard link, and per-recipient personalization.

How to pitch it

"Every Monday at 7am the owner gets one email: the numbers that matter, what changed, and what to focus on this week. No login, no dashboard fatigue."