The Scenario
You're an email marketing manager. The subscriber list has grown to 15,000 rows over the past year from three different acquisition channels, each with its own level of quality. Before the next campaign goes out — a big one, tied to a product announcement — you need to know which addresses are valid, which are risky, and which domain types you're sending to.
Your ESP flags high bounce rates. Last quarter's campaign hit 4.2% bounces. The threshold for a suppression review is 3%. You can't afford another quarter like that.
The bad version:
- Run the list through a bulk verifier tool that returns a CSV with its own column names, then spend an hour reconciling the column mapping back into your Google Sheet.
- Try to validate in batches because the tool's upload limit is 5,000 rows, so you do it three times and try to re-merge the results without duplicating rows.
- Pay for a premium list hygiene service, wait two business days, and receive a file you still have to map back to your sheet.
The campaign is scheduled for end of week. Procurement approval for new tooling takes five business days.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Google Sheet and calls Interzoid's email info API for every subscriber — validation status, domain type, and geographic region — written directly back into the sheet.
For every email in column A, call Interzoid's email info tool and write the validation status, domain type, and detected country to columns B, C, and D.
What You Get
- Column B: validation status per email (VALID, RISKY, INVALID).
- Column C: domain type — business, free, educational, disposable, or unknown.
- Column D: detected country associated with the email domain.
- A dataset ready for suppression list filtering before the send goes out.
What If the Data Is Not Quite Ready
Column A has some duplicate emails that snuck in across the three acquisition sources
Deduplicate column A (keep first occurrence), then call Interzoid's email info tool for each unique email and write the validation status, domain type, and country to columns B, C, and D.
You want to enrich with more fields and clean in one pass
Use Interzoid to enrich all emails in column B with trust score, deliverability verdict, and detected region — write results to columns C, D, and E, then filter to remove rows flagged INVALID.
The sheet also has a 'Source' column you want to keep — don't want filtering to lose it
Filter out rows where column B is blank before enriching. For all remaining rows, call Interzoid email info and write status, domain type, and country to columns C, D, and E. Do not delete any rows — just add a filter view showing non-INVALID records.
Full hygiene + enrichment in one pass
Deduplicate column A, skip blanks, call Interzoid email info for each unique non-blank email, write validation status to column B, domain type to column C, detected country to column D, and trust score to column E. Then create a summary below the data showing counts by validation status and counts by domain type.
The campaign goes out with a clean, enriched list and a summary you can share with your director.
Try It
Get the 7-day free trial of SheetXAI and open your subscriber sheet — ask SheetXAI to run the full Interzoid email enrichment pass before you finalize the send list. Then see the spoke on flagging risky emails before a campaign, or the full Interzoid integration overview.