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 current question: what percentage of recipients open via Gmail mobile, Apple Mail, and Outlook?
That split drives every layout decision you make. If 60% of your audience is on Gmail mobile, dark-mode support and image-blocking matter more than pixel-perfect Outlook table layouts. If Outlook 2019 is still 25% of the opens, you are building two versions of every email.
The data is in Postmark. You want it in Google Sheets so you can build a chart for the design review deck.
The slow version:
- Log into Postmark, navigate to the email client stats section
- Export whatever it allows, reformat the headers
- Realize you need the platform breakdown separately from the client breakdown, run a second export
- Paste both into the sheet, clean up duplicates
- An hour of admin work before you even open Figma.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that calls Postmark's email client stats endpoint and writes the breakdown directly into the sheet, formatted for a chart.
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' sheet. Sort by percentage descending. Include a header row.
SheetXAI calls the Postmark email client API, paginates through all results, and writes them sorted by share. The sheet is ready for a pie chart before you finish your next coffee.
What You Get
A clean client breakdown in the 'Client Stats' sheet:
- Column A — email client name (Gmail, Apple Mail, Outlook, etc.)
- Column B — client version or platform variant
- Column C — percentage share of opens
Sorted by percentage descending, so the clients that matter most appear first. Drop the table into a chart and you have the design review slide.
Want the platform-level summary (mobile vs. desktop vs. webmail) instead of the granular client list? Add a second prompt:
Summarize the Postmark client stats in the 'Client Stats' sheet 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 to see month-over-month shifts in client share, 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' sheet. Fetch May stats and write them into columns A and B of the 'May Clients' sheet. Then create a 'Client Trends' sheet with columns for client name, April percentage, May percentage, and the change.
When the client names from Postmark 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' sheet. In column D, write a clean display name for each client — map 'Gmail Image Proxy' to 'Gmail (Cached)', 'Apple Mail' to 'Apple Mail', 'Outlook' variants to 'Outlook', and anything unrecognized to 'Other'.
When you want to segment the data by a specific message stream
Your transactional and broadcast streams have different audiences and the design decisions are different for each.
Fetch Postmark email client usage stats for the 'transactional' message stream for the past 30 days and write client name, version, and percentage into columns A, B, and C of the 'Transactional Clients' sheet. Fetch the same for the 'broadcast' stream and write into the 'Broadcast Clients' sheet.
When you need the full design brief — client breakdown, platform grouping, month-over-month delta, and a summary in one shot
The design review is in two hours and you need everything.
Fetch Postmark email client usage stats for April and May. In the 'Client Stats' sheet: 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 clients into Mobile, Desktop, and Webmail with their combined percentages. Sort everything by May percentage descending.
The pattern: instead of pulling raw data and then 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 sheet you have open. The Postmark integration is included in every SheetXAI plan. For related workflows, see how to pull Postmark click analytics into a sheet or the Postmark in Google Sheets overview.