The Scenario
You are an email marketing manager. The monthly operations report is due Friday at 3 PM. The report has a deliverability section and your VP wants delivery rate, open rate, bounce rate, and spam rate for the last 30 days, broken down by day, in a table she can read on the slide.
It is Thursday at 11 AM. The data is in Mailtrap. The table is not in the sheet yet.
The slow version of your Thursday:
- You log into Mailtrap, navigate to the Statistics section
- You change the date range filter to the last 30 days
- You look at the chart, realize it is not what you need, switch to the table view
- You try to export it, the export button produces a file with different column names than your sheet template expects
- You spend 40 minutes renaming columns and reformatting dates in a separate CSV
- You paste the table in at 2:55 PM and have no time to QA it.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the Mailtrap API and writes the stats directly into the sheet structure you already have.
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 with a header row. Sort by date ascending.
SheetXAI calls the Mailtrap stats endpoint, pulls 30 days of data, and writes the table with the column names you need. No CSV, no reformatting, no renaming.
What You Get
A clean table in the sheet, ready to paste into the slide:
- Column A — date (formatted consistently)
- Column B — delivery rate
- Column C — open rate
- Column D — bounce rate
- Column E — spam rate
- 30 rows — one per day
The column names match your template because you told SheetXAI what to call them. No manual header cleanup, no pivot required.
Want a different view? Ask SheetXAI to add a summary row at the bottom with averages, or to highlight the three dates with the highest bounce rate.
What If the Data Is Not Quite Ready
Delivery stats pulled from APIs rarely arrive in exactly the shape your report needs. SheetXAI handles the reshaping in the same prompt.
When your report groups by category instead of by date
Your VP wants to see performance broken down by email category, not by calendar day.
Fetch Mailtrap sending stats for the last 30 days grouped by category. Write one row per category into this sheet showing category name, delivered count, bounced count, open rate, and spam rate in columns A through E.
When you need a month-over-month comparison
The report template has two columns for this month and last month side by side.
Fetch Mailtrap sending stats for April 2026 and May 2026 grouped by date. Aggregate each month's total delivery rate, open rate, bounce rate, and spam rate. Write April's totals into row 2 and May's totals into row 3 with "April 2026" and "May 2026" labels in column A.
When you only want days where bounce rate exceeded a threshold
Your VP only wants to see the days that should concern her, not the full 30-day table.
Fetch Mailtrap sending stats for the last 30 days grouped by date. Filter to only the days where bounce rate exceeded 2%. Write those rows into columns A through E and write the count of flagged days into cell G1.
When you need the full table plus a written summary for the report narrative
The slide needs a table and the report document needs a paragraph explaining what happened.
Fetch Mailtrap sending stats for the last 30 days grouped by date. Write the full table into columns A through E. Then write a two-sentence summary into cell G1 identifying the worst three days by bounce rate, what the spike looked like numerically, and whether the average recovered by the end of the period.
The pattern: you describe both the table and the narrative in one prompt, and SheetXAI produces both. The report section is done in one shot.
Try It
Get the 7-day free trial of SheetXAI and open any sheet where you build email performance reports, then ask it to pull from Mailtrap. The Mailtrap integration is included in every SheetXAI plan. For related workflows, see how to break down delivery stats by email service provider or the Mailtrap in Google Sheets overview.