How to Verify Emails in Google Sheets

How to Verify Emails in Google Sheets

Method 1: Add-On

Install from Google Workspace Marketplace. MailEntriX adds a VERIFYEMAIL formula directly to your spreadsheet.

Method 2: Apps Script

Write custom script calling the verification API. Open Script Editor from Extensions menu.

Setting Up

Create verifyEmail function. Use UrlFetchApp for HTTP requests. Parse JSON response. Store API key in Script Properties.

Batch Processing

Create batch function for large lists. Collect all emails, send to bulk API, write results back.

Handling Results

Add columns for status, score, details. Use conditional formatting: green valid, red invalid, yellow risky.

Limitations

Apps Script has 6-minute execution limit. For lists over 10,000, export to CSV and use bulk upload instead.

Automating

Use time-based triggers to run verification on schedule. Verify new entries added to shared sheets nightly.