The Scenario
You're the head of infrastructure at a company migrating to a new ESP. Before you sign the contract, legal wants a consolidated email health report — SPF, DKIM, DMARC, MX records, and blacklist status — for all 30 company-owned domains. They want it in the next 48 hours.
You have 30 domains and five check types. That's 150 separate MX Toolbox lookups if you do it manually.
The bad version:
- Open five different MX Toolbox lookup pages, work through each domain one at a time for each check type, enter results into the workbook domain by domain.
- Spend the first four hours on SPF and MX records, realize you still have DMARC, DKIM, and blacklist left, and that the workbook structure you chose for SPF doesn't scale well to five check types.
- Deliver something on time that requires a covering email explaining what the columns mean.
A 150-lookup manual process is not a deliverable. It's a transcription exercise dressed up as an audit.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your domain list and through its built-in MX Toolbox integration runs all five check types across every domain in one pass, writing a structured summary table back to the workbook.
Take all domains in my Domain Audit worksheet and use MXToolbox to check SPF, DKIM, DMARC, and blacklist for each one — write results into a summary table with one row per domain and one column per check
What You Get
- One column per check type: SPF status, DKIM status, DMARC policy, MX hostname, blacklist count
- An overall health score column — PASS if all checks passed, WARNING if any check has concerns, FAIL if any check failed outright
- One row per domain — formatted as a table legal can read without a decoder ring
What If the Data Is Not Quite Ready
DKIM needs a specific selector to test
For each domain in column A, check column B for a DKIM selector value — if one is specified, include it in the MXToolbox DKIM check; if column B is blank, skip the DKIM check and note SELECTOR-MISSING in the DKIM column. Write all other check results into columns C through F and an overall score in column G.
Domains span two worksheets — Owned and Acquired
Run full MXToolbox email authentication audits — SPF, DMARC, MX, and blacklist — for all domains in column A of the Owned worksheet and the Acquired worksheet, write results into the adjacent columns on each worksheet, and create a Combined worksheet with one row per domain and an overall PASS/FAIL/WARNING score in the final column
Some domains from the list are parked and should be excluded
Before running MXToolbox checks, look up each domain in column A and if the MX lookup returns no records, mark it as PARKED in column B and skip the remaining checks for that row — for all other domains, run SPF, DMARC, MX, and blacklist checks and write results into columns C through F
Single-prompt full audit with executive summary
For all domains in column A, run MXToolbox checks for SPF, DMARC, MX, DKIM, and blacklist, populate one column per check type, add an overall health score in the final column, and create a row at the top summarizing: total domains checked, total PASS, total WARNING, total FAIL
The report legal asked for, ready without 150 manual lookups.
Try It
Get the 7-day free trial of SheetXAI and open your domain inventory workbook, then ask it to run a full email authentication audit across column A. Related: Bulk Blacklist Check or the MX Toolbox overview for Excel.