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. He's been pulling individual config details from the Passcreator UI one at a time for the past hour and a half. There are 12 to go.
The bad version:
- Click through each of the 12 app configurations in Passcreator, copy the configuration ID, name, and linked template into the workbook manually — roughly 5 minutes per configuration.
- Finish the document, send it to venue contacts, and then discover three configurations have been updated since you started — the document is already stale before anyone opens it.
- Two venues flag that the configuration IDs don't match what their scanner app shows — you were on the wrong config page for at least two of them.
The first show is next week. A stale or wrong configuration reference document reaches venues before it's caught — and fixing a misconfigured gate scanner the night of the show is not a task anyone wants.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It retrieves all app configurations from your Passcreator account and writes them into the workbook — no clicking through 12 individual config pages.
Fetch every app configuration from my Passcreator account and populate the 'Scanner Configs' worksheet with ID, name, and validation rules
What You Get
- All 12 app configurations written into the 'Scanner Configs' worksheet, one row per configuration.
- Columns: configuration ID (exact API format), configuration name, linked pass template name(s), validation rules.
- Every configuration in the account — not just the ones you remembered to look for.
- Live data as of the moment you run the prompt — not stale from an hour of manual copying.
What If the Data Is Not Quite Ready
You need to add a column showing indoor vs outdoor venue type
The configuration names follow a pattern: "Venue_Indoor_CityName" or "Venue_Outdoor_CityName".
List all Passcreator app configurations. Parse the name field to extract 'Indoor' or 'Outdoor' and write that into a 'Venue Type' column in the 'Scanner Configs' worksheet.
You want to cross-reference configuration IDs against the venue contact list
The 'Venues' worksheet has venue name in column A and a 'Config Name' column in column B.
List all Passcreator app configurations. For each row in the 'Venues' worksheet 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, you want to confirm the linked template is still active.
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' worksheet on configuration name, writing matched IDs into column C and 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' worksheet.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, 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.