The Scenario
Someone on the growth team dropped a Notion doc in Slack on Monday: "We need LTV by geography before the strategy session." The strategy session is Thursday. It's now Wednesday afternoon.
You have 800 customers in Lemon Squeezy. You need their name, email, country, total revenue, and MRR in a spreadsheet so you can run a pivot by country and identify which cohorts are worth targeting for the next campaign.
Lemon Squeezy does have a customer list. It does not have a single export that gives you all five of those fields together. Revenue-per-customer lives in a different part of the dashboard from the customer's country.
The bad version:
- Export the customer list CSV (name, email, country — no revenue)
- Export or manually collect revenue data from the orders view
- Join the two by email address, find the 40 where the email formatting doesn't match exactly, fix those manually
- Get the MRR column from somewhere else entirely
By the time this is done, the strategy session will be starting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and connects to Lemon Squeezy through its built-in integration to pull the full customer list — with revenue metrics — in a single pass.
Fetch all customers from my Lemon Squeezy store and write name, email, country, total revenue, and MRR into columns A through E of this sheet
What You Get
- Column A: customer name
- Column B: customer email
- Column C: country code (e.g., US, GB, DE)
- Column D: total lifetime revenue for that customer
- Column E: current MRR (0 for non-subscribers)
- One row per customer, headers in row 1
What If the Data Is Not Quite Ready
You want to filter to customers above a revenue threshold
Fetch all Lemon Squeezy customers with total revenue over $100 and write their name, email, country, and total revenue into columns A through D
You need subscription status alongside revenue
List all Lemon Squeezy customers and write email, country, total revenue, MRR, and current subscription status into columns A through E
You want to segment by country into separate tabs
Pull all Lemon Squeezy customers into this sheet and split them across tabs by country — US customers in a US tab, UK customers in a UK tab, everyone else in an Other tab — with email and total revenue in each
Full LTV segmentation in one shot
Fetch all Lemon Squeezy customers and write email, country, total revenue, and MRR into columns A through D — then add a column E that tags each row as High (over $500), Mid ($100 to $500), or Low (under $100) based on total revenue, and sort the sheet by revenue descending
One prompt, analysis ready for Thursday.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you're building a customer LTV model, then ask it to pull your Lemon Squeezy customer base with the revenue fields you need. You can also pull subscription data or order history into the same workbook.