The Scenario
Your growth team has been asking for a churn analysis for six weeks. Every time it comes up, the answer is the same: someone needs to pull the data from Stripe first. That someone is you, and every time you've opened Stripe to start, something else came up.
Today you actually have a free hour. You open Stripe, navigate to Subscriptions, filter by status "canceled," set a 90-day date range, and discover there is no bulk export for subscriptions — only a paginated table you'd have to scroll through and record manually, or an API call you'd need to write.
The bad version:
- Copy the visible subscription rows from Stripe's UI into a Google Sheet, 25 at a time, re-navigating pagination after each page.
- Notice that the plan name column shows the internal price ID, not the human-readable plan name, and spend 20 minutes cross-referencing price IDs against the product catalogue.
- Realise the 90-day filter includes a period when you ran a promotional discount, inflating churn in that cohort, and have no clean way to flag those rows.
Your growth team is waiting for the analysis. What you actually need is the data in a sheet where you can run the cohort logic — not another afternoon translating Stripe's UI into rows.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Stripe, pulls the subscription records matching your criteria, and writes them into the sheet with readable field names — no pagination, no ID-to-name translation.
Fetch all Stripe subscriptions with status 'canceled' from the last 90 days and write customer email, plan name, amount, start date, and cancellation date into Sheet1
What You Get
- Sheet1 fills with one row per cancelled subscription: customer email, human-readable plan name, monthly amount, subscription start date, and cancellation date.
- Plan names are resolved from the associated price and product — not raw price IDs.
- Cancellation dates are formatted as readable dates.
- The row count tells you exactly how many cancellations the query returned.
What If the Data Is Not Quite Ready
You want to sort by amount descending to find the highest-value churned accounts first
Export every cancelled Stripe subscription from the last 90 days into Sheet1, sorted by amount descending, with customer email, plan name, amount, start date, and cancellation date
You need to flag subscriptions cancelled during the promotional discount window (March 1–March 31)
Fetch all cancelled Stripe subscriptions from the last 90 days, write them into Sheet1 with customer email, plan name, amount, start date, and cancellation date — add a column F that says 'promo period' if the cancellation date falls between March 1 and March 31, otherwise leave it blank
You want a second tab summarising churn by plan
Fetch all cancelled Stripe subscriptions from the last 90 days and write the full list into Sheet1 — then on Sheet2 write a summary table showing each plan name and the count of cancellations and total monthly value lost for that plan
The full kill chain — pull, flag promo cohort, group by plan, and calculate lifetime value lost in one shot
Fetch all Stripe subscriptions cancelled in the last 90 days, flag promo-period cancellations in column F, write the full list into Sheet1 sorted by amount descending, and summarise cancellations and total MRR lost by plan on Sheet2 — put the grand total MRR lost in Sheet2 cell B1
The pattern: ask for the segmentation and the summary in the same prompt. SheetXAI runs the filtering and grouping inline.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you use for retention or revenue analysis — then ask it to pull your cancelled Stripe subscriptions into the sheet. For related reads, see how to export paid Stripe invoices or identify customers with no active subscription.