The Scenario
Your analytics team is building a set of SeatGeek queries using SheetXAI and hitting a wall: every time someone tries to filter events by category, they're guessing at taxonomy names. "Is it 'concert' or 'concerts'? Is NBA under 'sports' or 'basketball'?" Three different people have run three different filter attempts this week and gotten inconsistent results because nobody has the canonical taxonomy list in front of them.
You need a reference workbook. The kind that lives in the team drive, gets linked from the wiki, and ends the guessing.
The bad version:
- Dig through SeatGeek's API documentation to find the taxonomies endpoint, read the docs to figure out how to authenticate and call it, run the call, parse the JSON response, and manually paste the IDs and names into a worksheet.
- Realize the response has parent and child taxonomy relationships and you need to decide how to flatten them into rows for readability.
- Send the workbook to the team only to have someone point out you missed the "theater" subcategories because they nested three levels deep.
A reference sheet with gaps is worse than no reference sheet — people will trust it and get wrong query results.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your request, calls SeatGeek's taxonomies endpoint, and writes the full taxonomy list — IDs, names, and parent relationships — into a dedicated worksheet. Complete, not partial.
Fetch all SeatGeek event taxonomies and write each taxonomy ID, name, and parent category into a worksheet called Taxonomies.
What You Get
- Column A: Taxonomy ID (e.g., "1")
- Column B: Taxonomy name (e.g., "Concert", "NBA", "Comedy")
- Column C: Parent category where applicable (e.g., "Sports", "Music")
- All taxonomies from SeatGeek's endpoint in a single flat reference worksheet
- The Taxonomies worksheet is created if it doesn't exist, or overwritten if it does
What If the Data Is Not Quite Ready
You want a simpler two-column version — just ID and name
Your team only needs the ID-to-name mapping, not the hierarchy.
Get the complete SeatGeek taxonomy list and write the taxonomy ID in column A and the taxonomy name in column B of a worksheet called Event Categories.
You want to add a column that shows example event titles for each taxonomy
Context helps the team understand what each category actually covers.
Fetch all SeatGeek taxonomies and write the taxonomy ID in column A and name in column B of the Taxonomies worksheet. Then for each taxonomy, search SeatGeek for one example event and write its title into column C as an example.
You want to filter the taxonomy list to only show parent-level categories
The team only needs top-level categories for their filter prompts — subcategories add noise.
Fetch all SeatGeek taxonomies. Write only the top-level parent categories (those with no parent) into the Event Categories worksheet, with taxonomy ID in column A and name in column B.
Pull full taxonomy list, flatten hierarchy, sort alphabetically, and add a usage-example column
Fetch all SeatGeek taxonomies. Flatten the parent-child relationships so each row has taxonomy ID, taxonomy name, and parent name (or "Top Level" if none). Sort alphabetically by taxonomy name. Write the result into the Taxonomies worksheet with headers: ID, Name, Parent, Usage Example.
One prompt handles the API call, the flattening, the sort, and the header row together.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, then ask SheetXAI to pull the full SeatGeek taxonomy reference. Once your reference workbook is built, use the category-filtered events spoke to run properly filtered event queries, or return to the SeatGeek hub for all available workflows.