The Scenario
A touring concert series runs across 12 venues in six cities over three months. The IT administrator is responsible for verifying that every venue's Passcreator door scanner app configuration is correctly set up — right template, right validation rules, right configuration ID — before the first show next week. The configurations exist in the Passcreator account. What doesn't exist is a consolidated view of all 12 of them in one place. The venue contacts keep asking for a reference document. The administrator has been pulling individual config details from the Passcreator UI one at a time.
The bad version:
- Log into Passcreator, open each of the 12 app configurations one by one, and copy the configuration ID, name, and linked template into a sheet manually — roughly 5 minutes per configuration, more if the UI is slow.
- Finish the spreadsheet, send it to the venue contacts, and then discover three configurations have been updated since you started copying — the document is already stale.
- Two venues flag that the configuration IDs in the reference doc don't match what their scanner app is showing — you've been looking at the wrong config page for at least two of them.
The first show is next week. A reference document with stale or mismatched configuration IDs is worse than no document at all.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It retrieves all app configurations from your Passcreator account and writes them into the sheet with the fields you need — no clicking through 12 individual config pages.
List all Passcreator app configurations and import them into this sheet with configuration ID, name, and linked pass templates
What You Get
- All 12 app configurations written into the sheet, one row per configuration.
- Columns: configuration ID (exact API format), configuration name, linked pass template name(s).
- Every configuration in the account — not just the ones you remembered to look for.
- Ready to share as a reference document or use as the basis for a validation check against each venue's scanner app.
What If the Data Is Not Quite Ready
You need to add a column showing which configurations are for indoor vs outdoor venues
The configuration names follow a pattern: "Venue_Indoor_CityName" or "Venue_Outdoor_CityName". You want to split this into a Type column for easier sorting.
List all Passcreator app configurations. Parse the name field to extract whether it contains 'Indoor' or 'Outdoor' and write that into a 'Venue Type' column. Write all fields into the 'Scanner Configs' tab.
You want to cross-reference configuration IDs against the venue contact list
The 'Venues' tab has venue name in column A and a 'Config Name' column in column B (filled in from earlier notes). You want to match each venue to a configuration ID from Passcreator and flag any mismatches.
List all Passcreator app configurations. For each row in the 'Venues' tab where column B matches a configuration name, write the configuration ID into column C. Flag venues where no match is found in column D.
Some configurations might be linked to templates that are no longer active
Before sending the reference doc to venues, you want to confirm that the template linked to each configuration is still active in Passcreator.
List all Passcreator app configurations. For each configuration, check if the linked pass template is still active. Flag configurations with an inactive or missing template in a 'Template Status' column.
Full pull, parse, cross-reference, and flag in one shot
The reference doc needs to be clean, matched to the venue list, and flagged for inactive templates — all before the kickoff call tomorrow.
List all Passcreator app configurations. Parse 'Indoor' or 'Outdoor' from the name into a 'Venue Type' column. Cross-reference with the 'Venues' tab on configuration name and write matched configuration IDs into column C, flagging unmatched venues in column D. Check each configuration's linked template status and flag inactive ones in a 'Template Status' column. Write the final result into the 'Scanner Configs' tab.
One prompt pulls the live data, enriches it, and cross-references it — so the reference doc reflects what's actually in Passcreator right now.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull all your Passcreator app configurations into a consolidated reference table. See also: importing scan history from a venue configuration and the PassCreator integration overview.