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 workbook 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 Excel workbook. It reads the workbook, 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 workbook within seconds.
Open the Excel workbook where you want the reference data, and run:
Fetch every available pass type from PassSlot and populate the 'Pass Types' sheet with type ID in column A and type name in column B so I can reference them when creating passes
What You Get
- Column A: the machine-readable type identifier the dev team needs for API calls and configuration
- Column B: the human-readable name for each pass type
- Every pass type in your account, not just the ones visible in the default dashboard view
- A static reference worksheet the dev team can consult without needing a PassSlot login
What If the Data Is Not Quite Ready
The workbook already has a reference sheet with some types but you need it refreshed
Clear the 'Pass Types' sheet from row 2 downward, then fetch all PassSlot pass types and write type ID in column A and type name in column B starting from row 2
You need to know which types have associated passes before the briefing
Fetch all PassSlot pass types and list them in the 'Pass Types' sheet with type identifier in A and type name in B, then for each type fetch the pass count from PassSlot and put it in column C
The dev team also needs the description field for documentation
Get all PassSlot pass types and populate the 'Pass Types' sheet with type identifier in A, type name in B, and description in C
Full briefing-ready workbook in one shot: types, identifiers, descriptions, and a count — all in one go
Fetch all PassSlot pass types and populate the 'Pass Types' sheet with type identifier in A, type name 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 Excel workbook 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.