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 Google Sheet 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 Google Sheets, 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 sheet got built — it just expects the numbers to be right.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet, 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 tab 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 tab.
- 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 tab 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 tab. In column F, look up the product name from column B against the product name list in the Products tab column A and write the internal product code from column B of that tab. 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 tab — 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 tab 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 tab: 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 a Google Sheet, then ask it to pull your Gumroad sales history into the Sales tab 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.