The Scenario
You are an email designer. The design review is next Tuesday and you need to decide which rendering quirks to fix first. Your question: what percentage of recipients open via Gmail mobile, Apple Mail, and Outlook?
That split drives every layout decision. If 60% of your audience is on Gmail mobile, dark-mode support matters more than pixel-perfect Outlook table layouts. If Outlook 2019 is still 25% of opens, you are building two versions of every email.
The data is in Postmark. You want it in Excel so you can build a chart for the design review deck.
The slow version:
- Log into Postmark, navigate to email client stats, export the CSV
- Open it in Excel, clean headers, remove columns you do not need
- Realize you need the platform breakdown separately, run a second export
- Paste both, clean up duplicates
- An hour of admin before you even open the design file.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls Postmark's email client stats endpoint and writes the breakdown directly into the workbook.
Open the SheetXAI sidebar and type:
Fetch Postmark email client usage statistics for the past 30 days and write client name, version, and percentage share into columns A, B, and C of the 'Client Stats' tab. Sort by percentage descending. Include a header row.
SheetXAI calls the Postmark email client API, handles pagination, and writes the results sorted by share. The workbook is ready for a pie chart before your next meeting.
What You Get
A clean client breakdown in the 'Client Stats' tab:
- Column A — email client name
- Column B — client version or platform variant
- Column C — percentage share of opens
Sorted by percentage descending. Drop the table into a chart and you have the design review slide.
Want a platform-level summary grouped by Mobile, Desktop, and Webmail?
Summarize the Postmark client stats in the 'Client Stats' tab by grouping rows into Mobile, Desktop, and Webmail categories, and write the grouped totals into columns E and F.
What If the Data Is Not Quite Ready
The client stats API is clean, but the analysis on top of it usually is not.
When you want month-over-month shifts, not just the current 30 days
The design lead wants to know if Apple Mail's share has grown since the iOS update.
Fetch Postmark email client stats for April and write client name and percentage into columns A and B of the 'April Clients' tab. Fetch May stats and write them into 'May Clients'. Create a 'Client Trends' tab with columns for client name, April percentage, May percentage, and the change.
When the client names need to be cleaned up for the deck
Postmark returns values like "Gmail Image Proxy" that your design lead will not recognize.
Fetch Postmark email client stats for the past 30 days and write them into the 'Client Stats' tab. In column D, write a clean display name for each client — map 'Gmail Image Proxy' to 'Gmail (Cached)', 'Outlook' variants to 'Outlook', anything unrecognized to 'Other'.
When you need to segment by message stream
Your transactional and broadcast streams have different audiences.
Fetch Postmark email client stats for the 'transactional' stream for the past 30 days and write client name, version, and percentage into the 'Transactional Clients' tab. Fetch the same for 'broadcast' and write into 'Broadcast Clients'.
When you need the full design brief — client breakdown, platform grouping, month-over-month, and a summary all in one shot
The design review is in two hours.
Fetch Postmark email client stats for April and May. In the 'Client Stats' tab: write May client name, version, and percentage into columns A, B, and C. In column D, write the April percentage for the same client. In column E, write the month-over-month change. In columns G and H, add a platform summary grouping into Mobile, Desktop, and Webmail. Sort by May percentage descending.
The pattern: instead of pulling raw data and grouping and comparing by hand, you ask for the complete brief in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull Postmark email client stats into any workbook you have open. The Postmark integration is included in every SheetXAI plan. For related workflows, see how to pull Postmark click analytics in Excel or the Postmark in Excel overview.