The Scenario
You are a sales ops manager. Your SDR team just purchased a cold-lead list of 300 company domains and they want to load it into the outbound sequencing tool. Last quarter, 40% of the cold list bounced because the domains had no active mail servers.
Before this list goes in, you need MX records and WHOIS creation date for every domain. Fresh domains and no-MX domains go to a "Review" pile. Everything else goes to the sequencer. The SDR manager needs the split by 3 PM today.
The bad version of this morning:
- You open MXToolbox, enter domain one, read the MX records
- You run a WHOIS lookup in a separate browser tab, note the creation date
- Repeat for domain two, domain three
- By 11 AM you have checked thirty-eight domains and have 262 left
- You tell the SDR manager 38 of 300 are verified. He loads the full 300 anyway.
The fast version is one prompt and it runs while you work on something else.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your domain list and calls the API Ninjas DNS and WHOIS endpoints for each row, writing the results back to the workbook.
Open the SheetXAI sidebar and type:
For each domain in column A, look up the MX records using API Ninjas and write the primary mail server hostname and priority into columns B and C. Fetch WHOIS registration data for every domain and add the registrar name, creation date, and expiration date into columns D, E, and F.
SheetXAI calls both endpoints for all 300 domains and writes five fields per row.
What You Get
A domain enrichment workbook ready for the sequencer decision:
- Column B: Primary MX hostname
- Column C: MX priority — blank means no MX record
- Column D: Registrar name
- Column E: Creation date
- Column F: Expiration date
Filter column C for blanks and column E for domains under 12 months old — those go to the Review pile. The rest go to the sequencer.
What If the Data Is Not Quite Ready
B2B lead workbooks always have noise. SheetXAI handles it alongside the enrichment.
When some domains have subdomains in the list
Your list has a mix of root domains and subdomains that should be resolved to root before MX lookups.
Strip any subdomain prefix from domains in column A before running MX and WHOIS lookups. Write the root domain into column B, then fill MX server into column C and WHOIS creation date into column D.
When you want to auto-flag the Review pile
Instead of manually filtering, you want SheetXAI to add the split flag directly.
After filling MX and WHOIS data, add a "Disposition" column G. Write "REVIEW" for any domain with no MX record or creation date less than 12 months ago. Write "APPROVED" for all others.
When you want a count summary for the SDR manager
He wants a quick number, not just a flag column.
After flagging REVIEW and APPROVED in column G, count each and write a summary in cells I1:J3 showing totals for APPROVED, REVIEW, and all domains.
When the full pre-sequencer validation is one prompt
Three hundred domains, MX check, WHOIS creation date, auto-flagging, and a summary count, all before 3 PM.
For each domain in column A, look up MX records via API Ninjas and write primary mail server into column B and priority into column C. Fetch WHOIS data and write registrar into column D, creation date into column E, expiration date into column F. Write "REVIEW" in column G for domains with blank MX or creation date under 12 months ago, and "APPROVED" for the rest. Count each in cells I1:J3.
The pattern: two API calls per row, conditional flagging, and a summary table all in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open any domain list or cold-lead workbook, then ask SheetXAI to run MX and WHOIS validation using API Ninjas. The API Ninjas integration is included in every SheetXAI plan. See also how to validate phone and email in a lead list in Excel or the API Ninjas in Excel overview.