The Scenario
Your marketing director wants to review Q1 campaign performance before the quarterly all-hands. The ask landed in your inbox at 4 PM: total sent, in production, delivered, and returned — for the past three months — written into the campaign performance sheet by tomorrow morning.
Stannp has the data. It is in the reporting API. The sheet is open. What sits between them is the work of figuring out the right endpoint, constructing the date range query, parsing the response, and mapping the status counts to the right cells — which is not something you were planning to do at 4 PM on a Thursday.
The bad version:
- Open Stannp's reporting UI, set the date range to Q1, wait for the summary to load, read the status counts off the screen, switch to the Google Sheet, find the right row, type the numbers in manually.
- Realize the reporting UI only shows the current time zone and your sheet uses a different regional format for dates — spend 10 minutes figuring out whether the count is right.
- Get an email at 8 PM asking whether the numbers include test sends. Go back to Stannp to check. Fix one cell in the sheet. Send a reply.
Manual extraction from a reporting UI is fast enough once. It becomes a recurring tax on whoever gets tagged in the request every quarter.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls the Stannp reporting API for a date range and writes the status breakdown directly into your sheet.
Fetch the Stannp reporting summary for mailpieces sent between the dates in cells A1 and B1 and write the total sent, delivered, in-production, and returned counts into cells C1, C2, C3, and C4.
What You Get
- Cell C1: total mailpieces sent in the date range.
- Cell C2: count with delivered status.
- Cell C3: count still in production.
- Cell C4: returned or undeliverable count.
- The figures come directly from the API, not from a UI screenshot — no manual copy step in the chain.
What If the Data Is Not Quite Ready
Date range stored as text rather than date values
Parse the date strings in cells A1 and B1 — assuming MM/DD/YYYY format — convert them to ISO 8601, fetch the Stannp delivery summary for that range, and write the sent, delivered, in-production, and returned counts into cells C1 through C4.
Multiple date ranges needed for a quarter-by-quarter comparison
For each row in this sheet where column A and column B contain start and end dates, fetch the Stannp delivery summary for that date range and write the total sent, delivered, in-production, and returned counts into columns C through F of the same row.
Counts needed as percentages in addition to raw totals
Fetch the Stannp delivery summary for the date range in cells A1 and B1, write the raw counts into C1 through C4, and write the percentage of the total for each status into D1 through D4 as decimal values formatted to two decimal places.
Full campaign performance snapshot in one pass
Fetch the Stannp delivery summary for each quarter in this sheet (date ranges in columns A and B), calculate the delivery rate as delivered divided by sent for each row, and write the raw counts into columns C through F and the delivery rate percentage into column G.
Pulling the aggregation and computing the rate in one prompt means the slide is ready before anyone asks for it twice.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you use for campaign reporting and ask it to pull delivery summaries from Stannp for any date range. For the full mailpiece audit log, see the audit-mailpiece-log spoke. For the hub overview, see How to Connect Stannp to Google Sheets.