Loading...

Stripe

Payments, subscriptions, invoices and customers from your Stripe account.

The Stripe connector brings into the sheet payments, balance transactions, refunds, disputes, payouts, customers, subscriptions and invoices from your Stripe account.

Authentication works differently from other connectors: instead of an OAuth login, it uses a read-only restricted key created from your Stripe Dashboard (Developers > API keys > Create restricted key). When connecting you also choose a connection name, useful to tell multiple Stripe accounts apart; the mode (Test or Live, based on the key's rk_test_/rk_live_ prefix) always stays visible in parentheses next to the name.

Only one category per report: Payments, Balance Transactions, Refunds, Disputes, Payouts, Customers, Subscriptions and Invoices are eight separate data sources that cannot be combined in the same report (mixing them returns a clear error instead of a wrong result). The category is shown in parentheses for each entry below.

Required permissions

  • Balance: Read : Required: also used to validate the key when you connect.
  • Charges: Read : Needed for the Payments category.
  • Customers: Read : Needed for the Customers category.
  • Billing: Read : Needed for the Subscriptions and Invoices categories.
  • Payment Intents: Read : Needed for the Refunds category.
  • Payment Disputes: Read : Needed for the Disputes category.
  • Payouts: Read : Needed for the Payouts category.

Available metrics

Metric Period Aggregation Note
Count (Payments)
Amount (Payments)
Amount Captured (Payments)
Amount Refunded (Payments)
Average Amount (Payments)
Count (Balance Transactions)
Gross (Balance Transactions)
Fee (Balance Transactions)
Net (Balance Transactions)
Count (Refunds)
Amount (Refunds)
Count (Disputes)
Amount (Disputes)
Count (Payouts)
Amount (Payouts)
Count (Customers)
New Customers (Customers)
Count (Subscriptions)
New (Subscriptions)
Canceled (Subscriptions)
Quantity (Subscriptions)
MRR (Subscriptions)
Churn Rate - by count, totals only (Subscriptions)
Churn Rate - by MRR, totals only (Subscriptions)
Count (Invoices)
Total (Invoices)
Subtotal (Invoices)
Tax (Invoices)
Amount Due (Invoices)
Amount Paid (Invoices)
Amount Remaining (Invoices)

Available dimensions

Dimension Note
Date (Payments)
Status (Payments)
Currency (Payments)
Payment Method / Card Brand (Payments)
Card Country (Payments)
Billing Country (Payments)
Failure Code (Payments)
Failure Message (Payments)
Risk Level (Payments)
Customer (Payments)
Description (Payments)
Date (Balance Transactions)
Available On (Balance Transactions)
Type (Balance Transactions)
Reporting Category (Balance Transactions)
Currency (Balance Transactions)
Status (Balance Transactions)
Date (Refunds)
Reason (Refunds)
Status (Refunds)
Currency (Refunds)
Date (Disputes)
Reason (Disputes)
Status (Disputes)
Currency (Disputes)
Arrival Date (Payouts)
Status (Payouts)
Method (Payouts)
Currency (Payouts)
Created Date (Customers)
Country (Customers)
Currency (Customers)
Delinquent (Customers)
Email (Customers)
Status (Subscriptions)
Created Date (Subscriptions)
Canceled Date (Subscriptions)
Cancel At Period End (Subscriptions)
Product (Subscriptions)
Price (Subscriptions)
Billing Interval (Subscriptions)
Collection Method (Subscriptions)
Date (Invoices)
Status (Invoices)
Billing Reason (Invoices)
Currency (Invoices)
Period Start (Invoices)
Period End (Invoices)

Known limits

  • Max rows per report
    Up to 2,500 rows per category (5,000 for Subscriptions, to include subscriptions opened before the report period but still active, needed to correctly calculate MRR and Churn).
  • Missing permission on a category
    If the restricted key lacks the read permission needed for the chosen category, the report fails with an error naming exactly which permission is missing - the other categories remain usable with the same key.
  • Reason often empty
    The "Reason" field (Refunds/Disputes) is empty when the refund was created without explicitly selecting a reason (e.g. from the Dashboard without using the dropdown): this is genuinely missing data on Stripe's side, not a connector error.

Execution notes

MRR and Churn (Subscriptions category) are calculated by us, Stripe does not expose them directly: MRR normalizes any billing interval (yearly, weekly, etc.) to a monthly basis, excludes free-trial subscriptions (trialing) by default, and only percentage discounts reduce it (fixed-amount discounts are excluded). Churn (both by subscription count and by lost MRR) is a ratio computed across the whole report, it does not make sense on a single row.

Amounts and currencies: automatically converted from Stripe's smallest unit (e.g. cents) based on the currency, including zero-decimal currencies (e.g. JPY) and three-decimal ones (e.g. BHD). Currency is never summed across different connections/currencies.

Dates: shown in the Google Sheet's own timezone, not UTC.