Export Discount Redemptions From Lemon Squeezy Into an Excel workbook

The Scenario

An investor asked for the ROI breakdown on your BFCM40 promo last November. You told them you drove $18,000 in revenue during the campaign window. They want the actual order-level data to back it up — order IDs, customer emails, order amounts, and redemption dates — before the next check-in call.

The call is on Friday. It's Wednesday.

Lemon Squeezy shows redemptions inside the discount detail page. You can see them listed. You cannot export them.

The bad version:

• Open the BFCM40 discount in Lemon Squeezy, scroll through the redemptions list
• Manually copy each order ID and customer email into Excel
• Click into each order individually to get the order total and the discount amount saved
• Realize the discount detail page only shows order IDs, not amounts, so every total requires a separate order lookup
• Lose track around row 45, go back to the beginning to verify you haven't missed any

Eighty redemptions. Eighty manual lookups. The call is Friday.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Lemon Squeezy through its built-in integration and pulls every redemption for a discount code — with order totals — in one pass.

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

What You Get

• Column A: order total in dollars
• Column B: discount amount saved in dollars
• Column C: customer email
• One row per redemption, all redemptions for that code in a single pull

What If the Data Is Not Quite Ready

You need redemption dates for the timeline

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

You want gross and net revenue per redemption

Pull all redemptions for Lemon Squeezy discount code BFCM40 and write customer email, order total, discount amount, and net revenue (total minus discount) into columns A through D

You want to filter to the BFCM campaign window only

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

Full promo ROI breakdown in one shot

Pull all redemptions for Lemon Squeezy discount ID in cell A1 — write order ID, customer email, order total, discount amount, and redemption date into columns A through E — add a totals row summing order totals and discounts, flag any order over $300 in column F as High Value

The investor packet ready before Thursday morning.

Try It

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