The Scenario
You are on a deliverability team that manages four sending domains in Mailtrap. Over the last 30 days, your overall bounce rate has been climbing but the aggregate number does not tell you which domain is causing it.
You need the per-domain breakdown in a Google Sheet so you can run the analysis and identify which domain's DNS records need attention before the next major send in five days.
The slow version:
- You log into Mailtrap and look for a domain-level breakdown
- You find the stats but the view shows all domains combined by default
- You filter by domain one at a time, write down the number, switch to the next domain
- By domain three you realize you need this for two months, not one
- You repeat the filtering process for the second month
- You spend Tuesday doing data entry and have no time to actually fix the DNS.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that pulls the Mailtrap domain-level stats and writes the comparison table directly into the sheet.
Open the SheetXAI sidebar and type:
Fetch Mailtrap sending stats for the last 30 days grouped by sending domain. Write each domain's name, delivered count, bounce rate, open rate, and spam rate into columns A through E. Sort by bounce rate descending so the worst domain is at the top.
SheetXAI pulls the stats for all four domains and writes the sorted comparison table. The domain causing the problem is in row 2.
What You Get
A ranked comparison table with the worst performer at the top:
- Column A — sending domain
- Column B — delivered count
- Column C — bounce rate
- Column D — open rate
- Column E — spam rate
- Sorted — highest bounce rate first
You see the problem domain immediately. No switching between Mailtrap filter views, no writing down numbers domain by domain, no losing your place.
From here, you can ask SheetXAI to add a "DNS Remediation Priority" column and flag any domain with a bounce rate above your threshold.
What If the Data Is Not Quite Ready
Domain comparisons get more useful when you can see trends, not just a single period. SheetXAI handles multi-period pulls in the same prompt.
When you need two months side by side
You want to see whether the bounce rate has been climbing across all domains or just one.
Fetch Mailtrap sending stats grouped by sending domain for March 2026 and April 2026 separately. Write March data into columns A through E and April data into columns G through K, with the same column structure. So I can compare month over month for each domain in one view.
When you only want to see domains with a bounce rate above a threshold
You have seven domains and only want to investigate the ones that are actually over threshold.
Fetch Mailtrap sending stats grouped by sending domain for the last 30 days. Filter to domains where bounce rate exceeds 2%. Write name, delivered count, bounce rate, and spam rate into columns A through D for the filtered domains only. Write the count of flagged domains into cell F1.
When you need to add a calculated column for bounce rate as a percentage
The raw stats show counts, but your DNS team wants the rate expressed as a percentage for the escalation ticket.
Fetch Mailtrap sending stats grouped by domain for the last 30 days. Write domain name, delivered count, and bounced count into columns A through C. Calculate bounce rate as bounced divided by (delivered plus bounced) and write it as a percentage into column D. Sort by column D descending.
When you need the domain comparison plus a written escalation summary
Your DNS team needs a data table and a summary paragraph they can paste into the escalation ticket without further interpretation.
Fetch Mailtrap sending stats grouped by sending domain for the last 30 days. Write the full comparison table into columns A through E sorted by bounce rate descending. Then write a two-sentence escalation summary into cell G1 identifying the domain with the highest bounce rate, its rate, how it compares to the next-worst domain, and the recommended first remediation step based on whether the issue looks like a bounce or a spam rate problem.
The pattern: pull the data and the interpretation in one prompt. The escalation ticket is ready for the DNS team without a separate analysis pass.
Try It
Get the 7-day free trial of SheetXAI and open any sheet you use for deliverability monitoring, then ask it to pull the Mailtrap domain-level breakdown. The Mailtrap integration is included in every SheetXAI plan. See also how to compare stats by email service provider or the Mailtrap in Google Sheets overview.