Stripe to Google Sheets: Complete Setup Guide (2026)

In this guide

Why sync Stripe to Google Sheets?
Which Stripe events to use
Step-by-step setup with Autometon
Building your revenue dashboard
Stripe webhook field reference
Frequently asked questions

Why Sync Stripe to Google Sheets?

Stripe's dashboard is excellent for processing payments — but it's not built for custom financial reporting, board-level revenue decks, or cross-tool data blending. Getting your Stripe data into the hands of finance teams, investors, or external accountants usually means manual CSV exports or expensive BI tools.

Google Sheets gives you a flexible, shareable alternative. With Autometon routing Stripe webhooks to Google Sheets, every charge, subscription renewal, and refund writes to your sheet the moment it fires. Build MRR dashboards, churn trackers, and revenue by customer segment — all with native Google Sheets formulas, updating live.

Which Stripe Events to Use

Revenue tracking

charge.succeeded — fires on every successful payment. The most important event for revenue tracking. Contains amount, customer ID, description, and payment method.

invoice.paid — fires when a subscription invoice is paid. Better for SaaS MRR tracking as it includes subscription plan details.

Subscription tracking

customer.subscription.created — new subscription. Use to track new MRR.

customer.subscription.deleted — cancellation. Use to track churn.

customer.subscription.updated — upgrade or downgrade. Use to track expansion/contraction MRR.

Refund tracking

charge.refunded — fires on full or partial refund. Contains refund amount and reason code.

Recommendation for SaaS: Start with invoice.paid and customer.subscription.deleted. These two give you MRR in and churn out.

Step-by-Step Setup with Autometon

Step 1: Create your Autometon pipeline

Step 2: Add the endpoint in Stripe

In Stripe Dashboard: Developers → Webhooks → Add endpoint. Paste your Autometon URL. Select the events you want to listen for — start with invoice.paid and customer.subscription.deleted. Save.

Step 3: Send a test event

Use Stripe's "Send test webhook" button to fire a test invoice.paid event. Autometon receives it and auto-detects all fields — amount, customer_id, subscription_id, plan details, and more.

Step 4: Map Stripe fields to sheet columns

Map amount_paid → Revenue, customer_email → Customer, lines.data[0].plan.nickname → Plan, created → Date. The AI mapper handles most of this automatically.

Step 5: Activate

Share your Google Sheet with Autometon's service account email and click Activate. Every Stripe event now writes a row in real time.

Building Your Revenue Dashboard in Google Sheets

Monthly Recurring Revenue (MRR)

=SUMIFS('Raw Data'!B:B,'Raw Data'!D:D,"invoice.paid",'Raw Data'!A:A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1))

Shows current month revenue from paid invoices. Updates with every new payment.

Churn rate

=COUNTIFS('Raw Data'!D:D,"subscription.deleted",'Raw Data'!A:A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1))

Count of cancellations this month. Divide by total active subscriptions for churn rate %.

Revenue by plan

Use a pivot table: rows = Plan, values = Revenue (Sum), filter = Event Type is invoice.paid. Shows MRR breakdown by plan tier, updating live.

Stripe Webhook Field Reference

Event	Field	Recommended Column
invoice.paid	`amount_paid`	Revenue (divide by 100 for $)
invoice.paid	`customer_email`	Customer
invoice.paid	`lines.data[0].plan.nickname`	Plan
charge.refunded	`amount_refunded`	Refund Amount
subscription.deleted	`plan.nickname`, `customer`	Churned Plan, Customer

Note: Stripe amounts are in the smallest currency unit (cents for USD). Divide by 100 in your sheet: =B2/100.

Frequently Asked Questions

Use Autometon. Add your Autometon webhook URL as a Stripe endpoint in Developers → Webhooks. Select the events to track (invoices, charges, subscriptions). Autometon receives each event and writes a row to your sheet in real time — no CSV exports, no manual work.

Stripe sends amounts in the smallest currency unit — cents for USD, pence for GBP, etc. A $99 charge arrives as 9900. Add a formula column: =B2/100 to convert to dollars. Autometon auto-detects this and can apply the conversion in the field mapping step.

Yes. Map the event type field to a Type column in your sheet. Use SUMIF to total invoice.paid events separately from charge.succeeded for one-time payments. Or set up two separate Autometon pipelines routing to different sheet tabs.

Yes. Autometon validates Stripe's HMAC webhook signatures to confirm every event genuinely comes from Stripe. Forged or tampered webhooks are rejected before they reach your sheet.

No. Stripe webhook payloads pass through Autometon directly to your Google Sheet. We never store payment amounts, customer emails, or any financial data — it lives in your Google Drive under your account.