The Scenario
You're the brand manager responsible for 25 sending domains across a large enterprise. The email team wants to roll out verified logo display in supported email clients, which means every domain needs a valid BIMI record and DMARC enforcement. You've been asked to produce a readiness report before the rollout decision meeting next week.
The person who asked you has no idea what BIMI is. They just know the rollout is on the agenda.
The bad version:
- Look up BIMI in MX Toolbox for the first domain, read the diagnostic output, check the DMARC enforcement level, note whether a BIMI record exists and whether it's valid, switch to the sheet, fill in three cells, move to the next domain.
- Repeat 24 more times. Realize on domain 18 that your DMARC policy column has inconsistent values because sometimes you wrote "p=reject" and sometimes you wrote "reject" and now it's going to need cleanup before you can present it.
- Deliver a report that needs a formatting pass before it can be shared with anyone.
The meeting is next week. The report needs to be shareable — not a personal working copy.
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 checks BIMI configuration and DMARC enforcement status for every domain, writing structured results directly into the sheet.
For every domain in column A, retrieve the BIMI record via MXToolbox and write whether a BIMI record exists, the DMARC policy level, and any diagnostic errors into columns B, C, and D
What You Get
- Column B: whether a BIMI record was found — YES or NO — for each domain
- Column C: DMARC policy level — none, quarantine, or reject — standardized across all rows
- Column D: any diagnostic errors from the BIMI check, blank if no issues
- Consistent formatting from row 1 to row 25 — no cleanup pass needed before sharing
What If the Data Is Not Quite Ready
Need a readiness label, not raw values
Check BIMI configuration for all domains in column A using MXToolbox and mark each as BIMI-READY if a valid BIMI record exists and DMARC policy is reject or quarantine, NEEDS-DMARC-ENFORCEMENT if BIMI exists but policy is none, or NO-BIMI-RECORD if no BIMI record was found — write the label in column B and the raw DMARC policy in column C
Some domains in the list are duplicates from a previous import
Deduplicate column A before running MXToolbox BIMI checks, then write BIMI presence, DMARC policy, and any errors into columns B, C, D for each unique domain
Need to separate errors from missing records
For each domain in column A, run a MXToolbox BIMI check and write the BIMI record status in column B, the DMARC policy in column C, and split column D into MISSING-RECORD for domains with no BIMI record versus CONFIGURATION-ERROR for domains that have a record but it failed validation
Full rollout readiness report in one shot
For all domains in column A, run MXToolbox BIMI and DMARC checks, write BIMI presence in column B, DMARC policy in column C, any errors in column D, and a ROLLOUT-READY or NOT-READY label in column E — sort so NOT-READY rows appear at the top
Walk into the rollout meeting with a decision-ready report instead of a draft.
Try It
Get the 7-day free trial of SheetXAI and open your sending domain inventory, then ask it to check BIMI configuration across column A. Related: Full Email Authentication Audit or the MX Toolbox overview.