The Scenario
Six months ago, 300 voucher codes went out to inactive customers as a re-engagement push. The CRM manager inherited the follow-up project from someone who left the team. The workbook is there — column A of the 'VoucherCheck' sheet, 300 codes — but nobody knows which ones have already been used.
Sending spent codes to customers is not a neutral error. It creates support tickets, erodes trust in the loyalty program, and makes the reactivation campaign look incompetent. The codes need to be validated before anything goes out.
The bad version:
- Open Piggy, go to the voucher lookup screen, paste code one, check the status, note it in column B.
- Do that 300 times. At 45 seconds per code, that's nearly four hours of lookup work.
- Realize halfway through that the status field in Piggy doesn't map cleanly to your workbook's terminology and you're now building a lookup table to decode REDEEMED versus USED versus EXPIRED.
The email send is next Tuesday. Four hours of lookup work is not in anyone's capacity. And the codes were already distributed once — the pressure to not repeat the mistake is real.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the voucher codes from the worksheet, checks each one against Piggy, and writes the redemption status back — including visual flagging — in one pass.
Read the Excel column 'VoucherCode', check each code's status in Piggy, write REDEEMED or AVAILABLE into column B, and highlight redeemed rows in red
What You Get
- Column B fills with REDEEMED, AVAILABLE, EXPIRED, or INVALID for every code in the list.
- Rows marked REDEEMED are highlighted in red so they're immediately visible when you open the workbook.
- Codes that Piggy doesn't recognize (malformed or never created) get INVALID in column B, surfacing any data issues in the original list.
- The check runs across all 300 rows in one pass, giving you a filterable, color-coded status column ready for the email team to act on.
What If the Data Is Not Quite Ready
The codes have inconsistent formatting — some prefixed, some lowercase
Normalize all voucher codes in column A to uppercase and trim whitespace, then for each code look it up in Piggy and write the status into column B and the redeem date (if any) into column C. Highlight redeemed rows in red
You need to split the validated list into two separate worksheets automatically
Check each voucher code in column A against Piggy. Copy all AVAILABLE codes and their details into a new worksheet called 'Ready to Send'. Copy all REDEEMED and EXPIRED codes into a worksheet called 'Do Not Send'. Write INVALID codes into column D on the current sheet
Some codes were generated across multiple promotions — you need the promotion name too
For each code in column A, look it up in Piggy and write the status into column B, the promotion name into column C, and the redeem date into column D. Highlight REDEEMED rows in red and EXPIRED rows in orange
Validate, filter, flag unusual cases, and summarize readiness in one pass
For each voucher code in column A, look it up in Piggy. Write the status into column B and the redeem date into column C. Highlight rows in red where the status is REDEEMED and in yellow where the status is EXPIRED. Leave AVAILABLE rows unhighlighted. Write a summary in cell E1: total codes, how many are AVAILABLE, how many are spent, and how many are INVALID
Combining the validation with the visual flagging and summary means you hand the email team a workbook they can act on immediately rather than a status column they still have to interpret.
Try It
Open an Excel workbook with your voucher code list and Get the 7-day free trial of SheetXAI. Ask it to validate every code against Piggy and flag the redeemed ones before your next send. For related workflows, see how to generate a voucher batch from a workbook or the full Piggy integration overview.