The Scenario
Your churn model lives in Excel. It's been sitting in a workbook called Churn Analysis v3 FINAL for two months, unused, because you cannot get the subscription data into it.
You have 340 Lemon Squeezy subscriptions. The churn model needs subscriber email, plan name, status, MRR, and start date — one row per subscription. Lemon Squeezy doesn't have an export for that. You've looked.
The bad version:
- Export active subscriptions from Lemon Squeezy (missing MRR and plan name from the export)
- Export cancelled subscriptions separately
- Combine both files in Excel, add the MRR column manually by cross-referencing each plan tier's pricing
- Realize the start date format from the export doesn't match what your churn model's date formulas expect
- Spend 45 minutes on date formatting before the first COUNTIFS will run
The model exists. The data is trapped.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Lemon Squeezy through its built-in integration and pulls the full subscription list — all statuses, all fields — in one pass.
Export every active Lemon Squeezy subscription into this sheet with customer email, plan, MRR amount, and subscription start date — then add a column totalling MRR at the bottom of the MRR column
What You Get
- Column A: customer email
- Column B: plan name (e.g., Pro Monthly, Starter Annual)
- Column C: MRR in dollars
- Column D: subscription start date in Excel date format
- A totals row at the bottom of column C summing all MRR values
- One row per subscription
What If the Data Is Not Quite Ready
You want all statuses, not just active
List all Lemon Squeezy subscriptions and write subscriber email, product name, variant name, status, and billing interval into columns A through E of this workbook sheet
You want months-since-start calculated automatically
Pull all Lemon Squeezy subscriptions with subscriber email, plan, MRR, and start date into columns A through D — add a column E with months elapsed since start date calculated from today
You want to split active and cancelled into separate worksheets
Pull all Lemon Squeezy subscriptions — write active subscriptions to the Active worksheet and cancelled subscriptions to the Cancelled worksheet — each with email, plan, MRR, and start date
Full churn cohort pull in one shot
Pull all Lemon Squeezy subscriptions into this workbook with subscriber email, plan, status, MRR, and start date in columns A through E — add column F with months-since-start from today, flag any cancelled subscription that lasted fewer than 60 days in column G, and add a totals row at the bottom of the MRR column
Churn analysis v3 FINAL is finally usable.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your churn model lives, then ask it to pull the full subscription list in the format your model expects. You can also pull order history or customer LTV data into the same workbook.