Export Discount Redemptions From Lemon Squeezy Into a Google Sheet

The Scenario

You ran a BFCM promo last November with the code BFCM40. You told investors the promo drove $18,000 in revenue. Someone is now asking you to back that number up with actual redemption data — order IDs, customer emails, order amounts, and when each purchase was made.

Lemon Squeezy has a redemptions view inside the discount detail page. It lists orders. You can see them. There is no export button.

The bad version:

Open the BFCM40 discount page in Lemon Squeezy, start scrolling through redemptions
Manually copy each order ID and customer email into your sheet
Realize you also need the order amount and the redemption date for each one
Go back into each order individually to get the amounts
Lose track somewhere around row 40 and have to start that section over

Every redemption is a manual entry. If you had 80 redemptions, you're looking at 80 rows of copy-paste before you can calculate anything.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Lemon Squeezy through its built-in integration and pulls every redemption for a discount code in one pass.

List all Lemon Squeezy discount redemptions for the discount ID in cell A1 and write the order ID, customer email, and redemption date into columns A through C

What You Get

Column A: order ID
Column B: customer email
Column C: redemption date
One row per redemption, headers in row 1, all redemptions for that discount in a single pull

What If the Data Is Not Quite Ready

You want order total and discount amount alongside the redemption

Export every redemption for Lemon Squeezy discount code BFCM40 into this sheet with order total, discount amount saved, and customer email — one row per redemption

You want to calculate gross and net revenue per redemption

Pull all redemptions for the Lemon Squeezy discount ID in cell A1 and write customer email, order total, discount amount, and net revenue (total minus discount) into columns A through D

You only want redemptions within a specific date range

List all Lemon Squeezy redemptions for the discount ID in cell A1 between November 25 and December 2, 2025 — write order ID, customer email, order total, and redemption date into columns A through D

Pull all redemptions for Lemon Squeezy discount ID in cell A1 and write order ID, customer email, order total, discount amount saved, and redemption date into columns A through E — add a totals row at the bottom summing order totals and discount amounts, and flag any order over $200 in column F

One prompt produces the exact data you need to defend the promo numbers.

Try It

Get the 7-day free trial of SheetXAI and open the spreadsheet where you're tracking campaign ROI, then ask it to pull all redemptions for your BFCM code with order amounts included. You can also pull your full discount code list or order history into the same workbook.