The Scenario
A compliance manager at a SaaS company woke up to 200 unsubscribe requests sitting in an Excel workbook — collected from a web form over the past two weeks. Column A is email address. Column B is blank. The next campaign wave is scheduled to go out in 36 hours, and none of those emails are in Emelia's blacklist yet.
This isn't the first time. The last time a campaign went out before the opt-out list was processed, legal got involved. That conversation took a full afternoon. The manager still has the email thread.
The bad version:
- Open Emelia, navigate to the blacklist page, paste one email at a time into the add field, click add, go back, paste the next.
- Lose your place after the fiftieth row because the page refreshes, start counting from wherever you think you left off.
- Finish the session uncertain whether you added 186 or 194 — close enough to probably fine, but not something you'd want to write in an audit log.
Two hundred entries at thirty seconds each is an hour of work that produces a result you can't fully verify.
The Easy Way: One Prompt in SheetXAI
SheetXAI is inside your Excel workbook. It reads the opt-out list directly and sends each address to Emelia's blacklist API. You don't touch the Emelia UI.
Read all emails in column A of my Excel sheet and add each one to the Emelia blacklist in a single pass, logging 'done' in column B for each successful addition
What You Get
- Every email in column A is submitted to Emelia's blacklist.
- Column B receives "done" for each address successfully added.
- Any address that fails — already on the blacklist, malformed, API error — gets a note in column B with the reason.
- You have a full writeback record in the workbook you can include in any audit trail.
What If the Data Is Not Quite Ready
Emails are mixed with non-email text in column A
The form that collected opt-outs didn't validate input, so some rows in column A contain "unsubscribe@" or just a name instead of a valid email address.
Filter column A for valid email addresses only, add each valid email to the Emelia blacklist, write 'done' to column B for successes and 'invalid' for rows that weren't valid email addresses
The list spans two worksheets
Sheet1 has opt-outs from the web form. Sheet2 has opt-outs collected by the sales team manually. You need both processed.
Add all emails from column A on Sheet1 and column A on Sheet2 to the Emelia blacklist, writing the result in column B on each respective worksheet
Some emails are already blacklisted
Running the same export twice is common. You don't want duplicate errors stopping the run.
For each email in column A, attempt to add it to the Emelia blacklist — if it's already present write 'already blacklisted' in column B, if it's new write 'done', if there's another error write the error
Deduplicate the opt-out list, validate the emails, and blacklist in one pass
The form data has duplicates and some rows are clearly not valid addresses.
Deduplicate column A, validate that each remaining entry is a properly formatted email address, add the valid unique addresses to the Emelia blacklist, and write the result — 'done', 'already blacklisted', or 'invalid' — to column B for every row
Combining the cleanup and the action into one prompt means you process a clean list once instead of cleaning it, running it, and then cleaning up the error log after.
Try It
Get the 7-day free trial of SheetXAI and open your opt-out Excel workbook, then ask it to push every address in the email column to the Emelia blacklist. For related workflows, see Remove Erroneously Blacklisted Emails or the Emelia hub overview.