The Scenario
Three support tickets in your inbox this morning. All three customers say their license key stopped working. To respond to any of them, you need to know the key's status, its activation count, and whether it was issued to the email the customer claims they used.
You don't have a lookup sheet. The license key data is in Lemon Squeezy, accessible only by navigating to the License Keys section, filtering by product, and searching manually.
Your support admin has eight other tickets to get through today. They do not have time to do manual lookups in the Lemon Squeezy dashboard for every key inquiry.
The bad version:
- Open Lemon Squeezy License Keys, filter to the product, search for the first customer's email
- Note the key string, status, and activation count
- Go back, search for the second customer, repeat
- Find that one customer's email doesn't match what's in Lemon Squeezy because they purchased under a different address
Three tickets, three manual lookups. If you had 30 tickets, this would consume the entire support morning.
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 license key list for a product into your workbook in one pass.
Export every license key from my Lemon Squeezy store into this sheet with the key string, current status, and the customer email it was issued to
What You Get
- Column A: license key string
- Column B: current status (active, inactive, expired, disabled)
- Column C: customer email
- One row per key, all keys for the store in a single pull, searchable with Ctrl+F or VLOOKUP
What If the Data Is Not Quite Ready
You want activation counts for seat management
Fetch all Lemon Squeezy license keys for the product ID in cell A1 and list each key, status, customer email, and activation count into columns A through D
You want to flag keys that are over the seat limit
Export all Lemon Squeezy license keys for product ID in cell A1 — write key, status, customer email, and activation count into columns A through D — flag any key with more than 3 activations in column E
You only want expired keys for a reactivation outreach list
Fetch all Lemon Squeezy license keys with expired status and write key string, customer email, and expiry date into columns A through C
Full support lookup workbook 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 so support can find any key with a quick VLOOKUP
One workbook. Every support lookup answered without opening the Lemon Squeezy dashboard.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook your support team uses for lookups, 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.