The Scenario
Your sales team's Excel workbook has 800 cold-outreach prospects — names, companies, titles, and email addresses in column B. It's the SDR team's primary working list for the next six weeks. Someone on the team noticed that outreach performance has been inconsistent, and the hypothesis is that a chunk of the emails in the list are low-quality — bad domains, no SMTP confirmation, addresses that look real but won't deliver. The team lead wants the list scored before Monday's sequencing session so reps are working from the top down with confidence.
The bad version:
- Try to run 800 Mailboxlayer API calls from a script someone cobbled together last quarter, hope the API key is still valid, get back 800 JSON objects
- Figure out which fields map to "quality" — is it the score field? The smtp_check flag? Some combination? — and manually decide on a threshold
- Paste the scores into column C, then manually sort the 800-row workbook by column C without accidentally scrambling the other columns
Sorting a prospect list by email quality score is a two-minute task if the data is already in the workbook. Getting it into the workbook is the whole problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the prospect list, calls Mailboxlayer for every email in column B, writes the quality scores and deliverability flags back into the workbook, and sorts the rows — all from one prompt. No script, no API docs, no JSON parsing.
Excel 'Prospect List' has email in column C — run Mailboxlayer on each, add columns for score, disposable, and mx_found, then flag rows with score below 0.7 as 'Low Quality' in column G
What You Get
- Score column: Mailboxlayer quality score from 0 to 1 per prospect — higher is more confident
- Disposable column: flags addresses from temporary inbox services that should be removed from outreach
- mx_found column: TRUE or FALSE — FALSE here means the domain itself may not exist
- Column G: 'Low Quality' for any prospect with a score below 0.7, blank otherwise — a single filter field for the team to act on
What If the Data Is Not Quite Ready
Some emails in column B have typos — common domain misspellings like gmial.com
Scan column B for common email domain typos (gmial, yahooo, outlok, etc.), correct them in place, then validate all 800 emails with Mailboxlayer and write the quality score, disposable flag, and mx_found to new columns, then flag rows with score below 0.7 as 'Low Quality'
I want to sort the workbook by score descending after flagging low-quality rows
Validate all emails in column B with Mailboxlayer, write the quality score, disposable flag, and mx_found to new columns, add 'Low Quality' in the next column for any row with score below 0.7, then sort the entire worksheet by the score column descending
The list has emails on two worksheets — 'Inbound' and 'Outbound' — and I need both scored
Validate all emails in column B of the 'Inbound' worksheet and column B of the 'Outbound' worksheet using Mailboxlayer — write the quality score, disposable flag, and mx_found to new columns on each worksheet, flag rows below 0.7 as 'Low Quality'
Correct typos, score everything, segment low-quality rows into a separate worksheet in one pass
Correct obvious email domain typos in column B, validate all emails with Mailboxlayer, write quality score, disposable flag, and mx_found to new columns, flag rows with score below 0.7 as 'Low Quality', sort the main worksheet by score descending, then cut all 'Low Quality' rows to a new worksheet called 'Low Priority'
Combining correction, scoring, flagging, and segmentation in a single prompt produces cleaner results than running those steps one at a time.
Try It
Get the 7-day free trial of SheetXAI and open your prospect workbook — however many rows, however many worksheets — and ask it to score every email by Mailboxlayer quality and flag the weak ones. Also see bulk validating lead gen emails or the full Mailboxlayer integration overview.