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 a Google Sheet she can open on her phone, 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 endpoint in the dashboard
- Export whatever subset it allows, reformat the column headers
- Realize the export only covers 14 days at a time, run it twice
- Paste both exports into the sheet, 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 spreadsheet that calls Postmark's outbound overview API and writes the stats directly into the sheet 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' sheet — 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 formula. The sheet is ready before your next Slack notification comes in.
What You Get
A clean 30-row daily stats table in the 'Email Stats' sheet:
- 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, date-sorted ascending. The CTO can open the sheet on her phone and see the trend immediately.
Want a summary row at the bottom? Tell SheetXAI to add a totals row for columns B through G and an average open rate in column H.
What If the Data Is Not Quite Ready
Reporting requests evolve. The format the CTO liked last quarter is never exactly the format she wants this quarter.
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' sheet. 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 in the meeting and you did not catch it until you were already back at your desk.
Re-run the 30-day Postmark stats pull into the 'Email Stats' sheet with the existing column layout, but add column I as click-through rate (clicked / delivered) formatted as a percentage.
When she wants to compare this month to last month 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 the same column layout. Fetch May stats and write them into the 'May Stats' tab. Then 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, open rate, click rate, month-over-month delta, and a summary row all in one shot
The CTO asked for everything at once for the board deck.
Fetch Postmark outbound overview stats for April and May. In the 'Deliverability' sheet: 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 them by hand, you ask for the full structure in one prompt and SheetXAI builds it.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull Postmark daily 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.