The Scenario
Your sales team's Google Sheet 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 sheet 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 sheet. Getting it into the sheet is the whole problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the prospect list, calls Mailboxlayer for every email in column B, writes the quality scores and deliverability flags back into the sheet, and sorts the rows — all from one prompt. No script, no API docs, no JSON parsing.
Column B of this sheet has email addresses for 800 prospects — validate each with Mailboxlayer, write the quality score to column C and smtp_check result to column D, then sort the sheet by column C descending
What You Get
- Column C: Mailboxlayer quality score from 0 to 1 per prospect — higher is more confident
- Column D: smtp_check result — TRUE if the mail server confirmed the address exists, FALSE if it couldn't
- The full sheet sorted by column C descending, so the reps at the top of the list are working the highest-confidence prospects first
- Rows with smtp_check FALSE in column D, even if the score is moderate, give reps a visible signal to deprioritize
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 to column C and smtp_check to column D, sorted by score descending
I want to flag rows with score below 0.7 as 'Low Quality' in a separate column
Validate all emails in column B with Mailboxlayer, write the quality score to column C and smtp_check to column D, then add a column E with 'Low Quality' for any row where the score is below 0.7 and 'OK' for the rest — sort by column C descending
The list has emails on two tabs — 'Inbound' and 'Outbound' — and I need both scored
Validate all emails in column B of the 'Inbound' tab and column B of the 'Outbound' tab using Mailboxlayer — write the quality score to column C and smtp_check to column D on each tab, sorted by score descending
Clean bad domains, score everything, flag low-quality rows, and move them to a separate tab in one pass
Correct obvious typos in email domains in column B, validate all emails with Mailboxlayer, write quality score to column C and smtp_check to column D, flag any row with score below 0.7 as 'Low Quality' in column E, sort the main sheet by score descending, then move all 'Low Quality' rows to a new tab called 'Low Priority'
Combining the cleanup, validation, scoring, and segmentation into one prompt is faster than running any of those steps separately.
Try It
Get the 7-day free trial of SheetXAI and open your prospect sheet — even if there are typos, mixed formatting, or a thousand rows — and ask it to score every email by Mailboxlayer quality and sort the list. Also see bulk validating lead gen emails or the full Mailboxlayer integration overview.