The Scenario
You sell a desktop app with a 3-seat license. Last week, you noticed a spike in support tickets from customers saying their activations are full — but they claim they only installed on two machines. Either something is wrong with your activation tracking, or some customers are sharing keys beyond the limit.
You have 50 license IDs in a column. You need to see every instance attached to each key — the instance identifier, when it was activated, and how many instances exist per key — so you can figure out which keys have been over-activated and which ones have legitimate complaints.
The bad version:
- Open Lemon Squeezy, navigate to License Keys, click into the first key to see its instances
- Note down the count, the identifiers, the activation dates
- Click back, find the next key, repeat
- Do this 50 times, manually building a spreadsheet as you go
Fifty keys means fifty separate clicks into the dashboard. By key 15 you'll have lost count.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the license IDs in your sheet and connects to Lemon Squeezy through its built-in integration to pull instance data for each one.
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
What You Get
- Column B: instance ID
- Column C: instance identifier (the machine or device identifier passed at activation)
- Column D: activation created date
- Column E: flagged with "Over limit" when a key has more than 3 instances
- One row per instance, grouped by key
What If the Data Is Not Quite Ready
You only care about keys over the seat limit
For each license key ID in Column A, fetch all Lemon Squeezy instances and write the key ID, instance count, and a flag into columns B, C, and D — only include keys where instance count exceeds 3
You want to see deactivated instances too
For the license key ID in cell A1, list all Lemon Squeezy instances — active and deactivated — and write instance ID, identifier, status, and created date into columns A through D
You need to cross-reference against customer emails
For each license key ID in Column A, fetch the customer email from Lemon Squeezy and the total instance count, and write both into columns B and C
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 is over 3 in column E, and sort the sheet by instance count descending so the worst offenders appear first
One pass through all 50 keys. Done before lunch.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you're tracking your license IDs, then ask it to pull instance data for each key and flag over-activations. You can also pull the broader license key list or customer records into the same workbook.