The Scenario
You are a QA engineer. Your team is cutting over a transactional email system to production in 72 hours. As part of the pre-launch checklist, you need to verify that the test sends from three Mailtrap sandbox inboxes hit the right recipients, used the right subject lines, and produced clean HTML output.
The evidence needs to be in a shared Google Sheet so the engineering lead and the product manager can sign off on it without logging into Mailtrap.
The bad version of the next two hours:
- You log into Mailtrap, open inbox one, read through the messages one by one
- You copy subject lines and recipients into the sheet by hand
- You do the same for inbox two and inbox three
- You realize you missed two messages in inbox one and have to go back
- You argue with the PM about whether a blank column means "not checked" or "checked and OK"
- The sign-off is delayed and the launch slips 24 hours.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads your Mailtrap sandbox inboxes and populates the audit sheet for you.
Open the SheetXAI sidebar and type:
List all messages from Mailtrap inbox IDs [inbox_id_1], [inbox_id_2], and [inbox_id_3]. For each message write the inbox name, subject, recipient, sender, and received timestamp into separate rows in columns A through E. Sort by inbox name then by received timestamp ascending.
SheetXAI fetches messages from all three inboxes and writes one row per message. The audit sheet is populated in seconds.
What You Get
A structured audit log in the sheet:
- Column A — inbox name
- Column B — subject line
- Column C — recipient address
- Column D — sender address
- Column E — received timestamp
Every inbox, every message, in one table. The engineering lead and the PM can filter by inbox name, spot missing messages, and sign off without opening Mailtrap.
Need to add HTML rendering notes? Ask SheetXAI to fetch the full HTML body for each message and write it into column F. You can review rendering artifacts from the sheet.
What If the Data Is Not Quite Ready
Sandbox audits always surface edge cases. SheetXAI handles them in the same prompt.
When you need to flag messages that are missing an expected subject line pattern
Your system should produce subjects in the format "Welcome, [FirstName]" — anything else is a bug.
List all messages from Mailtrap inbox ID [inbox_id]. For each message, check if the subject matches the pattern "Welcome, " followed by a name. If it does not match, write "SUBJECT MISMATCH" into column F for that row. Write the count of mismatches into cell H1.
When you only want to audit messages from a specific sender domain
Your test environment uses a staging domain and you only want to verify those sends, not noise from other integrations.
List all messages from Mailtrap inbox ID [inbox_id] where the sender address ends in "@staging.yourcompany.com." Write subject, recipient, and timestamp into columns A through C for the matching messages only.
When you need to check that every expected recipient received a message
You have a list of 12 test recipient addresses in column A and you need to confirm each one has at least one message in the inbox.
List all messages from Mailtrap inbox ID [inbox_id]. Cross-reference the recipient list in this sheet column A against the messages. For each address in column A, write "RECEIVED" in column B if at least one message was delivered to that address, or "MISSING" if no message was found.
When you need a full audit trail combining messages from all inboxes plus a sign-off summary
The PM wants one sheet she can hand to the launch checklist with all three inboxes, a message count per inbox, and a pass/fail status per inbox based on expected message count.
Fetch all messages from Mailtrap inbox IDs [inbox_id_1], [inbox_id_2], and [inbox_id_3]. Write all messages into the Audit tab with inbox name, subject, recipient, sender, and timestamp. Then write a summary table in the Summary tab with one row per inbox showing: inbox name, message count, expected count from column A of Summary, and a PASS/FAIL status based on whether actual equals expected.
The pattern: instead of pulling data from three inboxes separately and assembling the audit by hand, you describe the whole audit in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any sheet you use for QA tracking, then ask it to pull your sandbox inbox messages. The Mailtrap integration is included in every SheetXAI plan. See also how to push a template library into Mailtrap or the Mailtrap in Google Sheets overview.