The Scenario
You've been asked to prioritize a list of 25 artists for a sponsorship outreach push before end of quarter. The list is already in column A of an Excel workbook — a mix of touring bands, solo acts, and comedians. What the team needs is a sense of who's actually active on the live circuit right now: popularity score and upcoming event count from SeatGeek so you can rank by relevance before anyone picks up the phone.
The bad version:
- Open SeatGeek in another tab, search each artist name individually, find the right performer match from the results (some names are common enough to have multiple matches), note the popularity score, count the upcoming events, and paste both into the workbook.
- Repeat 24 more times, losing track of which tab held the result for "James Brown" when two different profiles came up.
- Finish with a workbook where five rows are blank because SeatGeek returned no exact match and you weren't sure which partial match to use.
This is supposed to be a prioritization exercise, not a data entry job. The analysis is the work — not the lookups.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the names in your column, runs each against SeatGeek's performer search, picks the top match, and writes the results back row by row. You get a populated workbook without opening a single SeatGeek tab.
For each artist name in column A, search SeatGeek performers and write the top match's popularity score and upcoming event count into columns B and C.
What You Get
- Column B: SeatGeek popularity score for the top-matching performer (scale of 0–100)
- Column C: Number of upcoming events listed on SeatGeek for that performer
- Rows where no match was found get a clear "No match" note rather than silently blank cells
- The full 25-row lookup completes in one pass — no manual tab-switching
What If the Data Is Not Quite Ready
You want more fields than just score and event count
The team also wants genre classification and performer ID for future API use.
For each artist name in column A, search SeatGeek performers and write the top match's performer ID, popularity score, genre/taxonomy, and number of upcoming events into columns B, C, D, and E.
Some names in column A are band names, some are sports teams — they need different handling
Your outreach list is mixed: musicians and athletes for a sponsorship campaign.
For each name in column A, search SeatGeek performers. If the top match is a sports team, write "Sports" in column B. If it is a musician or comedian, write "Live Music/Entertainment." Then write the popularity score in column C and upcoming event count in column D for all rows.
Column A has extra whitespace and inconsistent capitalization
The list came from a form and is a mess.
Clean up each name in column A (trim whitespace, fix capitalization) before searching SeatGeek. Write the cleaned name into column B, the SeatGeek popularity score into column C, and upcoming event count into column D.
Pull score, event count, filter to active-only, and rank — all at once
For each artist in column A, look up SeatGeek popularity score and upcoming event count. Only keep rows where upcoming events is greater than 2. Sort the remaining rows in descending order by popularity score and write artist name, score, and event count into columns A, B, and C of a new worksheet called Prioritized.
One prompt — lookup, filter, sort, and output to a new worksheet — rather than three separate steps.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with a column of performer names, then ask SheetXAI to enrich it with SeatGeek data. See the performer profile enrichment spoke if you already have SeatGeek performer IDs, or the SeatGeek hub for a full overview.