Verify Email Lists Inside Google Sheets.
Zero CSV Exports Required.
Clean prospect lists, Apollo exports, and scraped contacts directly in your spreadsheet. One-click verification with custom menus, automated status color-coding, and account-level key security.
Designed for Spreadsheet Power Users
Engineered with production-grade safety features so you can verify thousands of emails smoothly.
Custom MailVeri Toolbar Menu
Adds a dedicated MailVeri menu to your top bar. Simply highlight any column or cell range and click ⚡ Verify Selected Emails.
Account-Level Key Security
API keys are saved in Google's encrypted UserProperties. Your key stays private to your Google account and is never exposed to team members or viewers.
Automated Color-Coded Verdicts
Results are immediately styled: soft green for VALID, soft red for INVALID, and amber for CATCH_ALL.
Duplicate & Repeat Protection
The script automatically inspects adjacent columns and skips rows that already have a verified verdict, saving your credits when working on growing lists.
Quick Setup: How to Use in 60 Seconds
AOption 1: Clone the Ready-to-Use Google Sheet (Recommended)
- Click the Make a Copy (Clone Template) button above.
- In the cloned sheet, click Extensions > Apps Script, select
onOpenfrom the toolbar dropdown, and click Run (▸) to complete Google's one-time permission grant. - Back in your Sheet, click MailVeri > ⚙️ Set API Key and paste your key from MailVeri API Keys.
- Highlight your email rows and click MailVeri > ⚡ Verify Selected Emails!
BOption 2: Add into an Existing Spreadsheet
- Open your existing Google Sheet and go to Extensions > Apps Script.
- Replace the contents of
Code.gswith the code copied from the “Copy Apps Script (Code.gs)” button. - Save (Cmd+S / Ctrl+S) and refresh your Google Sheet. The MailVeri menu will appear instantly.
// MailVeri API call within Google Apps Script (UrlFetchApp)
var response = UrlFetchApp.fetch('https://api.mailveri.com/v1/verify-mail/', {
method: 'post',
headers: {
'Authorization': 'Bearer ' + apiKey
},
payload: {
'mail': emailAddress
},
muteHttpExceptions: true
});
var result = JSON.parse(response.getContentText());{
"error": 0,
"message": "Verified [email protected] successfully",
"status": "VALID",
"email": "[email protected]",
"mail": "[email protected]",
"balance": 4999
}Stop Paying Legacy Prices for Spreadsheet Email Cleaning
Most Google Sheet extensions charge high markups. MailVeri connects directly to our high-throughput API at true developer rates:
| Provider | Cost per 100K | Unknown / Inconclusive Policy | Net Spreadsheet Savings |
|---|---|---|---|
| MailVeri Apps Script | $59 | 100% Instant Auto-Refund | Baseline (Best Value) |
| NeverBounce Add-on | $400 ($4.00/1k) | Full charge (No refund) | Save 85% with MailVeri |
| ZeroBounce Add-on | $390 ($3.90/1k) | Full charge (No refund) | Save 85% with MailVeri |
| BriteVerify | $400 ($4.00/1k) | Full charge (No refund) | Save 85% with MailVeri |
Start cleaning spreadsheets in Google Sheets today
Sign up in 30 seconds and receive 1,000 free API credits to test your Google Sheets template now.