The Scenario
A digital marketing coordinator at a retail chain is three days out from briefing the development team on a new loyalty card launch. The dev team has asked for a list of PassSlot pass type IDs before they can start configuration, and the coordinator knows those type IDs live somewhere in PassSlot — but she's never needed to pull them systematically before.
The briefing doc is half-finished. The dev team's Slack message is sitting unanswered.
The bad version:
- Log into PassSlot, click through each pass type one by one, copy the type name and identifier from the detail view, and paste them into a spreadsheet manually — twelve types, twelve round trips.
- Realize the identifier field isn't visible on the main list view and only shows on each individual type page, meaning every lookup is two clicks deep.
- Send the list to the dev team, get a reply 20 minutes later asking for the description field too, and start the process over.
The briefing is tomorrow. The dev team will block without those type IDs. And this is exactly the kind of reference task that shouldn't take an afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet, understands what you're working on, and talks to PassSlot directly — so you can ask for the full pass type list in plain language and have it populated in the sheet within seconds.
Open the Google Sheet where you want the reference data, and run:
Get all PassSlot pass types and list them in this sheet with type name in column A, type identifier in column B, and description in column C
What You Get
- Column A: the human-readable name for each pass type (e.g., "Loyalty Card," "Event Ticket")
- Column B: the machine-readable type identifier the dev team needs for API calls and configuration
- Column C: the description field for each type, where available
- Every pass type in your account, not just the ones visible in the default dashboard view
- A static reference sheet the dev team can consult without needing a PassSlot login
What If the Data Is Not Quite Ready
The sheet already has a 'Reference' tab with some types but you need it refreshed
Clear the 'Pass Types' tab from row 2 downward, then fetch all PassSlot pass types and write type name in column A, type identifier in column B, and description in column C starting from row 2
You need to know which types are associated with a specific template before the briefing
Fetch all PassSlot pass types and populate the 'Pass Types' tab with type name in A and type identifier in B, then in column C note 'Loyalty' for any type whose name contains the word 'loyalty' or 'card'
The dev team also wants to know the total pass count per type
Get all PassSlot pass types and list them in this sheet with type name in A and type identifier in B, then for each type fetch the pass count from PassSlot and put it in column C
Full briefing-ready sheet: types, identifiers, descriptions, and a count — all in one go
Fetch all PassSlot pass types and populate the 'Pass Types' tab with type name in A, type identifier in B, description in C, and pass count in D, then mark any type with zero passes as 'INACTIVE' in column E
One prompt builds the entire reference document the dev team needs. No follow-up Slack thread, no second extraction pass.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you're using for your next launch brief. Ask it to pull your PassSlot pass types and you'll have the full reference table ready to share before your next message back to the dev team. See also how to import pass data for auditing or return to the PassSlot overview.