The Scenario
The quarterly moderation audit lands in your inbox from your trust-and-safety lead. She needs a flat table of every banned user across all 25 community channels — user ID, nickname, and which channel they're banned from — by Thursday. You have the channel URLs in column A of your Google Sheet. You do not have any kind of automated export for ban data. You have never had to produce this report before.
The bad version:
- Open the first channel in Sendbird's dashboard, navigate to its Banned Users section, copy the user IDs and nicknames, paste them into a spreadsheet with the channel URL — then move to the next channel and repeat
- After six channels, realize each channel has slightly different numbers of banned users and you've been accidentally overwriting rows in the spreadsheet
- By channel 14, you've been doing this for two hours and still have 11 channels left — and you're not sure the data you collected first is still accurate
A quarterly audit that takes half a workday to prepare is a quarterly audit that will start being skipped.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the channel URL list in column A and through its Sendbird integration it can iterate across every channel, pull the ban list from each, and write the results into a flat table — all in one operation.
For each channel URL in column A, list all banned members from Sendbird and write each banned user ID and the channel URL as a row in a new sheet called BannedUsers
What You Get
- A flat BannedUsers sheet with one row per ban — channel URL and banned user ID side by side
- Every channel in column A gets processed — not just the first few you got to before losing momentum
- The sheet is ready to sort by channel or by user ID the moment the prompt finishes
- If a channel returns no bans, it simply produces no rows — no errors, no gaps to interpret
What If the Data Is Not Quite Ready
You also need the nickname for each banned user
For each channel URL in column A, list all banned members from Sendbird and write channel URL, banned user ID, and nickname as rows in a sheet called BannedUsers
Some channels in column A are inactive and should be skipped
For each channel URL in column A where the channel is active in Sendbird, list all banned members and write channel URL, banned user ID, and nickname as rows in a new sheet called BannedUsers — skip any channel that returns a 404 or inactive status
You want a summary count per channel in addition to the flat list
After writing all banned users into the BannedUsers sheet (channel URL, user ID, nickname), add a summary section to the ChannelList sheet: for each channel URL in column A, write the count of banned users into column B
Full audit in one shot: pull bans, enrich with nicknames, flag channels with unusually high counts
For each channel URL in column A, list all banned members from Sendbird and write channel URL, banned user ID, and nickname as rows in the BannedUsers sheet — then in the ChannelList sheet, write the ban count for each channel into column B and flag any channel with more than 10 bans with "HIGH VOLUME" in column C
One prompt, a complete moderation audit with context baked in.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your Sendbird channel URLs, then ask it to pull your full ban list into a new tab. Also see: Export Sendbird Group Channels Into a Google Sheet for a Moderation Audit and the Sendbird integration overview.