Stripe and Resend: Weekly MRR Roll-Up Email Template

A weekly Spojit workflow that totals your active Stripe subscriptions into a monthly-recurring-revenue figure and emails the roll-up to finance through Resend.

What It Builds

A Schedule trigger fires once a week, then a Stripe Connector node pulls every active subscription and a Transform node sums their normalized monthly amounts into a single MRR total. A Resend Connector node then sends the formatted summary to your finance distribution list. The result is a hands-off, repeatable revenue snapshot in your inbox.

The Prompt

Paste this into Miraxa and it builds the workflow, connecting the tools for you:

Build a workflow that runs every Monday at 7am, totals all active Stripe subscriptions into a monthly recurring revenue figure, and emails the roll-up to finance@company.com through Resend with the total MRR, active subscriber count, and the date range covered.

Connectors Used

Schedule trigger - fires the workflow on a weekly cron.
Stripe - lists active subscriptions and their amounts.
Resend - sends the roll-up email from your own domain.

Customize It

Change every Monday at 7am to any cadence (daily, monthly), swap finance@company.com for a shared address, and edit the listed fields to add churned counts, new MRR, or currency breakdowns. You can also point the email at a Slack channel instead by naming Slack in the prompt.

Tips

Give your Stripe key read scope on subscriptions and prices so totals stay accurate.
Use the Stripe node in Direct mode for a predictable list with no AI cost; switch to Agent mode only if you want it to reason over mixed billing intervals.
Normalize annual plans to a monthly figure in the prompt so yearly subscriptions do not overstate MRR.