The Scenario
You're a marketing ops manager. The latest lead gen campaign pulled in 500 new contacts. Before they go into Mailchimp and start receiving the nurture sequence, you need to run a hygiene check — because three campaigns ago, a batch of disposable-domain emails made it through and tanked your sender reputation for two months.
The form doesn't filter disposable addresses. Nobody has time to check 500 rows manually. And the last person who built a validation script left the company.
The bad version:
- Paste emails one by one into a free verifier website — which has a rate limit of 10 per minute without a paid account.
- Export to a third-party list cleaning service, wait 24 hours, import the results, and then figure out which columns map to which verdicts.
- Skip the hygiene step entirely and deal with the bounce rate and deliverability dip afterward.
The campaign send is scheduled for tomorrow morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Google Sheet and calls Interzoid's email trust scoring API for every row — no export, no import, no waiting.
For every email in column B (500 rows), call Interzoid to get the trust score and write the numeric score into column C and 'VALID', 'RISKY', or 'INVALID' into column D based on score thresholds.
What You Get
- Column C: numeric trust score (0-99) per email from Interzoid.
- Column D: a categorical verdict — VALID, RISKY, or INVALID — based on the thresholds Interzoid returns.
- The marketing platform import now uses only VALID rows, with RISKY rows held for manual review.
What If the Data Is Not Quite Ready
Some emails in column B have trailing spaces or are in mixed case
Trim and lowercase all email addresses in column B before calling Interzoid for trust scores — write cleaned emails to column C, scores to column D, and verdicts to column E.
You want to also remove INVALID rows immediately rather than just flag them
Delete all rows where column D is 'INVALID' and highlight rows where column D is 'RISKY' in yellow.
Column B has some clearly malformed entries (missing @ sign) mixed in
For each row in column B, first check for basic email format (must contain @ and a dot after it). Flag malformed entries as 'MALFORMED' in column D without calling Interzoid. For the rest, call Interzoid for the trust score, write it to column C, and write the verdict to column D.
Full hygiene pass in one shot
For every email in column B: trim whitespace and lowercase, check for basic format validity, call Interzoid for trust scores on valid-format emails, write scores to column C and verdicts (VALID/RISKY/INVALID/MALFORMED) to column D. Then delete all rows marked INVALID or MALFORMED and highlight RISKY rows yellow.
One prompt handles the formatting, the validation bypass, the API calls, the scoring, the deletions, and the highlighting.
Try It
Get the 7-day free trial of SheetXAI and open your lead capture sheet — ask SheetXAI to run the hygiene pass on column B before you push to Mailchimp. Then see the spoke on full email enrichment with domain and geographic data, or the Interzoid integration overview.