The Scenario
You're a sales analyst at a B2B software company. You have 150 prospect emails in an Excel workbook, collected from LinkedIn outreach and inbound forms over the past month. Before the list goes to the sales team as an outreach queue, you need to check which of these prospects already exist in UniSender — so you can flag unsubscribed contacts before anyone reaches out to them, and identify who's already deep in a nurture sequence. The sales kickoff is tomorrow at 8 AM.
The bad version:
- Open UniSender. Search for email 1 in the contact lookup. Note the result — subscribed, on two lists, two custom field values. Switch to Excel. Type it in.
- Search email 2. No result returned. Does that mean the contact doesn't exist, or that the lookup requires a different format? Try with and without a subdomain. Get the same empty result. Write "unknown."
- After 30 lookups, you've been at this for 50 minutes. You have 120 left. The workbook still doesn't have anything in it that you'd call analysis.
A hundred and fifty lookups, each requiring a window switch, for data that lives in a database you're already connected to.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the emails from column B, looks each one up in UniSender, and writes the enrichment data back into adjacent columns in a single pass.
Enrich my Excel sheet by fetching UniSender contact details for every email in column B — add columns for status, tags, and any custom fields returned. Use the custom field names as column headers.
What You Get
- Subscription status for all 150 prospects written into the workbook.
- Tags and list memberships in separate columns.
- Custom field values labeled with their public names, not IDs.
- "Not found" written for any email that doesn't exist in UniSender, so the sales team knows who is genuinely new.
What If the Data Is Not Quite Ready
Only flag the unsubscribed contacts — don't need the full enrichment
For each email in column B of my Excel sheet, look up the contact in UniSender. Write "unsubscribed" into column C if their status is unsubscribed. Leave column C blank for all others.
Only enrich rows where column C is currently empty
For each email in column B of my Excel sheet where column C is currently empty, look up the contact in UniSender. Write subscription status into column C and list IDs into column D.
Validate email format before running lookups
Check each email in column B for valid format. Write "invalid" into column C for malformed addresses. For all valid addresses, look up the contact in UniSender and write subscription status into column C and list memberships into column D.
Full enrichment and prioritization in one pass
For each email in column B of my Excel sheet, look up the contact in UniSender. Write subscription status into column C, list IDs into column D, and custom field values into subsequent columns using field names as headers. Mark any unsubscribed contact in a "do_not_contact" column. Sort the results so unsubscribed contacts appear at the bottom and contacts already on a list appear at the top.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your next prospect batch — ask it to check each email against UniSender and write back the enrichment your sales team needs before outreach begins. See also: bulk import contacts into UniSender from Excel or the full UniSender integration overview.