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, paste it into a tab, note the VIP count and revenue.
- Repeat for the other 7 galas. Eight tabs, 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 tabs. 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 Google Sheet. It reads the sheet 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.
Fetch the attendee report for Eventbrite organization ID '777888999' for the past 12 months and write the data — event name, city, ticket type, attendee count, and revenue — into this sheet.
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 writes it into your sheet.
What You Get
- One row per event × ticket type combination, showing event name, city, ticket type, attendee count, and revenue.
- Ticket type labels normalised where the API provides consistent identifiers, even if the display names varied.
- Revenue figures in your organisation's currency, formatted as numbers.
- Any event missing ticket-type-level revenue data flagged in a notes column rather than silently excluded.
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 sheet.
You want the summary tab built automatically after the pull
After writing the full event data into the 'All Galas' tab, create a 'By Ticket Type' tab showing total attendees and total revenue for VIP vs General Admission per city, sorted by VIP revenue descending.
You need to add a revenue share percentage per ticket type per event
From the gala data in this sheet, 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.
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' tab, build a 'By Ticket Type' summary tab 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 Google Sheet 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.