The Scenario
You run a live-streaming channel and your most active month yet just wrapped up. A member of your team set up a supporter wall — donors who gave Super Chats during streams get acknowledged by name in the next broadcast. The problem: someone needs to compile the list. Donor name, amount, message, stream date. Thirty days of data across 12 streams.
The bad version:
- Find the YouTube Live Dashboard for the first stream, look for a Super Chat section, realize the dashboard only shows aggregate totals not individual events
- Check YouTube Studio's Revenue tab — it shows totals by day, not individual transactions with names and messages
- Search YouTube's help documentation for how to export Super Chat data — find a thread from 2021 that says it's not possible from the UI
- Ask your developer to pull it from the API, they come back with a CSV that has internal field names and no readable message text
Your supporter acknowledgment segment is scripted for Friday. You need the names and messages by Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It connects to the YouTube API's Super Chat reporting endpoint and pulls your donation events into a structured sheet.
Fetch all Super Chat events from my YouTube channel for the past 30 days and write them into this sheet with supporter name, donation amount, currency, message text, and video ID
What You Get
- One row per Super Chat event
- Column A: supporter display name
- Column B: donation amount as a number
- Column C: currency code (e.g. USD, EUR)
- Column D: message text from the Super Chat
- Column E: video ID of the stream the Super Chat occurred in
- Column F: timestamp of the event
What If the Data Is Not Quite Ready
You want to also include the stream title alongside the video ID
Fetch all Super Chat events from my YouTube channel for the past 30 days — write supporter name, donation amount, currency, message text, video ID, and video title into this sheet, looking up titles from the video IDs
You want to deduplicate in case the same supporter donated multiple times in one stream
Fetch all Super Chat events from my channel for the past 30 days — write them into this sheet with supporter name, amount, currency, message, and video ID — then add a column marking any supporter who donated more than once in the same stream as "Multi-donor"
You want to rank supporters by total donation amount across all streams
Fetch all Super Chat events from my channel for the past 30 days — aggregate by supporter name, summing donation amounts in USD equivalent — write the results into this sheet sorted descending by total amount, with columns for supporter name, total amount, and number of events
You want the full export plus a formatted thank-you list ready to paste into a script
Fetch all Super Chat events from my channel for the past 30 days — write the full event log into Sheet1 with supporter name, amount, currency, message, and video ID — then create a Sheet2 with a deduplicated list of supporter names and total amounts, formatted as: "Thank you [Name] for [total] in support"
One prompt. Full event log in Sheet1, broadcast-ready acknowledgment list in Sheet2.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet connected to your channel — ask SheetXAI to pull the last 30 days of Super Chat events and your supporter list is ready before the next broadcast. See also exporting channel video inventory or the YouTube hub.