The Scenario
You're an email deliverability consultant. A client hands you an Excel workbook — 20 sending domains across their portfolio and 15 dedicated IP addresses they've acquired over the past year. They want a reputation audit before they migrate to a new ESP next month.
The last time you did one of these manually, you checked each domain in MXToolbox one by one, opened a separate tab for each IP, copied the blacklist results into a running notes doc, and spent three hours producing a table you could have used. Your client billed you for two. That gap isn't sustainable.
The bad version:
- Open EmailListVerify's blacklist checker, paste the first domain, screenshot or copy the result, paste it into a working worksheet
- Repeat for each of the 35 entries, switching between browser windows with increasing frequency
- Realize halfway through that you forgot to note which blacklists flagged the third IP, go back, start again
Thirty-five lookups isn't a lot of data. But it's enough manual repetition that the error rate climbs before you finish, and you're the one who has to present this to the client on a call Thursday morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the domain or IP column, submits each entry to EmailListVerify's blacklist endpoint, and writes the status and any listing details back to the workbook — one pass, no context switching.
Check every IP address in column A of my "Reputation Audit" worksheet against DNS blacklists using EmailListVerify and populate column B with whether it is listed and which blacklists flagged it
What You Get
- Column B: overall blacklist status — clean or listed, plus the names of blacklists that flagged each entry
- Rows stay aligned to the original domain or IP list, so you can sort by status without losing context
- Blank entries are skipped rather than submitted as empty strings to the API
- Results are formatted consistently so you can hand the workbook directly to the client
What If the Data Is Not Quite Ready
The worksheet has both domains and IP addresses in the same column
For each entry in column A of the "Reputation Audit" worksheet, detect whether it is a domain or an IP address, check it against EmailListVerify blacklists accordingly, and write the entry type to column B, blacklist status to column C, and flagging blacklist names to column D
You want to know when each domain was first flagged
Check each domain in column A of the "Reputation Audit" worksheet against EmailListVerify blacklists and write the status to column B, the flagging blacklist names to column C, and any first-seen date returned by the API to column D
Domains are split across client worksheets and you need a consolidated report
Check all domains in the "Client A," "Client B," and "Client C" worksheets against EmailListVerify blacklists, then write the results into a new "Consolidated Audit" worksheet with columns for client name, domain, status, and flagging blacklists
Generate the full audit report in one shot
Check every domain in column A and every IP in column B of the "Reputation Audit" worksheet against EmailListVerify blacklists, write results to columns C and D respectively, then create a summary row at the bottom counting how many are clean vs. listed and listing the top three blacklists that appeared
Ask for the checking and the summary in one prompt — SheetXAI handles the lookups and the aggregation together.
Try It
Get the 7-day free trial of SheetXAI and open your client's domain workbook, then ask SheetXAI to run every domain and IP through EmailListVerify's blacklist check and write the results back before your next audit call. See also: flagging disposable email domains and the EmailListVerify hub.