Give the assistant one row per listing, with event, date, venue, section, row and quantity, and ask it to fill the section's lowest all-in price, median all-in price and tickets listed beside each row. You keep the pricing call; the assistant does the lookups.
The template
Download the blank inventory template (CSV). It has these columns, and no rows:
| Column | Who fills it |
|---|---|
| event | You |
| date | You |
| venue | You |
| section | You, as the marketplace prints it |
| row | You |
| quantity | You |
| your_cost | You |
| list_price | You, after reading the market columns |
| section_lowest_all_in | The assistant |
| section_median_all_in | The assistant |
| section_tickets_listed | The assistant |
| note | The assistant, for rows it could not match |
The prompt
Prompt
I've attached my ticket inventory. For each row, look up current resale listings for that event and section and fill section_lowest_all_in, section_median_all_in and section_tickets_listed, all-in per ticket. If you cannot match a section, leave the three cells empty and say why in note. Do not change my columns. Return the file as CSV.
What the filled columns look like
For two sections at Pentatonix, a connected assistant should fill these values:
| section | section_lowest_all_in | section_median_all_in | section_tickets_listed |
|---|---|---|---|
| Section 214 | 65.00 | 110.00 | 172 |
| Section 216 | 66.00 | 110.00 | 261 |
Make the match work
- Write sections the way the marketplace prints them. "Lower Level 112" and "112" may match; "LL112" may not.
- Use the event date, not the on-sale date, so two shows of one tour stay apart.
- Keep one row per listing. The assistant compares your quantity with the tickets listed, and a merged row hides that.
For one row at a time, the price my section prompt gives the same three numbers. For where the supply sits across the event, use tickets listed in each section.
Questions
Can ChatGPT read an Excel file?
Yes. ChatGPT and Claude both read .xlsx and .csv uploads, work through the rows and hand back an updated file.
What columns should a ticket inventory spreadsheet have?
One row per listing: event, date, venue, section, row, quantity, your cost and your list price. Add three market columns for the assistant to fill: section lowest all-in, section median all-in and section tickets listed.
Fill the market columns of your sheet in one chat with Ticker MCP.
Prompts in this guide
- Price my tickets in one section
- Tickets listed in each section
- Sections with the fewest tickets listed