Skip to content
Founder Workflows
Browse
Browse by stage

Send a Monday business metrics email from Stripe, Notion and Sheets with Claude writing the narrative in n8n

A shared n8n template pulls last week's Stripe revenue, Notion deal pipeline and a Sheets row of support numbers, has Claude write a three-paragraph summary, and emails and posts it to Slack.

DocumentedMeasurementSmall SaaSOnline serviceScheduled automationConnected tools

Evidence: The source shows its work: steps, screenshots, code or data you can inspect.

The business problem

A founder with revenue, sales and support numbers in three places has to open each one to understand how the week went.

What was tried

A Monday 08:00 trigger works out last week's date window in your timezone. The workflow reads all Stripe charges for that window, queries a Notion deals database with a date filter, and reads the latest operations row (tickets closed, NPS, uptime) from Google Sheets. It combines them into one set of figures with fallbacks for missing values, asks Claude to write a three-paragraph narrative on revenue, pipeline and operations, builds an HTML email with KPI cards and a stage table, sends it through SendGrid and posts a one-line summary to Slack. An error trigger emails the failed step.

What was reported (not reported)

The template reports no results from real use. It shows the working structure and the settings you need to fill in.

Limitations

A template page with no usage data and no publication date (the page shows an update about five months ago). The Stripe pagination handling is the author's own statement, a fixed 350 ms delay is used to stay under Notion's rate limit, and only the latest row of the Sheets tab is read. Missing operations figures show as N/A rather than stopping the run. The narrative is written by a language model from three numbers, so check it against the figures before acting. It needs several credentials, including a Stripe secret key.

What you need

An n8n instance, Stripe, Notion and Google accounts, an Anthropic API key, a SendGrid account and a Slack channel, plus about a dozen environment variables.

Sources

Source published: unknown. Last reviewed here: October 11, 2026. Spot a mistake? Tell us.

Tools in this workflow

Related workflows