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' tab, their first names in column B. The owner wants the notification out by 10 AM. You have never sent a bulk Passcreator push notification before.
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 sheet 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 the one your sheet 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 Google Sheet. 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 for each row: "sent", "invalid pass ID", or the specific error.
- A count: 400 attempted, 398 sent, 2 flagged — so you know immediately if any members were missed and why.
- Nothing sent to pass holders not in the sheet.
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 {Firstname} placeholder would render inconsistently in the notification.
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' tab has pass IDs in column A and redemption dates in column B. You want to exclude members who redeemed within the last 30 days from today.
Join the 'Redemptions' tab on pass ID and exclude any members whose most recent redemption date in the 'Redemptions' tab 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 of the 'Members' tab.
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', and Gold gets '20% off today'. Include the first name from column B in each message.
One prompt to clean, filter, personalise, and send
The names need normalising, you need to exclude recent redeemers, and different tiers get different messages — all before 10 AM.
Normalise column B to title case and trim whitespace. Join the 'Redemptions' tab and exclude pass holders who redeemed within 30 days of today, flagging them in column D. For remaining members, use the tier in column C to set the discount amount (Bronze: 10%, Silver: 15%, Gold: 20%) and send a Passcreator push notification with a personalised message using the first name and tier-matched discount. Write send status into column E.
Clean, filter, personalise, and send in a single instruction — no intermediate steps, no waiting.
Try It
Get the 7-day free trial of SheetXAI and open your loyalty member sheet with pass IDs and names, then ask it to fire the Passcreator notification with whatever conditions apply. See also: updating pass fields in bulk and the PassCreator integration overview.