The Scenario
You're a growth marketer who inherited 500 scraped email addresses sitting in an Excel sheet from a previous contractor. They're in column A. No source, no date, no verification. Someone on the team wants to add them to an Emelia campaign next week. Your job, apparently, is to figure out which ones are worth keeping.
You've been burned by unverified lists before. Last time, a batch of 300 scraped addresses tanked the sender score on the warm-up domain and it took six weeks to recover.
The bad version:
- Copy emails from the spreadsheet in batches of whatever limit the verification tool's free plan allows, paste into the UI, wait for results, download another CSV, open it, try to match rows back to your original sheet, handle the ones that came back as "risky" or "accept-all" because the tool gives you five categories and none of them map cleanly to "add" or "skip."
- Repeat for the remaining four batches.
- End up with five partial result files you have to consolidate manually before you even know what you have.
Five hundred rows. Four hours. A spreadsheet that still needs a final cleanup pass before anyone can use it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It runs Emelia verification jobs for your email column and writes the results back to a column you specify — no batching, no secondary file.
Initiate Emelia email verification jobs for all emails in column A of my Google Sheet, poll until each job completes, and write the verification result to column B
What You Get
- Emelia's email verification API runs for each address in column A.
- Column B receives the verification status for each row — "valid," "invalid," "risky," or whatever Emelia's API returns for that address.
- Rows where the verification job fails to complete get flagged in column B with the error so you know which ones need a retry.
- You end up with a single annotated sheet rather than five partial CSVs.
What If the Data Is Not Quite Ready
Emails are mixed with duplicates
The scraped list has entries that appear two or three times. Running verification on duplicates wastes API calls.
Deduplicate column A by email address, then run Emelia verification on each unique email and write the result to column B — mark any removed duplicates as 'duplicate' in column B on their original rows
You want to keep only verified emails and delete the rest
After verification you want the sheet to contain only the addresses that came back valid.
Run Emelia verification on every email in column A, write the result to column B, then delete any rows where column B is 'invalid' so only verified addresses remain in the sheet
Some rows have extra content — names or notes — mixed with the email
The scraped data included text like "John Smith john@acme.com" instead of a clean email address.
Extract the email address from each cell in column A where the format is 'Name <email>', clean column A in place, then run Emelia verification on each extracted email and write the result to column B
Verify, flag risky addresses, and filter for campaign-ready contacts in one shot
You need a column that says "add to campaign" or "skip" without any manual interpretation of the verification categories.
Run Emelia email verification on all addresses in column A, write the raw result to column B, and write 'add' to column C if the result is 'valid' or 'skip' for anything else — deduplicate before running
The single prompt handles dedup, verification, and the campaign-readiness flag — you open the sheet and column C tells you exactly what to do with each row.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of scraped or unverified emails, then ask it to run Emelia verification and write the status back to a new column. For related workflows, see Find Emails for a Prospect List or the Emelia hub overview.