The Scenario
You inherited a music data project from a colleague who left last month. She left behind an Excel workbook — now converted to a Google Sheet — with 40 SeatGeek performer IDs in column A and a comment in the header row: "need full profiles here." No further instructions.
You've got a competitive landscape report due Friday. The IDs are useless without the actual performer data behind them.
The bad version:
- Open SeatGeek's developer docs, figure out the performers endpoint URL, and construct API calls for each ID manually.
- Run each call in a REST client, copy the JSON response, extract the fields you need, and paste them into the sheet.
- Realize the JSON has nested taxonomy arrays and you have to decide which taxonomy to use when a performer has more than one.
Nobody in your role should have to construct API calls by hand to finish a market analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your performer IDs, hits the SeatGeek performer details endpoint for each one, and writes the profile fields you specify into adjacent columns — no API client, no JSON parsing.
For each SeatGeek performer ID in column A, fetch the full performer details and write the performer name, taxonomy, popularity score, and upcoming event count into columns B, C, D, and E.
What You Get
- Column B: Performer display name (e.g., "Billie Eilish")
- Column C: Primary taxonomy/genre (e.g., "Concert", "Pop Music", "NBA")
- Column D: Popularity score on SeatGeek's 0–100 scale
- Column E: Number of upcoming events currently listed
- Rows where a performer ID returns no result are flagged with "Not Found" rather than left blank
What If the Data Is Not Quite Ready
You need more fields including the image URL and ticket link
The report requires visual assets and direct links for each performer.
For each SeatGeek performer ID in column A, fetch the performer details and write the name, image URL, popularity score, and SeatGeek ticket URL into columns B through E.
Some IDs in the sheet are duplicates and should be deduplicated first
The inherited list has 40 rows but you suspect some IDs repeat.
Check column A for duplicate SeatGeek performer IDs. Remove duplicates, keeping the first occurrence. Then for each unique ID, fetch the performer name, taxonomy, and popularity score from SeatGeek and write them into columns B, C, and D.
You want to join the SeatGeek data against a second tab
You have a "Partners" tab with IDs in column A and company context in column B. You want the SeatGeek profile data written into that same tab.
Look at the Partners tab. For each SeatGeek performer ID in column A, fetch the performer name and popularity score from SeatGeek and write them into columns C and D of the same tab, keeping existing data in column B intact.
Pull full profiles, filter by popularity threshold, and sort for the report
For each performer ID in column A, fetch the SeatGeek performer name, taxonomy, popularity score, and upcoming event count. Only include rows where the popularity score is 60 or above. Sort the qualifying rows by popularity score descending and write name, taxonomy, score, and event count into a new sheet called Top Performers.
One prompt handles the enrichment, the filter, the sort, and the tab creation together.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with a column of SeatGeek performer IDs, then ask SheetXAI to pull the full profiles. See also the performer popularity enrichment spoke if you're starting from names rather than IDs, or the SeatGeek hub for all available workflows.