The Scenario
You are a brand manager. Ten thousand postcards are queued. The campaign is set up in Stannp. The template has been through two rounds of revisions. Before you approve the send and commit the budget, you want to see the final rendered piece — what will actually go to print.
The campaign ID is in cell A1 of your approval tracking sheet. The Stannp sample API will generate a PDF preview. What is missing is the link, written into cell B1, so you can forward it to the creative director for a final check before you click submit.
The bad version:
- Log into Stannp, find the campaign in the list, click into the campaign detail, find the Preview or Sample option, wait for the PDF to generate, copy the temporary URL.
- Switch to the Google Sheet, paste the URL into cell B1, make a note that it expires in 30 minutes, send it to the creative director before it does.
- Creative director responds after 45 minutes. The link has expired. Generate a new one. Repeat.
A temporary preview URL for a ten-thousand-piece campaign should not require four context switches and a race against a 30-minute expiry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls the Stannp sample endpoint for the campaign ID in your sheet and writes the preview URL back into the cell next to it.
Generate a Stannp campaign sample PDF for the campaign ID in cell A1 and write the returned preview URL into cell B1.
What You Get
- Cell B1: the preview URL for the campaign PDF, ready to forward or click.
- The URL is generated fresh at the moment the prompt runs, giving you the full 30-minute window from that point.
- No context switching — the URL is in the sheet, next to the campaign ID it belongs to, ready for the approval workflow.
What If the Data Is Not Quite Ready
Multiple campaigns needing previews in batch
For each row in this sheet where column A contains a Stannp campaign ID, generate a PDF sample for that campaign and write the returned preview URL into column B of the same row.
Preview URL needs to be accompanied by the campaign name for the review doc
For each row in this sheet with a campaign ID in column A, fetch the campaign name from Stannp and generate a PDF sample, then write the campaign name into column B and the preview URL into column C.
Preview needed only for campaigns in draft status
For each row in this sheet with a campaign ID in column A, check the campaign status and only generate a PDF sample for campaigns with draft status — write the preview URL into column B for those rows and write Not draft into column B for the others.
Full pre-send approval package in one pass
For the campaign ID in cell A1, fetch the campaign details from Stannp — name, status, recipient count, and estimated cost — and write them into cells B1 through B4. Then generate a PDF sample and write the preview URL into cell B5.
Building the full pre-send snapshot in one prompt means the approval email writes itself: name, status, recipient count, cost, and a preview link, all in one sheet cell range.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you use for campaign approvals and ask it to generate Stannp preview links before you commit to a send. For creating the campaign and fetching cost estimates, see the estimate-campaign-cost spoke. For the hub overview, see How to Connect Stannp to Google Sheets.