The Scenario
You are a platform engineer who has just inherited a Mailtrap account from a team that left the company. The account has multiple projects, each with its own set of inboxes, and nobody documented which team owns which inbox.
The DevOps lead wants a mapping workbook by end of day so the new team can decide what to keep, archive, and reassign.
The slow version of your afternoon:
- You log into Mailtrap and click through the projects one by one
- You write inbox names and emails in a notepad
- You realize the notepad format does not match the Excel template your DevOps lead sent
- You reformat everything into the template with different column names
- You click back into Mailtrap to verify an inbox email you wrote wrong
- You send the workbook at 5:45 PM and three inboxes are missing.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls the full Mailtrap project and inbox inventory and writes it into the tab structure your DevOps lead specified.
Open the SheetXAI sidebar and type:
List all Mailtrap projects and their associated inboxes. Write project name, inbox name, inbox email address, and inbox creation date into columns A through D of the Inventory tab, one inbox per row.
SheetXAI lists every project, every inbox under each project, and writes one row per inbox. The inventory is complete before the hour is up.
What You Get
A full inventory table in the workbook:
- Columns A–D — project name, inbox name, inbox email, creation date
- Every inbox accounted for — no manual counting, no missing rows
- Ready for the DevOps lead — she can filter by project and add team owner in column E
What If the Data Is Not Quite Ready
Inherited account audits reveal more structure than expected. SheetXAI handles follow-on questions in the same session.
When the handover doc needs SMTP usernames
List all Mailtrap projects and their associated inboxes. Write project name, inbox name, inbox email, inbox username, and creation date into columns A through E of the Inventory tab.
When you want to flag potentially orphaned inboxes
List all Mailtrap projects and inboxes. Write project name, inbox name, and inbox email into columns A through C. For any inbox in a project named "Legacy," "Old," or "Test," write "REVIEW — POSSIBLE ORPHAN" into column D.
When the output needs to be grouped by project for readability
List all Mailtrap projects and inboxes. For each project, write the project name as a header row in column A. Then write one row per inbox under each project with inbox name, inbox email, and creation date in columns B through D. Leave column A blank for inbox rows so the project header stands out.
When you need the full inventory plus a summary count for the handover report
List all Mailtrap projects and their associated inboxes. Write the full inventory into columns A through D with one inbox per row. Write a summary in cell F1 showing total project count and total inbox count. Also list any project with zero inboxes as "EMPTY PROJECT" in column E.
The pattern: instead of clicking through the Mailtrap UI and writing things down, you describe the output shape and SheetXAI builds the inventory in one pass.
Try It
Get the 7-day free trial of SheetXAI and open any workbook you use for infrastructure audits, then ask it to pull the Mailtrap project and inbox inventory. The Mailtrap integration is included in every SheetXAI plan. See also how to pull sandbox inbox messages into a QA workbook or the Mailtrap in Excel overview.