The Scenario
Black Friday is five weeks away. Your marketing manager sent a message this morning: "Which discount codes are still active and which ones should we kill before the BFCM campaign goes live?"
You have 25 discount codes in Lemon Squeezy. Some were created for specific partner campaigns. Some expired. Some are evergreen. You need code name, discount amount, and total redemption count in a spreadsheet so you can make a decision about which codes to extend, which to retire, and which to use as the basis for the BFCM offer.
Lemon Squeezy shows you discounts in a list. Redemption counts are visible per code in the detail view. There is no export that gives you both in one file.
The bad version:
- Open the Discounts view, click the first code, note the code name, amount, and redemption count
- Open your sheet, paste the row, go back to Lemon Squeezy
- Repeat for all 25 codes
- Realize you also need the expiry dates, go back through all 25 again
Twenty-five codes. Two passes. Fifty manual lookups before you can make a single decision.
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 the full discount code list with redemption data in one pass.
List all Lemon Squeezy discounts and write the discount code, amount type, amount value, and expiry date into columns A through D of this sheet
What You Get
- Column A: discount code name
- Column B: amount type (percent or fixed)
- Column C: amount value (e.g., 20 for 20%, or 1000 for $10.00 fixed)
- Column D: expiry date (null if no expiry)
- One row per discount code, headers in row 1
What If the Data Is Not Quite Ready
You want redemption counts alongside the code details
List all Lemon Squeezy discounts and write each code into Column A, amount type and value into columns B and C, expiry date into column D, and total redemption count into column E
You only want active, non-expired codes
Fetch all active Lemon Squeezy discount codes that have not yet expired — write code name, discount amount, and expiry date into columns A through C
You want to flag codes with zero redemptions
Pull all Lemon Squeezy discounts and write code name, amount, expiry date, and redemption count into columns A through D — flag codes with zero redemptions in column E as Unused
Full BFCM audit in one shot
List all Lemon Squeezy discount codes with code name, amount type, amount value, expiry date, and total redemption count in columns A through E — flag expired codes in column F, flag codes with zero redemptions in column G, and sort by redemption count descending
One sheet. Every code, every count, every decision in front of you at once.
Try It
Get the 7-day free trial of SheetXAI and open your BFCM planning sheet, then ask it to pull the full discount code list with redemption data. You can also pull order history or customer data into the same workbook.