The Scenario
Your support inbox has three open tickets this morning — customers claiming their license key isn't working. To answer any of them, you need to know the key's current status, how many activations it has, and whether it's been issued to the email address the customer says they used to purchase.
You don't have that information in front of you. Lemon Squeezy has a License Keys section in the dashboard, but it's filtered by product and paginated. To look up a specific key by customer email, you have to search manually. To get a full export of all keys for a product — key string, status, activation count, customer email — there is no button that does that.
The bad version:
- Open the License Keys view, filter to the relevant product
- Manually find each customer's key by scrolling or searching by email
- Note down the status and activation count for each ticket
- Repeat for every ticket, every time a new one comes in
Support is supposed to answer tickets, not conduct manual database lookups. Three tickets is annoying. Thirty is a crisis.
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 license key list into your sheet — all at once, searchable.
Fetch all Lemon Squeezy license keys for the product ID in cell A1 and list each key, its status, customer email, and activation count into columns A through D
What You Get
- Column A: license key string
- Column B: status (active, inactive, expired, disabled)
- Column C: customer email the key was issued to
- Column D: current activation count
- One row per key, headers in row 1, all keys for that product in a single pull
What If the Data Is Not Quite Ready
You want to flag keys that have never been activated
Fetch all Lemon Squeezy license keys for product ID in cell A1 and write each key, status, customer email, and activation count into columns A through D — flag keys with activation count of 0 in column E as Inactive
You need to look up one key by customer email
Find the Lemon Squeezy license key for the customer email in cell A1 and write the key string, status, and activation count into cells B1, C1, and D1
You want to pull keys across multiple products
For each product ID listed in column A of the Products tab, fetch all license keys and write product ID, key string, status, and customer email into the Keys tab — one row per key
Full support lookup sheet in one shot
Pull all Lemon Squeezy license keys for the product ID in cell A1, write key, status, customer email, activation count, and creation date into columns A through E, sort by customer email alphabetically, and flag any key with status expired or disabled in column F
One sheet. Every support lookup answered in a VLOOKUP.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet used by your support team, then ask it to pull the full license key list for your product. You can also pull customer records or order history into the same workbook.