The Scenario
You're a sales analyst at a B2B software company. Your team has a Google Sheet with 150 prospect emails — contacts from LinkedIn outreach, inbound form fills, and a few conference connections. Before this list goes to the sales team as a prioritized outreach queue, your VP wants to know which of these prospects are already in UniSender, what lists they're on, and whether any of them have unsubscribed. Reaching out to an unsubscribed contact is a compliance problem. Sending a cold email to someone who's already been through an onboarding sequence is a first-impression problem.
You have the emails. You need the enrichment. The executive sync is at 9 AM tomorrow.
The bad version:
- Open UniSender. Use the contact search. Type email 1. Note the result — subscribed, on list 8842 and 9123, two custom field values. Switch to your sheet. Type it all in.
- Search email 2. Subscribed, no list data returned — you're not sure if that means they were removed or if the lookup works differently. Note "unclear." Switch back to sheet.
- After 30 contacts, you've been at this for 45 minutes. You have 120 left and a deck to finish tonight.
A hundred and fifty lookups, one at a time, for data that exists in a database you're already connected to.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the email addresses from column A, looks each one up in UniSender, and writes the enrichment data back into adjacent columns in one operation.
For each email in column A of my Google Sheet, look up the contact in UniSender and write their subscription status into column B, the list IDs they belong to into column C, and any custom field values into columns D onward. Use the custom field names as column headers.
What You Get
- Subscription status for all 150 prospects, written into column B.
- List memberships in column C — so you know which contacts are already in an active nurture sequence.
- Custom field values pulled into their own labeled columns for any prospect UniSender has on record.
- Contacts not found in UniSender left blank or marked "not found," so the sales team knows who is truly new.
What If the Data Is Not Quite Ready
You only need to flag which prospects have an "unsubscribed" status
For each email in column A of my Google Sheet, look up the contact in UniSender. Write "unsubscribed" into column B if their status is unsubscribed. Leave column B blank for all others. Do not write any other data.
You want to enrich only the rows where column B is currently blank
For each email in column A of my Google Sheet where column B is currently empty, look up the contact in UniSender. Write subscription status into column B and list IDs into column C.
Some emails in column A may be malformed — validate before looking up
Check each email in column A for valid format. Write "invalid" into column B for malformed addresses. For all valid addresses, look up the contact in UniSender and write subscription status into column B and list IDs into column C.
Full enrichment and prioritization in one pass
For each email in column A of my Google Sheet, look up the contact in UniSender. Write subscription status into column B, list IDs into column C, and custom field values into subsequent columns. Mark any contact with status "unsubscribed" 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.
The compliance check, the CRM enrichment, and the prioritization order — one prompt before the 9 AM sync.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your next prospect batch — ask it to check each email against UniSender and write back whatever your sales team needs before outreach begins. See also: bulk import contacts into UniSender or the full UniSender integration overview.