The Scenario
You joined this company three weeks ago as customer experience director. The IT integration review is tomorrow morning and they've asked you to bring a complete list of all active Heyy channels — WhatsApp, SMS, Instagram, Messenger — with their status and type. Nobody left you documentation. The person who set up Heyy left six months ago. You have access to the Heyy account, a blank Google Sheet, and about an hour.
The bad version:
- Open Heyy, navigate to the Channels section, read each channel name and type, type them into the spreadsheet
- Note the status of each one — active, inactive, pending — by eye
- Wonder if you've missed any because the UI shows channels in a paginated list and you're not sure if you clicked through all the pages
- Get to the IT meeting and have someone ask about the creation dates — which you didn't capture because the UI doesn't show them prominently
Channel audits are supposed to give you a reliable snapshot. A manually-built one has as many gaps as the person who built it had patience.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Google Sheet and pulls data from Heyy's API directly. It can fetch the full channel list and write every field you need — including creation dates and statuses that are buried in the Heyy UI — into the sheet in one call.
List all Heyy channels and write their name, type, status, and creation date into my sheet — one channel per row; flag any inactive channel in column E as 'Inactive'
What You Get
- One row per channel with name, type, status, and creation date in columns A through D
- Column E shows 'Inactive' for any channel whose status is not active
- All pages of results are fetched before writing — no channels missed because of pagination
- Creation dates appear in ISO format, sortable for timeline analysis
What If the Data Is Not Quite Ready
You need the channel list organized by type
The IT team wants WhatsApp channels grouped separately from SMS, Instagram, and Messenger for their integration map.
List all Heyy channels and write their details into my sheet — sort rows by type (WhatsApp first, then SMS, Instagram, Messenger) — name in column A, type in column B, status in column C, creation date in column D; flag inactive channels in column E as 'Inactive'
You need a count summary at the bottom of the sheet
The IT director wants to see total counts per channel type alongside the detail rows.
List all Heyy channels, write their name, type, status, and creation date into rows 2 onward; then add a summary block below the last row with a count of channels per type and a count of inactive channels total
You need to compare against an existing channel register
Your predecessor left a 'Known Channels' tab with a partial list. You want to see which channels are new, which are missing, and which have changed status.
List all Heyy channels and write their name, type, status, and creation date into my 'Channel Inventory' tab; then compare against the names in column A of my 'Known Channels' tab — mark channels that are new (not in Known Channels) with 'NEW' in column F and channels in Known Channels that no longer exist in Heyy with 'REMOVED' in that tab's column E
Full audit export for the IT review in one shot
You need the complete channel list, a type breakdown, inactive flags, comparison against your prior register, and a second tab with only inactive channels — all before the 9 AM meeting.
List all Heyy channels, write full details to 'Channel Inventory' tab, flag inactive channels in column E, add a summary block with counts by type, compare against 'Known Channels' tab marking new and removed channels, then copy all inactive rows to a second tab called 'Inactive Channels'
You walk into the IT review with a spreadsheet that took one prompt to build.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your complete Heyy channel inventory and flag inactive entries. The same session can then pull contact counts, template lists, or attribute catalogs. See also: Export Heyy message templates for compliance review and the Heyy integration overview.