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 sheet 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 sheet 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 Google Sheet. 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 sheet.
For each domain in column A, run MXToolbox checks for SPF, DMARC, MX records, and blacklist status, then populate columns B through E with the results and add a column F with an overall PASS, FAIL, or WARNING score
What You Get
- Column B: SPF record status — PASS, FAIL, or MISSING
- Column C: DMARC policy and validation status
- Column D: highest-priority MX record hostname
- Column E: blacklist status — CLEAN or LISTED with count
- Column F: overall domain health score — PASS if all checks passed, WARNING if any check has concerns, FAIL if any check failed outright
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 tabs — Owned and Acquired
Run full MXToolbox email authentication audits — SPF, DMARC, MX, and blacklist — for all domains in column A of the Owned tab and the Acquired tab, write results into the adjacent columns on each tab, and create a Combined tab 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, then ask it to run a full email authentication audit across column A. Related: Bulk Blacklist Check or the MX Toolbox overview.