The Scenario
You wrapped up a strong quarter on Gumroad — 380 sales across three products — and now it's time to present the revenue numbers to your co-founder. The meeting is tomorrow morning. You have the Gumroad dashboard open in one tab and a blank Excel workbook in another, and you're already doing the mental arithmetic on how long this is going to take.
The bad version:
- Download the CSV export from Gumroad, open it in Excel, discover the headers don't match your existing column layout, and spend 15 minutes renaming and reordering fields.
- Realize the export doesn't break out refunded sales separately, so you filter by hand, mark the refunds, and manually subtract them from the totals column you just built.
- Repeat the whole thing for the other two products, each with a slightly different column schema because Gumroad's export format changed between product types.
You're supposed to be preparing talking points, not wrestling with data formatting. The meeting doesn't care how the workbook got built — it just expects the numbers to be right.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the workbook, connects to Gumroad, and pulls the data you ask for directly into the right columns. No export. No cleanup. No format matching.
Here is the prompt for this task:
Pull all my Gumroad sales and list them in the Sales worksheet starting at row 2 — one row per sale with buyer email in column A, product name in column B, sale price in column C, refund status in column D, and purchase date in column E. Include all products.
What You Get
- One row per Gumroad sale, starting at row 2 of the Sales worksheet.
- Buyer email, product name, sale price (as a number), refund status (e.g., "refunded" or "none"), and purchase date in ISO format in columns A through E.
- Refunded sales included in the export with refund status flagged — so you can filter or calculate net revenue without a separate manual pass.
- Any API pagination is handled automatically — all 380 sales land, not just the first page.
What If the Data Is Not Quite Ready
The date range isn't filtering to this quarter
Pull all my Gumroad sales from 2026-01-01 through 2026-03-31 and write buyer email in column A, product name in column B, sale price in column C, refund status in column D, and purchase date in column E in the Sales worksheet starting at row 2.
The product names in Gumroad don't match the names in my existing revenue tracker
Pull all my Gumroad sales from the last 90 days into the Sales worksheet. In column F, look up the product name from column B against the product name list in the Products worksheet column A and write the internal product code from column B of that worksheet. Leave blank if there's no match.
I need revenue grouped by product, not one row per sale
Summarize my Gumroad sales from the last 90 days by product name and write the results into the Summary worksheet — product name in column A, total gross revenue in column B, total number of sales in column C, and total refund count in column D. Sort by column B descending.
Full cleanup and analysis in one shot
Pull all my Gumroad sales from the last 90 days into the Sales worksheet with buyer email in column A, product name in column B, sale price in column C, refund status in column D, and purchase date in column E. Then write a summary in the Summary worksheet: product name in column A, total gross in column B, net revenue (excluding refunds) in column C, and sale count in column D. Flag any product where refund rate exceeds 10% with "high refunds" in column E.
One prompt handles the raw pull, the net calculation, and the flag — so you walk into the meeting with the full picture.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, then ask it to pull your Gumroad sales history into the Sales worksheet with whatever columns your revenue review needs. Then link across to learn how to audit your full product catalog or go back to the Gumroad integration overview.