The Scenario
A communications manager at a regional health nonprofit is three days out from a campaign debrief meeting. Her predecessor left a sheet of 15 Humanitix event IDs from last fundraising season — column A, no other context — and the brief calls for a full summary of each event: descriptions, ticket types, organizer names, and public URLs so the creative team can screenshot the event pages.
She doesn't know what half these event IDs map to. The last person who did left two months ago.
The bad version:
- Open Humanitix, go to the search bar, and paste in the first event ID. Find the event. Copy the title into the sheet.
- Open the event detail page. Copy the description. Navigate back to the sheet. Paste. Switch tabs again for the ticket types — there are four types on this event, so four copy-paste operations just for that column.
- Multiply by 15 events. That's somewhere between 90 and 150 individual copy-paste actions before the sheet is usable for the debrief.
The debrief slides are due to design tomorrow at noon. Nobody hired you to be a data entry clerk, and this doesn't change anything about the campaign — it's just archaeology.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the event IDs in your sheet, calls the Humanitix API for each one, and writes the results back — without you touching the Humanitix dashboard once.
With your 15 event IDs already in column A, paste this into the SheetXAI sidebar:
For each event ID in column A, retrieve the full event details from Humanitix and write the event name, description, start date, venue, ticket types (comma-separated), and total capacity to columns B–G.
What You Get
- Column B: event name
- Column C: event description (full text)
- Column D: start date
- Column E: venue name
- Column F: ticket types, comma-separated (e.g., "General Admission, VIP, Early Bird")
- Column G: total ticket capacity
- One row per event ID from column A
- If an event ID returns a 404 or is inaccessible, that row gets "Not found" in column B and the remaining cells stay blank
What If the Data Is Not Quite Ready
Some event IDs in column A have leading/trailing spaces and aren't resolving
For each value in column A, trim any whitespace before using it as a Humanitix event ID. Then retrieve the event name, description, start date, venue, and ticket types and write them to columns B–F.
You also need the organizer name and the public event URL for each one
For each event ID in column A, fetch the event details from Humanitix and populate: event name in B, description in C, organizer name in D, public Humanitix event URL in E, and ticket types comma-separated in F.
The descriptions are long and you need a one-sentence summary per event for the slide deck
For each event ID in column A, retrieve the event name and full description from Humanitix. Write the event name to column B. Then summarize the description in one sentence and write that to column C.
Clean the IDs, fetch the details, summarize descriptions, and flag events with no ticket types — all at once
For each value in column A, trim whitespace, then look up the event in Humanitix. Write the event name to B, a one-sentence description summary to C, the start date to D, and the ticket types (comma-separated) to E. If an event has no ticket types, write "No tickets configured" in column E and highlight that row yellow.
One prompt, no intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with a column of Humanitix event IDs — even a messy one — then ask it to fill in the event details. For pulling your full event list without a list of IDs, see exporting your full Humanitix event portfolio, or return to the Humanitix hub for all available workflows.