The Scenario
A sales manager at a fintech startup ran a bulk import into Emelia three weeks ago from a sheet that hadn't been properly cleaned. Thirty email addresses were blacklisted as part of that import — not because they opted out, but because an automated script misidentified them as bounces. The campaign that was supposed to hit those accounts never did.
The manager found the error in this week's review. Those 30 addresses are sitting in a Google Sheet in column A. The contacts are qualified. Getting them out of the blacklist is the only thing blocking the re-send.
The bad version:
- Log into Emelia, open the blacklist management page, search for the first email address, find the entry, click remove, confirm, go back, search for the next one.
- The search isn't instant — each lookup takes a moment — and after the twelfth removal you mis-click and remove the wrong entry and have to re-add it.
- Finish the session, run a quick check to confirm the 30 are gone, find three that didn't take, do those again.
Thirty contacts. Forty minutes. A process that has no audit trail in the sheet and no way to confirm completion other than manually searching Emelia again.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the email addresses, calls Emelia's blacklist API to remove each one, and writes the result back to the sheet.
Remove every email address in column A of my Google Sheet from the Emelia blacklist and mark column B as 'unblocked'
What You Get
- Each email in column A is submitted to Emelia's blacklist removal endpoint.
- Column B receives "unblocked" for every address successfully removed.
- Any address that fails — not found on the blacklist, API error, already removed — gets a note in column B with the reason.
- The sheet becomes your audit trail: you can share column B with the stakeholder who asked for confirmation.
What If the Data Is Not Quite Ready
Some addresses on the sheet might not actually be on the blacklist
The list was compiled quickly and a few rows may have already been cleared in a previous manual pass.
For each email in column A, attempt to remove it from the Emelia blacklist — if it's already been removed or isn't present write 'not on blacklist' in column B, if removed successfully write 'unblocked', if there's an error write the error
The list has duplicates
The same email appears in the sheet more than once because it was collected from two different sources.
Deduplicate column A by email address, then remove each unique email from the Emelia blacklist and write the result to column B — mark any duplicate rows as 'duplicate, skipped' in column B
You need to remove emails and simultaneously re-enrol them in a campaign
Unblocking isn't enough — these contacts also need to be added back to the 'Re-engagement Q2' campaign.
Remove every email in column A from the Emelia blacklist, mark column B as 'unblocked', then add each successfully unblocked contact to my Emelia campaign 'Re-engagement Q2' and mark column C as 'enrolled'
Validate the addresses, check the blacklist status, remove, and log in one shot
The manager wants a full audit: which ones were on the blacklist, which ones weren't, which ones are now unblocked.
For each email in column A, check whether it's currently on the Emelia blacklist and write the current status to column B, then remove any that are listed and write 'unblocked' to column C — leave column C blank for any that weren't on the list
The single prompt gives you a two-column audit trail: what the status was, and what happened.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of wrongly blacklisted email addresses, then ask it to clear each one from Emelia. For related workflows, see Bulk Add Opt-Out Emails to the Emelia Blacklist or the Emelia hub overview.