The Scenario
You sell a 3-seat desktop app and you've been seeing something strange in your support queue. Customers with legitimate 3-seat purchases are getting activation errors saying their seats are full. Meanwhile, a handful of other customers have apparently activated well beyond the limit with no complaints.
You have 50 license IDs in Column A of an Excel sheet — the ones flagged by your activation service as potentially anomalous. You need to pull every instance record from Lemon Squeezy for each of those keys to see the actual activation count and identify which ones are over the limit.
The bad version:
- Open Lemon Squeezy, navigate to License Keys, click into license 1
- Click to the Instances section, count the instances, note any over 3
- Navigate back, find license 2, repeat
- Fifty licenses means fifty separate navigation paths
- Lose your place at license 34 when someone sends you a Slack message, start that section over
Fifty licenses. Fifty clicks. Half a day gone.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the license IDs in Column A and connects to Lemon Squeezy through its built-in integration to pull instance data for all 50 in one pass.
Fetch all license key instances for the key ID in cell A1 and list each instance's identifier and activation date in this sheet
What You Get
- Instance identifier (the machine or device ID)
- Activation created date
- One row per instance for that key
What If the Data Is Not Quite Ready
You need to process all 50 IDs in Column A at once
For each license key ID in Column A, list all instances from Lemon Squeezy and write the instance ID, identifier, and created date into columns B through D — flag rows in Column E where instance count exceeds 3
You only want to see keys that are over the seat limit
For each license key ID in Column A, fetch the Lemon Squeezy instance count and write the key ID and count into columns A and B — only include rows where instance count is greater than 3
You want to see deactivated instances alongside active ones
For the license key ID in cell A1, fetch all instances including deactivated ones and write instance ID, identifier, status, and created date into columns A through D
Full abuse detection sweep in one shot
For each license key ID in Column A (50 rows), fetch all Lemon Squeezy instances, write key ID, instance count, and all instance identifiers into columns B, C, and D — flag any key where instance count exceeds 3 in column E, sort by instance count descending so the worst cases appear first
Fifty keys analyzed in one pass. Abuse cases identified before the end of the morning.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your flagged license IDs, then ask it to pull instance counts and flag the over-activated keys. You can also pull your full license key list or customer records into the same workbook.