The Scenario
You are a product marketer. Last month you sent a five-email onboarding sequence to every new trial user. The sequence is done running. Now you need to figure out which emails actually drove clicks and which ones were dead weight.
You want a Google Sheet with daily click totals and unique click counts for the past 30 days, so you can see which days spiked and correlate them with the emails that went out. You also want a breakdown by browser family to see whether mobile or desktop users are clicking more.
The attribution meeting is Friday at 3 PM and your boss will be asking why email 3 has a 2% click rate.
The slow version:
- Log into Postmark, navigate to click statistics
- Export whatever date range it allows
- Export the browser breakdown separately
- Combine the two CSVs in Sheets, reformat headers, add the unique click column
- You spend the morning on admin instead of analysis.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that fetches Postmark click data and writes it into the sheet in the format you need for analysis.
Open the SheetXAI sidebar and type:
Fetch Postmark total click counts for the past 30 days and write the daily date, unique click count, and total click count into columns A, B, and C of the 'Click Stats' sheet. Include a header row. Sort by date ascending.
SheetXAI calls the Postmark click stats endpoint and writes 30 rows. You have a clean table ready for a line chart before your next meeting.
What You Get
A 30-row daily click table in the 'Click Stats' sheet:
- Column A — date
- Column B — unique click count
- Column C — total click count
Sorted chronologically so the trend is immediately visible in a chart. You can see exactly which days the sequence drove traffic and which days were quiet.
Want the browser breakdown too? Add a second prompt:
Fetch Postmark click statistics grouped by browser family and write browser name and click count into columns A and B of the 'Browser Clicks' tab, sorted by count descending.
What If the Data Is Not Quite Ready
Click reporting requests always evolve after the first look.
When your boss wants click-to-open rate added alongside raw clicks
She mentioned it in the standup and you did not have time to add it before the meeting.
Pull Postmark click stats and open stats for the past 30 days. Write date, unique clicks, total clicks, and unique opens into columns A through D of the 'Click Stats' sheet. Add column E as click-to-open rate (unique clicks / unique opens) formatted as a percentage.
When you want to compare click volume in the first 15 days versus the last 15 days of the sequence
You want to see whether the sequence front-loaded or back-loaded its engagement.
Fetch Postmark click stats for the past 30 days. In the 'Click Comparison' sheet: write rows 1-15 (days 1–15 of the range) in columns A–C with date, unique clicks, total clicks. Write rows 16–30 in columns E–G in the same format. In column I, write the sum of unique clicks for each half and label them 'First 15 days' and 'Last 15 days'.
When you need the browser breakdown sorted alphabetically for a specific stakeholder
The VP of Design wants the browser table sorted alphabetically, not by click volume.
Fetch Postmark click statistics grouped by browser family and write browser name and click count into columns A and B of the 'Browser Clicks' tab, sorted alphabetically by browser name ascending.
When you need the full click brief — daily trend, browser breakdown, click-to-open rate, and a summary in one shot
The attribution meeting is in two hours.
Fetch Postmark click and open stats for the past 30 days. In the 'Click Stats' sheet: write date, unique clicks, total clicks, unique opens, and click-to-open rate (unique clicks / unique opens as a percentage) into columns A through E. Add a totals row at the bottom. In the 'Browser Clicks' tab: write browser name and click count sorted by count descending. Add a summary row at the top of 'Click Stats' showing total clicks, total unique clicks, average daily CTR, and the single day with the highest unique click count.
The pattern: instead of pulling data and calculating metrics separately, you ask for the complete attribution brief in one prompt.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull Postmark click analytics into any sheet you have open. The Postmark integration is included in every SheetXAI plan. For related workflows, see how to pull Postmark daily send stats for reporting or the Postmark in Google Sheets overview.