The Scenario
You are a deliverability engineer. The CTO wants a 30-day email performance summary by Thursday. She asked last quarter too, and you spent two hours building that one.
The data is all in Postmark, daily sent, delivered, bounced, opened, clicked, and spam complaint counts for each of the past 30 days. The CTO does not have a Postmark login. She expects an Excel workbook she can open on her laptop, with dates in column A and the six metrics across columns B through G, plus a calculated open rate in column H.
The slow version:
- Log into Postmark, navigate to the outbound stats section, export the CSV
- Open it in Excel, clean the column headers
- Realize the export only covers 14 days at a time, run it twice
- Paste both exports, merge them, check for gaps
- Add the open rate formula manually across 30 rows
- You have been at this for an hour and a half.
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 outbound overview API and writes the stats directly into the workbook in the format you specify.
Open the SheetXAI sidebar and type:
Fetch Postmark outbound overview stats for the past 30 days and write daily sent, delivered, bounced, opened, clicked, and spam complaint counts into columns A through G of the 'Email Stats' tab — date in column A. Add a header row and calculate open rate (opened / delivered) in column H as a percentage.
SheetXAI calls the Postmark stats endpoint, handles the date range, writes 30 rows of daily data, and adds the open rate column. The workbook is ready before your next meeting.
What You Get
A clean 30-row daily stats table in the 'Email Stats' tab:
- Column A — date
- Column B — emails sent
- Column C — delivered
- Column D — bounced
- Column E — opened
- Column F — clicked
- Column G — spam complaints
- Column H — open rate (calculated as a percentage)
Header row included, sorted by date ascending. The CTO can open the workbook and see the trend in a chart immediately.
What If the Data Is Not Quite Ready
Reporting requests evolve after the first look.
When she wants a 14-day view instead of 30
Scope changed in the meeting.
Fetch Postmark outbound overview stats for the past 14 days and write sent, delivered, bounced, opened, clicked, and spam counts into columns A through G of the 'Email Stats' tab. Add a header row and calculate open rate in column H.
When she wants click-through rate added alongside open rate
The CTO mentioned CTR after you sent the file.
Re-run the 30-day Postmark stats pull into the 'Email Stats' tab with the existing column layout, but add column I as click-through rate (clicked / delivered) formatted as a percentage.
When she wants April compared to May side by side
The ask evolved from "show me 30 days" to "show me how May compares to April."
Fetch Postmark outbound stats for April and write them into the 'April Stats' tab with date, sent, delivered, bounced, opened, clicked, and spam columns. Fetch May stats into the 'May Stats' tab in the same layout. Create a 'Comparison' tab with columns for date, and for each metric the April value, the May value, and the percentage change.
When you need the full deliverability briefing — stats, rates, month-over-month delta, and totals all in one shot
The board deck is due in three hours.
Fetch Postmark outbound overview stats for April and May. In the 'Deliverability' tab: write daily rows for both months with columns for date, sent, delivered, bounced, opened, clicked, spam, open rate, and click rate. Add a totals row for each month. Add a summary table at the top showing total sent, average open rate, average CTR, and total bounces for each month side by side.
The pattern: instead of running separate pulls and formatting by hand, you ask for the full structure in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull Postmark daily 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.