The Scenario
It's the third week of January. Your digital marketing analyst role involves reporting on email performance every quarter, and Q4 just ended. Your VP wants a deck with campaign-level data — names, send dates, statuses, open rates if you can get them — covering all of 2025. You have access to UniSender. You do not have a pre-built report. You have a blank Google Sheet and a deadline for end of day Friday.
The bad version:
- Log into UniSender, navigate to the campaigns section, filter by date range, and discover the UI only shows 20 campaigns per page. Click through 18 pages manually, copying campaign names and IDs into a notepad.
- Find the export option, request a CSV. The CSV arrives with columns named differently than you expected, and the "sent date" field is in a format Excel refuses to recognize as a date.
- Import into Sheets, fix the dates, realize the status column uses internal codes like "S" and "D" instead of "Sent" and "Draft," spend 15 minutes figuring out the mapping, write a VLOOKUP to translate them.
It's 4 PM Friday. The deck is due at 5. You have 360 rows and a column of status codes you just decoded.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to UniSender directly and pulls campaign records into your sheet with readable field values — no UI pagination, no CSV reformatting.
Fetch all UniSender campaigns from 2025-01-01 to 2025-12-31 and write campaign name, sent date, status (use human-readable labels), and campaign ID into my Google Sheet starting at row 2. Add headers in row 1.
What You Get
- One row per campaign covering all of 2025.
- Human-readable status labels — "Sent," "Draft," "Scheduled" — not internal codes.
- Dates formatted as YYYY-MM-DD, ready for sorting or charting.
- Campaign IDs in a dedicated column for any follow-up lookups.
What If the Data Is Not Quite Ready
You only want campaigns that were actually sent, not drafts or scheduled
Fetch all UniSender campaigns from 2025-01-01 to 2025-12-31 where status is "sent." Write campaign name, sent date, and ID into my Google Sheet. Exclude any campaigns with a status other than sent.
You need Q1 and Q2 broken into separate tabs
Pull UniSender campaigns from 2025-01-01 to 2025-03-31 and write them into the "Q1" tab with headers. Then pull campaigns from 2025-04-01 to 2025-06-30 and write them into the "Q2" tab with headers.
You want to flag campaigns with unusually low recipient counts
Fetch all UniSender campaigns from 2025-01-01 to 2025-12-31. Write campaign name, sent date, status, recipient count, and ID into my Google Sheet. Add a "flag" column and mark any campaign where recipient count is below 50.
Full reporting pull with sorting and summary row
Fetch all UniSender campaigns from 2025-01-01 to 2025-12-31 that have a status of "sent." Write campaign name, sent date, recipient count, and ID into my Google Sheet sorted by sent date ascending. Add a final row with total campaigns and total recipients.
Cleanup, filtering, and summary logic — all in one prompt instead of three separate steps.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next quarterly review, then ask it to pull your UniSender campaign history into a structured report. See also: check delivery status for specific sends or the UniSender integration overview.