The Scenario
You are a deliverability engineer. Over the last two weeks your overall bounce rate has crept up but the aggregate number does not tell you where the problem is. Your hypothesis is Gmail is responsible for most of it.
The data is in Mailtrap, broken down by email service provider. You need it in an Excel workbook to build the comparison chart for the incident report your manager is presenting tomorrow.
The slow version of your morning:
- You log into Mailtrap and look for an ESP breakdown view
- You find the stats but they default to all domains combined
- You filter by provider one at a time, note the numbers, switch
- By provider three you realize you need two weeks, not one week
- You redo the filtering process for the extended range
- The incident report chart has the wrong date range and your manager catches it during the review.
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 ESP breakdown directly into the workbook.
Open the SheetXAI sidebar and type:
Fetch Mailtrap sending statistics grouped by ESP for the last 14 days. Write each provider's name, delivered count, bounce count, open rate, and spam rate into columns A through E of the Stats tab. Sort by bounce count descending.
SheetXAI pulls the breakdown for all providers and writes it sorted by the metric that matters for the investigation.
What You Get
A ranked comparison table:
- Columns A–E — ESP name, delivered, bounce count, open rate, spam rate
- Sorted — worst bounce count at the top
- All providers in one table — no switching between filter views
The chart builds directly from this table. No reformatting, no transposing.
What If the Data Is Not Quite Ready
ESP-level investigations get more useful once you can see trends. SheetXAI handles multi-period and follow-on analysis in the same prompt.
When you need a 90-day trend instead of 14 days
Fetch Mailtrap sending stats grouped by ESP for the last 90 days. Show delivered count, bounce count, open rate, and spam rate. Calculate bounce rate as a percentage of delivered and write it into column F. Sort by bounce rate descending.
When you only need Gmail vs Microsoft head to head
Fetch Mailtrap sending stats grouped by ESP for the last 30 days. Filter to Gmail and Microsoft only. Write their delivered count, bounce count, and spam rate side by side into the Stats tab with one row per ESP.
When you need to break the ESP data down by sending domain too
Fetch Mailtrap sending stats for the last 30 days. Write two tables: one grouped by ESP in columns A through E, and one grouped by sending domain in columns G through K. So I can compare whether the bounce pattern follows the ESP or the domain.
When you need the ESP table plus a written diagnosis for the incident report
Fetch Mailtrap sending stats grouped by ESP for the last 14 days. Write the full comparison table into columns A through E sorted by bounce count descending. Calculate bounce rate as a percentage in column F. Write a two-sentence diagnosis into cell H1 identifying the worst-performing ESP, its rate, and whether the pattern suggests a content or authentication issue.
The pattern: data pull and interpretation in one prompt. The incident report is ready without a separate analysis pass.
Try It
Get the 7-day free trial of SheetXAI and open any workbook you use for deliverability investigations, then ask it to pull the Mailtrap ESP breakdown. The Mailtrap integration is included in every SheetXAI plan. See also how to compare stats by sending domain or the Mailtrap in Excel overview.