The Scenario
You're a transactional email engineer at a B2B SaaS company. Your system fired a large campaign batch last Tuesday — 200 individual email jobs, each with its own UniSender send ID. A stakeholder in customer success pinged you this morning: several accounts reported they never received the email. You have the 200 send IDs in a Google Sheet, column A. You need to know which ones delivered, which ones bounced, and which ones opened, so you can figure out what happened and who needs a resend.
The bad version:
- Open UniSender. Navigate to the email message status lookup tool. Paste in send ID 1. Note the status. Switch to your sheet. Type it in column B. Switch back to UniSender.
- Repeat 199 more times.
- By send ID 80, you're not sure if you recorded the status for ID 73 or ID 74 last. Scroll back. Check. Continue.
- Two hours later you have 200 statuses in a column. The stakeholder is now waiting for a summary. You haven't had time to analyze anything.
The data exists in UniSender's database. There's no reason for you to move it one row at a time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the send IDs from column A and writes the delivery status for each one back into column B in a single operation.
Check the delivery status for all email IDs listed in column A of my Google Sheet and write the status result into column B. Use readable labels: delivered, bounced, opened, not sent.
What You Get
- All 200 statuses written into column B in one pass.
- Readable labels — "delivered," "bounced," "opened" — not internal status codes.
- The full picture in under a minute, ready for analysis.
- No chance of recording status for the wrong row.
What If the Data Is Not Quite Ready
You only want to flag the ones that bounced or were never delivered
Check delivery status for all email IDs in column A of my Google Sheet. Write the status into column B. Then add "review" in column C for any row where status is "bounced" or "not sent."
Some IDs in column A may be blank or malformed — skip those
Check delivery status for email IDs in column A. Skip any row where column A is blank or doesn't look like a valid numeric ID. Write "skipped - invalid" for those rows. Write the status into column B for all valid IDs.
You want to group the results by status in a summary tab
Check delivery status for all email IDs in column A. Write statuses into column B. Then write a summary into a separate tab called "Summary" showing: total IDs checked, count of each status type (delivered, bounced, opened, not sent).
Full diagnostic pass — lookup, flag, and write resend list in one shot
Check delivery status for all email IDs in column A of my Google Sheet. Write statuses into column B using readable labels. For any ID with status "bounced" or "not sent," copy the ID into a separate tab called "Resend Queue." Add a timestamp in column C of the main sheet for when each lookup was completed.
The diagnostic and the resend list — both ready before the customer success team's next sync.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your next batch of send IDs — ask it to look up all 200 statuses in one call and write them back alongside each ID. See also: pull campaign records into a sheet for reporting or the UniSender integration overview.