The Scenario
Your Gumroad support inbox has forty-two messages in it. Almost all of them are some version of "my license key isn't working." You built a desktop tool, sold it on Gumroad, and now you're the one-person support team. You have a sheet with the keys people sent in. You've been checking them one by one in the Gumroad dashboard, copying the validity status, pasting it back. You've done twelve so far. Thirty to go.
The bad version:
- Open the Gumroad dashboard, navigate to the license key lookup tool, paste in the first key, note the status, switch tabs, type the status into column B, switch back, repeat.
- Discover that three of the keys have been used on four machines and Gumroad shows "over-used" — which is a different failure mode than "invalid" — and now you have to add a third status category you hadn't planned for.
- After an hour you've done twenty keys, your clipboard history is a mess of alphanumeric strings, and you're not sure you didn't mistype one somewhere in the middle.
You should be fixing the actual product bug that caused half these support tickets — not manually auditing a spreadsheet one cell at a time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the data in your sheet and calls the Gumroad license verification API for every key in your list, then writes the results back.
Here is the prompt for this task:
Verify each license key in column A of the License Audit tab against Gumroad product ID 'abc123' and write the validity status into column B and the use count into column C. Start from row 2.
What You Get
- Column B populated with the validity status for each key: "valid," "invalid," or "over-used."
- Column C populated with the current use count for each key — how many machines it's been activated on.
- Any key that returns an unexpected response from the API is flagged with an error note rather than left blank.
- All forty-two keys processed in one run, not one by one.
What If the Data Is Not Quite Ready
The keys in the sheet have whitespace or formatting artifacts
Before verifying, trim all values in column A of the License Audit tab to remove leading and trailing spaces and convert to uppercase. Then verify each cleaned key against Gumroad product ID 'abc123' and write validity status into column B and use count into column C.
I need to check keys against multiple products
For each row in the License Audit tab starting at row 2, check the license key in column A against the product ID in column D. Write the validity status into column B and the use count into column C. Use the product ID from column D for each row — they're not all the same product.
Some keys appear more than once in the list — I want duplicates flagged
Check each license key in column A of the License Audit tab against Gumroad product ID 'abc123'. Write validity status into column B and use count into column C. Also scan the full column A list for duplicate keys and write "duplicate" in column E for any key that appears more than once.
Full triage in one prompt
Trim and uppercase all keys in column A of the License Audit tab. Verify each against Gumroad product ID 'abc123'. Write validity in column B, use count in column C, and flag duplicates in column D. In column E, write a triage category: "valid-ok" if valid and use count is 1, "valid-overused" if valid and use count is over 3, "invalid" if invalid, "duplicate" for duplicates. Sort the whole table by column E so the urgent cases are at the top.
One prompt does the cleanup, verification, deduplication, and triage — so the support queue is categorized by the time you come back from lunch.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with a column of Gumroad license keys, then ask it to verify the full list and write back validity and use counts. Or see how to export your full sales history and return to the Gumroad integration overview.