The Scenario
The growth team asked for LTV by geography before Thursday's strategy session. It's Wednesday afternoon.
You have 800 customers in Lemon Squeezy. You need name, email, country, total revenue, and subscription status in an Excel workbook so you can pivot by country and find the high-LTV cohorts worth targeting.
Lemon Squeezy has a customer list. It does not have a single export that includes revenue per customer and the customer's country in the same file.
The bad version:
- Export the customer list (name, email, country — no revenue)
- Pull order totals separately, aggregate by email in a pivot table
- Join the two datasets by email — find the 30 where capitalization differences break the match
- Get subscription status from a third export, join it in as well
- Get asked at the strategy session why 12 rows have blank revenue values
Three separate exports, two joins, and you still don't trust the data completely.
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 customer list with revenue metrics in a single pass.
Export the full Lemon Squeezy customer list into this Excel sheet, one row per customer, with email, total orders, total revenue, and subscription status
What You Get
- Column A: customer email
- Column B: total number of orders placed
- Column C: total lifetime revenue in dollars
- Column D: current subscription status (active, none, cancelled, etc.)
- One row per customer, headers in row 1
What If the Data Is Not Quite Ready
You need country included for the geography analysis
Fetch all Lemon Squeezy customers and write name, email, country, total revenue, and MRR into columns A through E of this workbook sheet
You want to filter to customers above a revenue threshold
Fetch all Lemon Squeezy customers with total lifetime revenue over $200 and write email, country, total revenue, and MRR into columns A through D
You want to segment into separate worksheets by region
Pull all Lemon Squeezy customers — write US customers to the US sheet and all others to the International sheet — each with email, total revenue, and MRR
Full LTV segmentation pull in one shot
Fetch all Lemon Squeezy customers with email, country, total revenue, and MRR in columns A through D — add a column E that tags each customer as High (over $500), Mid ($100 to $500), or Low (under $100) based on total revenue, and sort descending by total revenue
Strategy session ready. Geography pivot in two clicks.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you're building for Thursday's strategy session, then ask it to pull your Lemon Squeezy customer base with the revenue and geography fields you need. You can also pull subscription data into the same workbook.