The Scenario
You manage a coffee shop loyalty program. It's Tuesday at 9 AM and the owner approved a flash sale — 20% off drinks, today only, ending at 5 PM. Your 400 active loyalty members have wallet passes with push notification delivery enabled. Their pass IDs are in column A of the 'Members' worksheet, their first names in column B. The owner wants the notification out by 10 AM.
The bad version:
- Log into the Passcreator UI and look for a bulk notification option — find it requires entering pass IDs manually or uploading a specific file format.
- Try to copy the pass IDs from the workbook into the Passcreator interface — discover it accepts one at a time in the manual flow.
- Spend 30 minutes looking for a CSV upload option for notifications, find it exists but requires a different format than what Excel exports, and then give up and send the notification to only the first 20 members you could enter manually.
The flash sale window is today only. A notification that reaches 5% of your members at 11:30 AM isn't the campaign the owner approved.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the member list and talks to Passcreator's push notification endpoint — firing a personalised message to all 400 members without you manually entering a single pass ID.
Send a Passcreator push notification to all pass IDs in column A with the message 'Hi {Firstname}, your 20% discount is live today only!' using first names from column B to populate the placeholder
What You Get
- A notification fired to each pass ID in column A, with the {Firstname} placeholder filled from column B.
- Delivery status written into column C: "sent", "invalid pass ID", or the specific error.
- A count: 400 attempted, 398 sent, 2 flagged.
- Nothing sent to pass holders not in the workbook.
What If the Data Is Not Quite Ready
Some first name fields have extra capitalisation or whitespace
Column B has entries like "MARIA", " john ", and "Sarah" — the placeholder would render inconsistently.
Before sending, normalise column B to title case and trim whitespace. Then send the Passcreator push notification to all pass IDs in column A with the corrected first name in the message placeholder.
You only want to notify members who haven't redeemed a pass in the last 30 days
The 'Redemptions' worksheet has pass IDs in column A and redemption dates in column B.
Join the 'Redemptions' worksheet on pass ID and exclude any members whose most recent redemption date is within 30 days of today. Send the push notification only to remaining pass holders and flag the excluded ones in column D.
The message needs to vary by membership tier
You have three tiers — Bronze, Silver, Gold — each with a different discount offer. Tier is in column C.
Send a personalised Passcreator push notification to each pass holder in column A. Use the tier in column C to set the message: Bronze gets '10% off today', Silver gets '15% off today', Gold gets '20% off today'. Include the first name from column B.
One prompt to clean, filter, personalise, and send
The names need normalising, recent redeemers need excluding, and different tiers get different messages — all before 10 AM.
Normalise column B to title case and trim whitespace. Join the 'Redemptions' worksheet and exclude pass holders who redeemed within 30 days, flagging them in column D. For remaining members, use the tier in column C to set the discount amount and send a personalised Passcreator push notification. Write send status into column E.
Try It
Get the 7-day free trial of SheetXAI and open your loyalty member workbook, then ask it to fire the Passcreator notification with whatever conditions apply. See also: updating pass fields in bulk and the PassCreator integration overview.