The Scenario
You've built a churn cohort analysis template. It's been sitting in a tab called "DRAFT - do not use" for six weeks because you can't get the underlying data into it.
You have 340 Lemon Squeezy subscriptions across three plans. Some are active. Some cancelled. A few are paused. To run the cohort analysis you need subscriber email, plan name, status, monthly amount, and start date — one row per subscription, all 340 of them.
Lemon Squeezy shows you subscriptions in a filtered list. There is no export button that gives you all five of those fields in a single file.
The bad version:
- Filter to Active subscriptions, export what's available, open the CSV, note that plan name and MRR aren't included as separate columns
- Repeat for Cancelled, repeat for Paused, now merge three files
- Manually look up MRR for each plan tier because the export doesn't break out billing amounts the way your model expects
The "DRAFT - do not use" tab is about to become "DRAFT - still do not use" for another month.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Lemon Squeezy through its built-in integration and pulls the full subscription list — regardless of status — into your sheet in one pass.
List all Lemon Squeezy subscriptions and write subscriber email, product name, variant/plan name, status, and billing interval into columns A through E
What You Get
- Column A: subscriber email
- Column B: product name
- Column C: variant or plan name (e.g., "Pro Monthly", "Starter Annual")
- Column D: subscription status (active, cancelled, paused, past_due)
- Column E: billing interval (monthly or annual)
- All statuses in a single pull — no separate filter runs needed
- Headers in row 1, one row per subscription
What If the Data Is Not Quite Ready
You want MRR normalized to monthly amounts
List all active Lemon Squeezy subscriptions and write subscriber email, plan name, billing interval, and MRR amount normalized to monthly in column D — annuals divided by 12 — plus subscription start date in column E
You want cancelled subscriptions separated from active ones
Pull all Lemon Squeezy subscriptions and write them into this sheet — active subscriptions in one tab named Active, cancelled in a tab named Cancelled, with email, plan, status, and start date in both
You want to join subscription data against a customer segment list
For each email in column A of the Segments tab, look up their Lemon Squeezy subscription status and write the plan name and status into columns B and C of that tab
Full churn analysis pull in one shot
Pull all Lemon Squeezy subscriptions into this sheet with subscriber email, plan name, status, monthly MRR, and subscription start date — then add a column F showing months-since-start calculated from today's date, and flag any cancelled subscription that lasted fewer than 60 days in column G
One prompt replaces four manual steps.
Try It
Get the 7-day free trial of SheetXAI and open the spreadsheet where your churn cohort model lives, then ask it to pull the full subscription list in the format your analysis expects. You can also export order history or customer LTV data into the same workbook.