Fetch Full Email Bodies From Zoho Mail Into a Excel by Message ID

The Scenario

A compliance review flagged 50 email messages last week. The legal team handed you a workbook: 50 rows, column A is MessageId, column B is FolderId, and there is a note at the top that says "retrieve full bodies for manual review by EOD Wednesday." It is Tuesday morning. You are the compliance officer.

The bad version:

• Open Zoho Mail, navigate to the folder in column B for row 2, scroll through messages until you find the one with the ID from column A, click into it, select all text in the message body, copy it, go back to the workbook, click cell C2, paste the body, go back to Zoho Mail, navigate to the next folder.
• Repeat for 50 rows, with the additional challenge that some messages are in different folders so each retrieval involves a separate navigation step.
• Spend the morning doing message archaeology instead of the actual compliance analysis that comes after.

Fifty messages reviewed individually is a morning. Fifty messages retrieved one by one by navigating to different folders is a different kind of morning — the kind where you are still on row 30 when the legal team pings for a status update.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent embedded in your Excel workbook. It reads the message ID and folder ID from your workbook and retrieves the full email content through the Zoho Mail integration. Open the sidebar, describe the fetch.

Fetch the full email body from Zoho Mail for each MessageId in column A using the FolderId in column B, and paste the retrieved body into column C of this workbook

What You Get

• The full text of each email body retrieved from Zoho Mail and written into column C, one row per message.
• Column C left empty and flagged with an error note for any message ID that could not be retrieved or was not found in the specified folder.
• All 50 retrievals complete in one operation rather than 50 separate inbox navigations.
• The workbook now contains both the identifier (column A) and the content (column C) side by side, ready for the manual review the legal team requested.

What If the Data Is Not Quite Ready

You also need the subject line and sender, not just the body

For every row in this workbook, retrieve the complete Zoho Mail message using the MessageId and FolderId columns and write the subject into column C, the sender into column D, and the full body into column E

Some message IDs may no longer be accessible due to folder moves

Attempt to retrieve each message using MessageId and FolderId — if a message cannot be found in the specified folder, try retrieving it by MessageId only across all accessible folders, and write the body into column C if found — otherwise write "Not accessible" into column C

You need a truncated preview alongside the full body for faster initial triage

For each row, retrieve the full email body from Zoho Mail using MessageId and FolderId — write the complete body into column C and write the first 200 characters of the body into column D as a preview for triage

Retrieve bodies, extract sender and subject, add previews, and flag inaccessible messages

For each row in the workbook, retrieve the Zoho Mail message using MessageId and FolderId — write subject into column C, sender into column D, full body into column E, and a 200-character preview into column F — for any message that cannot be retrieved, write "Not accessible" across those four columns and continue to the next row

One prompt produces the full review-ready dataset so the legal team can start the actual analysis without waiting for another retrieval pass.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of flagged message IDs, then ask it to pull the full email bodies. See also: Search your inbox using workbook criteria. Or return to the Zoho Mail hub.