The Scenario
You're the onboarding engineer at a transactional email provider. Forty new customers just finished signup. Before you flip the sending switch on any of them, you need to confirm SMTP connectivity, TLS availability, and DNS alignment — and you need it documented in the onboarding tracker because your team lead reviews every new account before activation.
The customer success team already sent the "you're almost live" emails. The clock is running.
The bad version:
- Open MX Toolbox, go to SMTP Lookup, paste the first domain, wait for the connectivity test to complete, read through the banner response, note whether TLS is supported, go back to the sheet, enter those values into the row.
- Repeat for 39 more domains, hoping you don't mix up which result belonged to which row when the tab order gets confusing.
- End up with a tracker that has some columns filled in inconsistently because row 12 had a connection failure and you had to figure out how to record that.
Forty domains before you can activate a single account. Every manual lookup is time your new customers aren't sending.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your onboarding tracker and through its built-in MX Toolbox integration runs SMTP tests for every domain in the list, writing connection status, TLS availability, and failure reasons directly into the sheet.
For each domain in column A, run an SMTP test via MXToolbox and write the connection status, TLS supported yes or no, and any failure reasons into columns B, C, and D
What You Get
- Column B: connection status — connected, refused, or timeout — for each domain
- Column C: TLS supported — yes or no — based on the SMTP test result
- Column D: any failure reason returned by MX Toolbox, blank if the test passed cleanly
- Domains that fail show their reason immediately without any additional lookup
What If the Data Is Not Quite Ready
Need banner response for compliance documentation
Run SMTP tests via MXToolbox for all domains in column A, write the connection status in column B, TLS availability in column C, the SMTP banner response in column D, and any failure details in column E
Some domains have custom SMTP ports in a separate column
For each domain in column A, check column B for a custom SMTP port — if one is specified, include it in the MXToolbox SMTP test; otherwise use the default port. Write connection status, TLS, and any failures into columns C, D, E
TLS failures need to be escalated separately from connection failures
Run SMTP tests for all domains in column A using MXToolbox, write overall status in column B, and split results into column C for TLS-specific failures and column D for connection-level failures — mark column E as ACTIVATE, NEEDS-TLS-FIX, or UNREACHABLE based on which failure type applies
Full activation readiness check in one shot
For each domain in column A, deduplicate first, then run a MXToolbox SMTP test, write connection status, TLS support, and failure notes into columns B, C, D, and add an ACTIVATE or HOLD label in column E — ACTIVATE if both connection and TLS passed, HOLD otherwise
One prompt, activation queue ready. No more switching between tabs for every new account.
Try It
Get the 7-day free trial of SheetXAI and open your new customer onboarding tracker, then ask it to run SMTP tests across column A. Related: Bulk Email Deliverability Audit or the MX Toolbox overview.