The Scenario
Your head of support scheduled a restructure meeting for Thursday. The question on the agenda: which agents are covering which channels? There are fourteen channels connected to the Respond.io workspace — WhatsApp Business accounts, Instagram DMs, a live chat widget, email channels, a Facebook Messenger integration — and no one has a clean list of them anywhere outside of the Respond.io settings panel.
Someone needs to go into Respond.io, pull up the channel list, and get it into a Google Sheet before the meeting so it can be annotated with agent assignments.
The bad version:
- Open Respond.io, navigate to Settings > Channels, read each channel name and type, type it into the sheet, row by row.
- Go back to check the channel IDs — they weren't visible in the first view — navigate again, copy each one.
- Realize the sheet now has 14 rows but you're not confident they're in the right order anymore.
This is the kind of task that takes 20 minutes and produces a spreadsheet you're not quite sure you trust, which means someone will double-check it before the meeting anyway.
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 Respond.io integration it can fetch the full channel list and write it directly to your sheet — name, type, and ID in the columns you specify.
List all channels connected to the Respond.io workspace and write each channel's name, type, and ID into columns A, B, and C of the ChannelInventory sheet
What You Get
- Every channel in the Respond.io workspace written to the ChannelInventory sheet.
- Column A: channel name. Column B: channel type (WhatsApp, Instagram, email, etc.). Column C: channel ID.
- The data reflects the current live state of the workspace, not a screenshot or a manually transcribed list.
- Rows are overwritten from row 1 down — no stale data left over from a previous export.
What If the Data Is Not Quite Ready
You need to filter by channel type before the meeting
List all channels connected to the Respond.io workspace, filter for WhatsApp channels only, and write the channel name, type, and ID into columns A, B, and C of the WhatsApp sheet
You want to add a column for agent assignment right after the export
List all Respond.io workspace channels, write the channel name, type, and ID into columns A, B, and C of the ChannelInventory sheet, and add a header "Agent Assignment" in column D for the team to fill in
The sheet needs a timestamp column so you know when the data was pulled
Fetch all Respond.io channels and write each channel's name, type, and ID into columns A, B, and C of the ChannelInventory sheet, with today's date and time in column D for every row
Full kill chain — fetch, filter, annotate, and flag inactive channels in one shot
Fetch all channels from the Respond.io workspace, write name, type, and ID into columns A, B, and C of the ChannelInventory sheet, mark any channel with "inactive" or "disconnected" status in column D, and leave column E blank for agent assignment notes
The full picture, ready before the restructure meeting starts.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your Respond.io channel inventory into the rows. See also: Export Respond.io Workspace Users to a Google Sheet and the Respond.io overview.