The Scenario
Black Friday is six weeks away and your growth marketer needs a clean view of every coupon and promotion code currently in Stripe — which ones are still active, how many times each has been redeemed, and which expired ones are cluttering the list and creating risk if someone shares an old code.
She opens Stripe's Coupons section. The UI shows coupons in a list but doesn't show redemption counts prominently, and promotion codes are in a separate sub-section. There is no combined export. The only way to get a complete picture is to navigate both sections, record what you see, and reconcile the two manually.
The bad version:
- Copy coupon rows from the Stripe UI into a Excel workbook, including expired ones mixed in with active ones.
- Navigate to Promotion Codes separately, copy those rows into a second tab, and realise the coupon-to-promotion-code relationship isn't visible in either export.
- Hand the growth marketer two disconnected tabs and let her figure out which promotion codes are attached to which coupons.
The marketing team needs this before they start planning the Black Friday offer stack. An unaudited coupon list going into a major campaign is the kind of thing that creates support tickets at 11 PM on a Friday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Stripe and can pull both coupons and promotion codes into structured tabs without requiring separate navigation.
List all Stripe coupons and write coupon ID, name, discount type, discount value, times redeemed, and active status into Sheet1
What You Get
- Sheet1 fills with one row per coupon: coupon ID, name, discount type (percentage or fixed amount), discount value, redemption count, and active flag.
- Expired coupons appear with their active status set to false — they're visible for audit purposes but clearly marked.
- Discount values are in the currency's major unit for fixed-amount coupons.
What If the Data Is Not Quite Ready
You want promotion codes in a second tab, linked back to their parent coupon
List all Stripe coupons in Sheet1 with coupon ID, name, discount type, discount value, and times redeemed — list all promotion codes in Sheet2 with the associated coupon ID, promotion code string, active flag, and max redemptions so I can see which codes are still valid
You only want to see active coupons to reduce noise
List all Stripe coupons with active status 'true' and write coupon ID, name, discount type, discount value, and times redeemed into Sheet1 — so the growth team only reviews codes that can still be redeemed
You want to flag coupons that have never been redeemed
List all Stripe coupons into Sheet1 with coupon ID, name, discount type, discount value, times redeemed, and active status — add column G that says 'unused' if times redeemed is zero, otherwise leave it blank
The full kill chain — pull coupons and codes, flag unused and expired, and produce a clean audit list in one shot
List all Stripe coupons in Sheet1 with coupon ID, name, discount type, discount value, times redeemed, and active status — flag unused coupons in column G — list all promotion codes in Sheet2 with coupon ID, code string, active flag, and max redemptions — flag any expired or inactive codes in Sheet2 column E — so the team can decide what to archive before Black Friday
The pattern: the audit, flags, and two-tab structure all come back in one pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook your marketing team uses for campaign planning — then ask it to pull your Stripe coupon and promotion code inventory into a clean audit view. For related reads, see how to export your Stripe pricing catalogue or pull paid invoice history for revenue reporting.