The Scenario
You are an email marketing manager. The monthly operations report is due Friday at 3 PM. The deliverability section needs delivery rate, open rate, bounce rate, and spam rate for the last 30 days broken down by day, in a table your VP can read on the slide.
It is Thursday at 11 AM. The data is in Mailtrap. The table is not in the workbook yet.
The slow version of your Thursday:
- You log into Mailtrap and navigate to Statistics
- You change the date range to the last 30 days
- You look for an export and find a CSV that does not match your workbook's column names
- You spend 40 minutes renaming columns and reformatting dates
- You paste the table in at 2:55 PM and have no time to QA it before the meeting.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the Mailtrap stats API and writes the data into the column structure you specify.
Open the SheetXAI sidebar and type:
Fetch Mailtrap sending statistics for the last 30 days grouped by date. Write each day's delivery rate, open rate, bounce rate, and spam rate into columns A through E of the Stats tab with a header row. Sort by date ascending.
SheetXAI pulls 30 days of data and writes the table. No CSV, no reformatting, no column renaming.
What You Get
A clean table in the workbook, ready to paste into the slide:
- Columns A–E — date, delivery rate, open rate, bounce rate, spam rate
- 30 rows — one per day, sorted by date
- Header row — column names you chose, not whatever Mailtrap exports by default
The table goes straight into the slide because the column names already match your template.
What If the Data Is Not Quite Ready
Delivery stats rarely arrive in exactly the shape the report needs. SheetXAI handles reshaping in the same prompt.
When the report groups by category instead of by date
Fetch Mailtrap sending stats for the last 30 days grouped by category. Write one row per category into the Stats tab with category name, delivered count, bounced count, open rate, and spam rate in columns A through E.
When you need a month-over-month comparison
Fetch Mailtrap sending stats for April 2026 and May 2026 grouped by date. Aggregate totals per month. Write April's totals into row 2 and May's totals into row 3 with labels in column A.
When you only want days where bounce rate exceeded 2%
Fetch Mailtrap sending stats for the last 30 days grouped by date. Filter to days where bounce rate exceeded 2%. Write those rows into columns A through E and the count of flagged days into cell G1.
When you need the table and a written summary for the report narrative
Fetch Mailtrap sending stats for the last 30 days grouped by date. Write the full table into columns A through E. Write a two-sentence summary into cell G1 identifying the worst three days by bounce rate and whether the average recovered by the end of the period.
The pattern: data and narrative in one prompt. The report section is complete in one shot.
Try It
Get the 7-day free trial of SheetXAI and open any workbook where you build email performance reports, then ask it to pull from Mailtrap. The Mailtrap integration is included in every SheetXAI plan. See also how to break down stats by email service provider or the Mailtrap in Excel overview.