The Scenario
You're launching 60 cohort chat channels for a new online education program. Every cohort has a name, a channel type, and a list of student user IDs — all sitting in a Google Sheet the program coordinator built. The backend engineer who was supposed to write the provisioning script is out sick. The cohorts go live Monday.
The bad version:
- Open Sendbird's dashboard, navigate to Channels, click "Create channel," type the cohort name, manually add each student user ID from the spreadsheet one at a time — for 60 channels, each with 8 to 20 members
- Midway through, realize the dashboard caps how many members you can add through the UI in one step, and you now have to figure out an API call for the larger cohorts
- Finish after four hours, discover three channels have the wrong member list because you accidentally scrolled past the right row
Monday is two days away. You needed this done yesterday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet. It reads your cohort data — names, types, member lists — and through its Sendbird integration it creates every channel in one pass, writing the new channel URL back into the sheet so you have a complete record.
For each row in this sheet, create a Sendbird group channel using the name from column A and the comma-separated user IDs from column B as invited members — write the new channel URL into column C
What You Get
- All 60 channels created in one operation — no clicking through 60 dashboard forms
- Column C fills in with the channel URL for each row so you have a record of what was created and where
- Member lists are read directly from column B — no re-transcribing user IDs manually
- Any failures surface in column C with the error message so you can retry just those rows
What If the Data Is Not Quite Ready
Some cohorts need an operator assigned in addition to members
For each row in this sheet, create a private Sendbird group channel using the channel name from column A, the operator user ID from column B, and the comma-separated member IDs from column C — write the created channel URL into column D
The member list column has inconsistent formatting — some rows use spaces after commas, some don't
For each row in this sheet, strip any extra spaces from the user ID list in column B and then create a Sendbird group channel using the channel name from column A and the cleaned member IDs — write the channel URL into column C
You want to check for duplicate channel names before creating
Scan column A for any duplicate channel names — flag duplicates in column D as "DUPLICATE" — then for all non-duplicate rows where column D is blank, create a Sendbird group channel using the name from column A and member IDs from column B, writing the channel URL into column C
Full provisioning run: validate data, create channels, confirm membership
For each row in this sheet where column A has a channel name and column B has at least one user ID: create a Sendbird group channel with the name from column A and invite all user IDs from column B — write the new channel URL into column C and "verified" into column D once created — flag any rows missing a name or member list with "INCOMPLETE" in column D
One prompt, all 60 channels provisioned and logged.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your cohort roster, then ask it to create all your Sendbird channels and write back the URLs. Also see: Bulk Add Members to Sendbird Group Channels From a Google Sheet and the Sendbird integration overview.