The Scenario
You are a deliverability engineer. Over the last two weeks your overall bounce rate has crept up, but the aggregate number is not telling 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 a Google Sheet so you can build the comparison chart for the incident report.
The slow version of your morning:
- You log into Mailtrap and look for an ESP breakdown view
- You find the stats but they are in a chart, not a table
- You switch to a table view, realize the date range is not set to the last 14 days
- You adjust the range, look at the numbers, start writing them down
- You close the tab, open a new tab, realize you forgot the Yahoo number
- The incident report chart has a gap where the Yahoo bar should be.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that calls the Mailtrap stats API and writes the ESP breakdown directly into the sheet structure you need.
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. Sort by bounce count descending so the worst provider is at the top.
SheetXAI pulls the ESP-level breakdown and writes it sorted by the metric that matters for the incident investigation.
What You Get
A table ready for the chart:
- Column A — ESP name (Gmail, Yahoo, Microsoft, etc.)
- Column B — delivered count
- Column C — bounce count
- Column D — open rate
- Column E — spam rate
- Sorted — worst bounce count at the top
The chart builds from this table directly. No reformatting, no transposing, no manually entering Yahoo's number you forgot.
Ask SheetXAI to add a column F with bounce rate as a percentage of delivered, and the incident report chart has the axis you actually want.
What If the Data Is Not Quite Ready
ESP-level investigation often needs more than a flat table once you see the first cut of numbers. SheetXAI handles the follow-on analysis in the same session.
When you need a longer date range to spot a trend
14 days showed the spike but you want to see the 90-day trend to determine whether this is new or recurring.
Fetch Mailtrap sending stats grouped by ESP for the last 90 days. For each provider, show delivered count, bounce count, open rate, and spam rate. Also calculate bounce rate as a percentage of delivered and write it into column F. Sort by bounce rate descending.
When you need to compare two ESPs head to head
The incident report section compares Gmail vs Microsoft only, not the full ESP table.
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 this sheet with one row per ESP.
When you need to break the ESP data down by sending domain too
You want to know whether the Gmail bounce rate is uniform across your domains or concentrated on one.
Fetch Mailtrap sending stats for the last 30 days. Write two tables into this sheet: one grouped by ESP (columns A through E) and one grouped by sending domain (columns G through K), so I can compare whether the bounce rate pattern follows the ESP or the domain.
When you need the raw data plus a written diagnosis for the incident report
The report section needs a data table and a paragraph explaining what the numbers mean.
Fetch Mailtrap sending stats grouped by ESP for the last 14 days. Write the ESP table into columns A through E sorted by bounce count descending. Calculate bounce rate as percentage of delivered in column F. Then write a two-sentence diagnosis into cell H1 identifying the worst-performing ESP, its bounce rate, and whether the spam rate pattern suggests a content or authentication issue.
The pattern: data pull and interpretation in one prompt. The incident report is ready without flipping between the Mailtrap dashboard and the sheet.
Try It
Get the 7-day free trial of SheetXAI and open any sheet 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 Google Sheets overview.