The Scenario
You are a community manager. Over the past month you ran 12 live webinars, each recorded by a Recall.ai bot. The chat Q&A from each session is full of product questions, feature requests, and testimonials you want to repurpose for content.
You have the 12 bot IDs in column A of an Excel workbook. You need the full chat log — sender, message text, timestamp — for every session, in one table you can search and tag.
The bad version of the next morning:
- You open Recall.ai recording 1, find the chat log, select all, copy
- Switch to the workbook, paste into a cell — it comes in as one long block with no column separation
- You try to parse sender from message manually
- By recording 4 the formatting is inconsistent
- You give up and save screenshots of each chat instead.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the bot IDs and fetches the in-meeting chat messages from Recall.ai for each recording.
Open the SheetXAI sidebar and type:
For each bot ID in column A, fetch all chat messages from the Recall.ai recording and write sender, message text, and timestamp into columns B, C, and D. Add one row per message, repeating the bot ID in column A.
SheetXAI calls the Recall.ai chat messages endpoint for each bot ID and writes a normalized message-by-message table.
What You Get
A message-by-message chat archive:
- Column A — bot ID (repeated per message for filtering by session)
- Column B — sender name
- Column C — message text
- Column D — timestamp
Every session's chat is in the same table with the same structure, regardless of whether the underlying platform was Zoom, Google Meet, or Teams.
What If the Data Is Not Quite Ready
Chat logs from live sessions are noisy. SheetXAI handles cleanup and extraction in the same prompt.
When you only want questions, not general chat
For each bot ID in column A, fetch all chat messages from the Recall.ai recording. Write only messages that appear to be questions (ending with "?" or starting with "How," "What," "Why," "When," "Can," "Is," "Does," "Will") into columns B, C, and D with sender, text, and timestamp.
When you want messages grouped by sender for attribution
For each bot ID in column A, fetch all chat messages. Group messages by sender and write one section per sender into the workbook with their name, the bot ID, and all their messages listed below. Separate each sender's block with a blank row.
When some sessions had very low chat activity and should be skipped
For each bot ID in column A, fetch the Recall.ai chat messages. If the total message count for that session is fewer than 5, write "SKIPPED — low activity" in column B and move to the next bot ID. Otherwise write the full message table.
When you want the archive plus a content brief derived from the top questions
For each bot ID in column A, fetch all chat messages from the Recall.ai recording and write sender, text, and timestamp into columns B, C, and D. Then look across all messages in that session and write a three-bullet content brief in column E for the first row of each session's block, listing the top 3 questions that came up most frequently.
The pattern: pull the raw chat data and layer the editorial judgment on top of it in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with Recall.ai bot IDs, then ask it to pull the chat logs. The Recall.ai integration is included in every SheetXAI plan. For transcript-level analysis, see how to pull full transcripts for thematic analysis or the Recall.ai in Excel overview.