The Scenario
You launched an email sequence two months ago to promote your "Advanced Python Course" on Gumroad. You told your list it was a limited-time offer, you sent three emails over five days, and the sales numbers looked decent. Now someone in your community is asking whether the launch actually worked — and you realize you have no clean data to answer with.
You know the product sold. You don't know which days spiked, whether the third email moved anything, or how the last 90 days compare to the 90 days before you ran the campaign.
The bad version:
- Export your full Gumroad sales CSV, which includes every product you've ever sold, then filter by product name in a spreadsheet — except Gumroad's export uses the product ID in some columns and the display name in others, and your filter catches some rows but misses others.
- Try to chart purchases by day, discover your date column came in as a text string that Excel doesn't recognize as a date, and spend time reformatting.
- Realize the export only goes back 90 days by default and you need 180 to do the before/after comparison, so you do two separate exports and try to concatenate them without creating duplicates.
The data exists. Getting it into a shape where it tells you something has taken longer than analyzing it would.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls the Gumroad API with your product filter and date range applied upstream, so what lands in your sheet is already scoped — no filtering, no deduplication, no date parsing.
Here is the prompt for this task:
Fetch all Gumroad sales for my product named 'Advanced Python Course' from 2026-01-15 through 2026-04-15 and write sale date in column A, buyer email in column B, and sale amount in column C of the Analytics tab starting at row 2. Sort by column A ascending.
What You Get
- One row per sale of the specified product within the date range, sorted chronologically.
- Sale date in a proper date format in column A, buyer email in column B, amount as a number in column C.
- Only the target product — no filtering needed after the fact.
- All pages of results included — if there were 380 sales, 380 rows land.
What If the Data Is Not Quite Ready
I want to see daily sale totals, not one row per transaction
Fetch all Gumroad sales for 'Advanced Python Course' from 2026-01-15 through 2026-04-15. In the Daily Totals tab, write one row per day — date in column A, number of sales in column B, and total revenue in column C. Sort by date ascending and include days with zero sales.
I want to compare two date windows side by side
Fetch Gumroad sales for 'Advanced Python Course' from 2026-01-15 through 2026-04-15 and from 2025-10-15 through 2026-01-14. In the Comparison tab, write each 90-day window as a block — window label in column A, total sales count in column B, total gross revenue in column C, and average sale amount in column D.
I want to flag days that had unusually high volume
Pull all Gumroad sales for 'Advanced Python Course' from 2026-01-15 through 2026-04-15. Write sale date in column A, buyer email in column B, and amount in column C of the Analytics tab. In a separate Daily tab, aggregate by date — date in column A, sale count in column B. In column C, write "spike" for any day where count is more than 2x the average daily count across the full window.
Full launch analysis in one prompt
Pull all Gumroad sales for 'Advanced Python Course' from 2026-01-15 through 2026-04-15 into the Raw tab — date in column A, buyer email in column B, amount in column C. Then in the Daily tab, write date in column A, sale count in column B, revenue in column C, and a spike flag in column D (spike = more than 2x average daily count). In the Summary tab, write total sales in B1, total revenue in B2, peak day in B3, and revenue from the top 3 days as a percentage of total in B4.
One prompt pulls the raw data, builds the daily view, and writes the summary metrics — so the launch postmortem has actual numbers behind it.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, then ask it to pull 90 days of Gumroad sales for your top product and show you which days drove the most revenue. Or see how to audit your full product catalog and return to the Gumroad integration overview.