Track MRR, churn, LTV, and payment volume in Google Sheets — updated automatically every time Stripe fires a webhook. No CSV downloads, no manual reconciliation, no code.
What you'll build: A Google Sheet that receives every Stripe payment, subscription, refund, and churn event in real time. On a dashboard tab, formulas calculate MRR, ARR, churn rate, and payment volume automatically — always current, always accurate.
Stripe's built-in dashboard is excellent for payment operations, but it's limited for custom analytics. You can't easily slice MRR by pricing plan and acquisition channel simultaneously. You can't blend Stripe data with your CRM data. And you can't share a live revenue view with someone who doesn't have Stripe access.
Google Sheets solves all of this. Combined with Autometon's real-time webhook routing, your Stripe data flows into a spreadsheet you control — where you can apply any formula, chart, or sharing permission you need.
Stripe's webhook system supports dozens of event types. For revenue analytics, these are the ones that matter:
Log in to Autometon, click New Pipeline, select Stripe as your source. Autometon generates a webhook URL and configures HMAC signature verification for Stripe automatically — every incoming event is authenticated against your Stripe webhook signing secret.
In your Stripe dashboard, go to Developers → Webhooks → Add endpoint. Paste your Autometon webhook URL. Select the event types you want to track (start with payment_intent.succeeded and customer.subscription.*). Copy the webhook signing secret and paste it into Autometon.
Use Stripe's "Send test webhook" button to fire a sample event. Autometon receives it and auto-detects all available fields: amount, currency, customer_id, subscription_id, plan_id, metadata, and more.
Map the Stripe fields to your sheet columns. Recommended: Timestamp, Event Type, Amount (in dollars — Autometon can divide Stripe's cents by 100 automatically), Currency, Customer Email, Subscription ID, Plan Name, Status.
Share your Google Sheet with Autometon's service account email and click Activate. Stripe events now flow to your sheet in real time. Build your revenue dashboard on a second tab using SUMIF, COUNTIF, and pivot tables.
Filter invoice.paid events for the current month. Sum the amount column. For true MRR, exclude one-time charges by filtering on subscription_id not being blank.
=SUMIFS('Raw Data'!D:D,'Raw Data'!B:B,"invoice.paid",'Raw Data'!A:A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1))
Count customer.subscription.deleted events divided by total active subscriptions at the start of the period. Track monthly and chart the trend over time.
Sum all payment_intent.succeeded amounts minus all charge.refunded amounts for the period. This is the number that matters for reconciliation.
Total MRR divided by count of active customer.subscription.created records with no corresponding deleted event.
Autometon verifies every Stripe webhook using HMAC-SHA256 signature verification. When you add your Stripe webhook signing secret to Autometon, every incoming payload is validated before being processed. Unsigned or tampered webhooks are rejected automatically — no spoofed payment events can reach your sheet.
invoice.paid events to Google Sheets via Autometon. Each payment writes a row with the amount, date, subscription ID, and customer data. A SUMIF formula on the Dashboard tab calculates MRR for the current month automatically — no manual entry required.Real-time payment data in Google Sheets. No code, no CSV exports, no manual reconciliation.
Get Started Free