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 sheet. The kind that lives in the workbook, gets linked from the team 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 sheet.
- Realize the response has parent and child taxonomy relationships and you need to decide how to flatten them into rows for readability.
- Send the sheet 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 Google Sheet. It reads your request, calls SeatGeek's taxonomies endpoint, and writes the full taxonomy list — IDs, names, and parent relationships — into a dedicated sheet. Complete, not partial.
Fetch all SeatGeek event taxonomies and write each taxonomy ID, name, and parent category into a sheet 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 sheet
- The Taxonomies sheet 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 sheet 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 sheet. 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 sheet, 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 sheet 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 a Google Sheet, then ask SheetXAI to pull the full SeatGeek taxonomy reference. Once your reference sheet is built, use the category-filtered events spoke to run properly filtered event queries, or return to the SeatGeek hub for all available workflows.