The Scenario
Your nonprofit ran 8 fundraising galas across different cities this year, and the development director is preparing for the annual board presentation. The board wants to see VIP ticket holder counts and revenue contribution per city — and how that compares to General Admission. The data exists in Eventbrite, spread across 8 events, each with its own attendee list and sales report. Nobody has pulled it together into a single view yet.
The bad version:
- Export the attendee report for the first gala as a CSV, paste it into a worksheet, note the VIP count and revenue.
- Repeat for the other 7 galas. Eight worksheets, eight manual extractions, eight chances to pull the wrong column or misread the ticket type label.
- Try to build a summary pivot table across all 8 worksheets. The ticket type labels are inconsistent — one event used "VIP Patron" and another used "VIP Table" — so your pivot breaks.
- The board meeting is Monday morning. It's Saturday afternoon.
This is the kind of report that should have been built a month ago. The reason it wasn't is that building it was too much work to justify until someone with authority asked for it on short notice.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and — through its built-in Eventbrite integration — can pull the attendee and revenue data across all 8 galas, normalise the ticket type labels, and build the summary view in one pass.
Create a summary worksheet called 'By Ticket Type' showing total attendees and total revenue for VIP vs General Admission across all 8 events in the organisation for Eventbrite organization ID '777888999'.
SheetXAI queries the Eventbrite organisation API for attendee and sales data across every event, normalises the output into a flat table with consistent column structure, and builds the summary worksheet.
What You Get
- One row per event × ticket type combination in the raw data worksheet.
- A 'By Ticket Type' summary worksheet showing city-level VIP vs GA totals.
- Ticket type labels normalised where the API provides consistent identifiers, even if display names varied.
- Revenue figures in your organisation's currency, formatted as numbers.
What If the Data Is Not Quite Ready
The ticket type labels are inconsistent across events
Fetch the attendee and revenue data for all events in Eventbrite organization ID '777888999' for 2025, normalise any ticket type label containing 'VIP' to 'VIP' and any containing 'General' to 'General Admission', and write the result into this worksheet.
You need to add a revenue share percentage per ticket type per event
From the gala data in this worksheet, add a column showing each ticket type's revenue as a percentage of that event's total revenue, then sort the full table by city and ticket type.
You only want the cities where VIP revenue exceeded £10,000
From the cross-event gala data, create a worksheet showing only cities where VIP total revenue exceeded 10000, sorted by VIP revenue descending.
Pull the data, normalise, build the summary, calculate share percentages, and flag outliers — in one shot
Fetch attendee and revenue data for all 2025 events in Eventbrite organization ID '777888999', normalise ticket type labels, write the full dataset into the 'All Galas' worksheet, build a 'By Ticket Type' summary worksheet with city-level VIP vs GA totals, add revenue share percentages, and flag any city where VIP revenue accounts for less than 30% of total in a 'Low VIP Share' column.
One prompt builds the raw data, the normalisation, the summary, and the board-ready insight flags together.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook you're preparing for your development team or board, then ask it to pull the cross-event ticket-type breakdown from your Eventbrite organisation. You can also explore the full organisation sales report or deduplicating attendees across events from the same integration.