The Scenario
A loyalty program analyst needs to present campaign redemption rates at Thursday's quarterly review. The 'SummerPromo' template issued 2,000 passes over the summer. The data — serial numbers, voided status, redeemed status, creation dates — lives in Passcreator. The sheet is empty. The presentation is in two days, and the analyst has no idea how to call the Passcreator API.
The bad version:
- Try to export passes from Passcreator's UI — find the export option, download a file with unclear column headers, and spend 40 minutes figuring out which column is the redeemed flag and which is the voided flag.
- Import the file into the sheet, discover the date format is incompatible with the formulas already set up, and spend another hour converting dates.
- Realise the export only returned 500 rows due to a pagination limit you didn't know existed, and you've been calculating redemption rates on a quarter of the data.
The quarterly review is Thursday. Presenting a redemption rate calculated on 25% of the campaign data is worse than presenting no data at all.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the Passcreator API, handles pagination automatically, and writes all pass records into the sheet with the columns you specify — no downloads, no format conversions.
List all Passcreator passes for template ID 'summer-promo-2025' and import them into this sheet with serial number, voided status, redeemed status, and created date
What You Get
- All 2,000 passes from the 'SummerPromo' template written into the sheet, one row per pass.
- Columns: serial number, voided (TRUE/FALSE), redeemed (TRUE/FALSE), created date in a consistent format.
- Pagination handled automatically — all pages pulled, not just the first 500.
- A summary row at the bottom: total passes, total redeemed, redemption rate as a percentage — ready to paste into Thursday's deck.
What If the Data Is Not Quite Ready
You need to calculate redemption rate only for passes created after a specific launch date
The 'SummerPromo' template was used before the campaign officially launched, so some test passes are in the dataset. The real launch date was 1 July.
Import all Passcreator passes for template 'summer-promo-2025', then filter to include only rows where created date is on or after 1 July 2025. Write the filtered set into the sheet and calculate the redemption rate for that subset in a summary row.
You need to flag passes that were voided but also redeemed
Some passes were marked voided after being scanned — a data quality issue. You want to surface those for the operations team before the review.
Import all passes for template 'summer-promo-2025'. Flag any rows where voided is TRUE and redeemed is also TRUE in a new column D called 'Data Issue'. Calculate the redemption rate excluding those flagged rows.
You need to join loyalty tier from a second sheet before calculating segment rates
The 'Members' tab has serial numbers in column A and loyalty tier in column B. You want redemption rates broken out by tier.
Import all passes for template 'summer-promo-2025' into the 'Passes' tab. Join loyalty tier from the 'Members' tab on serial number. Then calculate redemption rate by tier and write the breakdown into the 'Summary' tab.
Full import, filter, flag, join, and segment in one shot
The test passes need filtering, data quality flags need creating, and the quarterly review needs redemption by tier — all before Thursday.
Import all Passcreator passes for template 'summer-promo-2025'. Filter to created date on or after 1 July 2025. Flag rows where both voided and redeemed are TRUE in column D. Join loyalty tier from the 'Members' tab on serial number. Calculate redemption rate by tier (excluding flagged rows) and write the segment breakdown into the 'Summary' tab.
The whole analysis chain runs as a single request — so the output is ready when the command completes, not two hours later.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull all passes from a specific Passcreator template and calculate the redemption rate. See also: importing scan history for venue audits and the PassCreator integration overview.