Finatune
← Payments & Revenue Operations

MRR Dashboard Updater with Stripe MCP and Claude

Payments & Revenue Operations

Beginner1-2 hoursLow
n8nStripe MCPClaude (Anthropic API)Google Sheets

Quick Answer

Pull Stripe subscription data daily, calculate MRR components with n8n, update a Google Sheets dashboard automatically, and deliver weekly Claude commentary on revenue trends every Monday morning.

The Problem This Solves

Subscription businesses need current MRR data but most teams calculate it manually from Stripe exports. The dashboard is always days or weeks stale. This workflow keeps MRR metrics current daily and adds AI trend commentary weekly.

About This Workflow

Monthly Recurring Revenue is the most important metric for subscription businesses, yet many teams calculate it manually from Stripe exports on an ad-hoc basis. This workflow pulls subscription data from Stripe MCP daily, calculates MRR, new MRR, churned MRR, expansion MRR, and net MRR change, updates a Google Sheets dashboard automatically, and delivers a weekly Claude commentary on revenue trends every Monday. Leadership always has current MRR data without waiting for a finance team export.

Tools Required

Stripe MCPData SourceView on FinatuneVisit Website
Claude (Anthropic API)AI EngineView on FinatuneVisit Website
Google SheetsOutputVisit Website

Step-by-Step Blueprint

1

Schedule daily MRR update

n8n

Create an n8n Schedule trigger to run every day at midnight. Daily updates ensure the dashboard reflects any subscription changes from the previous day.

2

Pull active subscriptions from Stripe MCP

Stripe MCP

Add an n8n HTTP node to call Stripe MCP and retrieve all active subscriptions with their current plan amounts. Also retrieve subscriptions that churned or started in the past 24 hours for daily movement tracking.

3

Calculate MRR components

n8n

Add an n8n Code node to calculate: Total MRR from all active subscriptions, New MRR from subscriptions started today, Churned MRR from subscriptions cancelled today, Expansion MRR from upgrades today, Net MRR change for the day.

4

Update Google Sheets MRR dashboard

Google Sheets

Add n8n Google Sheets nodes to update the daily MRR row in your dashboard. Append today's figures to maintain a running history for trend analysis.

5

Generate weekly Claude commentary on Mondays

Claude

Add an n8n IF node that triggers only on Mondays. Pull the past 4 weeks of MRR data from Google Sheets and send to Claude for trend commentary covering growth rate, churn trends, expansion contribution, and notable weekly movements.

Use this prompt →
6

Post weekly commentary to Slack

n8n

On Mondays only, add a Slack action to post Claude's MRR trend commentary to your revenue or leadership channel alongside the current MRR figure.

Cost Estimate

$50-100/month

n8n Cloud Pro $50/month or self-hosted free. Stripe MCP free with Stripe account. Claude API costs minimal for weekly commentary. Google Sheets free.

Related Resources

MCP Servers

More Workflows in This Category

IntermediateFailed Payment Recovery Automation with Stripe MCP and Claude

Automatically detect failed Stripe payments, use Claude to draft personalized recovery emails based on failure reason, and trigger a multi-step recovery sequence.

AdvancedRevenue Recognition Checker with Stripe MCP and Claude

Automatically pull subscription and payment data from Stripe, check revenue recognition timing against ASC 606 principles with Claude, and flag items requiring manual review.

BeginnerSubscription Churn Early Warning with Stripe MCP and Claude

Monitor Stripe subscription data weekly for churn signals, use Claude to identify at-risk customers, and deliver an early warning report to your customer success team.