# Google Sheets Email Verification Template ($59/100K) | MailVeri

> Verify email addresses inside Google Sheets with our free Apps Script template ($59/100K, 1,000 free credits). Color-coded statuses and duplicate protection.

- **Source**: https://mailveri.com/integrations/google-sheets
- **AI Reference**: https://mailveri.com/llms-full.txt

---

Free Google Sheets Automation Template

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.

[Make a Copy (Clone Template)](https://app.mailveri.com/go/sheets/?utm_source=landing&utm_medium=integration&utm_campaign=google_sheets_template) · [Download Code.gs](https://mailveri.com/templates/google-sheets-mailveri.js)

1-Click Clone Template · Secure UserProperties (No Key Leaks) · Includes 1,000 Free Credits

1-Click

Verify directly inside your spreadsheet

$59

Cost per 100K verifications

99%

Deliverability accuracy rate

## 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)

1. Click the [Make a Copy (Clone Template)](https://app.mailveri.com/go/sheets/?utm_source=landing&utm_medium=integration&utm_campaign=google_sheets_template) button above.
2. In the cloned sheet, click **Extensions > Apps Script**, select `onOpen` from the toolbar dropdown, and click **Run (▸)** to complete Google's one-time permission grant.
3. Back in your Sheet, click **MailVeri > ⚙️ Set API Key** and paste your key from [MailVeri Developer Hub](https://app.mailveri.com/api-keys/).
  app.mailveri.com/api-keys/ · Copy your API Key here

  ![MailVeri Developer Hub API Keys management interface](https://mailveri.com/images/product/mailveri-developer-api-keys.png)
4. Highlight your email rows and click **MailVeri > ⚡ Verify Selected Emails**!

#### BOption 2: Add into an Existing Spreadsheet

1. Open your existing Google Sheet and go to **Extensions > Apps Script**.
2. Replace the contents of `Code.gs` with the code copied from the “Copy Apps Script (Code.gs)” button.
3. Save (Cmd+S / Ctrl+S) and refresh your Google Sheet. The **MailVeri** menu will appear instantly.

Google Apps Script Execution Core (UrlFetchApp) · Lightweight • Runs 100% inside Google Workspace cloud

```javascript
// 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());
```

MailVeri API Response Payload · Mapped to Sheet Status & Message Columns

```json
{
  "error": 0,
  "message": "Verified david.cooper@cloudscale.io successfully",
  "status": "VALID",
  "email": "david.cooper@cloudscale.io",
  "mail": "david.cooper@cloudscale.io",
  "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 | Credit Expiration | Net Spreadsheet Savings |
| --- | --- | --- | --- |
| MailVeri Apps Script | $59 | NEVER ExpireLifetime | BaselineBest Value |
| NeverBounce Add-on | $400$4.00/1k | Expires in 12 Months | Save 85% with MailVeri |
| ZeroBounce Add-on | $649$6.49/1k | Expires in 2 Years | Save 91% with MailVeri |
| BriteVerify | $600$6.00/1k | Expires in 12 Months | Save 90% with MailVeri |

## Frequently Asked Questions

Common questions about verifying email lists inside Google Sheets.

### Is my MailVeri API key safe inside a shared Google Sheet?

Yes. The MailVeri Google Apps Script stores your API key inside Google's encrypted `UserProperties` store, which is scoped strictly to your individual Google account and is never visible to spreadsheet collaborators or viewers.

### Does re-running the script charge twice for already verified rows?

No. The script inspects the status column before calling the API and automatically skips any row that already has a verification verdict, protecting your credits when new leads are appended to the sheet.

### When should I use Google Sheets vs MailVeri Bulk CSV upload?

Use the Google Sheets Apps Script for interactive lists up to a few thousand rows directly in your spreadsheet. For large lists from 5,000 to 1,000,000 rows, upload the CSV directly to the [MailVeri Dashboard](https://app.mailveri.com/dashboard/) for high-concurrency batch processing.

## Related Guides for Spreadsheet & No-Code Teams

[Apps Script & Make — How to Verify Emails in Google Sheets & Make.com Automatically — Copy-paste our free Google Apps Script custom formula and batch menu to verify sheet rows in place.](https://mailveri.com/blog/how-to-verify-emails-in-google-sheets-apps-script-make) · [No-Code Automation — How to Verify Emails in Zapier: Step-by-Step Automation Guide — Automatically verify new Google Sheets rows in real time using Zapier.](https://mailveri.com/blog/how-to-verify-emails-in-zapier) · [Outbound Hygiene — Why Apollo “Verified” Emails Still Bounce (And How to Fix It) — Why exported B2B spreadsheets require live SMTP verification before sending.](https://mailveri.com/blog/why-apollo-verified-emails-still-bounce) · [Spreadsheet Economics — EmailListVerify Pricing & Alternative: Clean Spreadsheets 68% Cheaper — Compare EmailListVerify ($27/10K, $186/100K) against MailVeri ($9/10K, $59/100K).](https://mailveri.com/blog/emaillistverify-pricing-alternative) · [2026 Cost Audit — MillionVerifier Pricing & Alternative: $9/10K vs $39 Minimum Entry — Verify 10,000 Google Sheets rows for $9 (or 1,000 free) with non-expiring credits.](https://mailveri.com/blog/millionverifier-pricing-alternative) · [Google Sheets Add-On — Reoon Email Verifier Alternative: Instant Sheets Verification Without Caps — Run Apps Script formulas across thousands of rows without hitting daily credit limits.](https://mailveri.com/blog/reoon-email-verifier-alternative)

## 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.

[Get 1,000 Free Credits](https://app.mailveri.com/accounts/signup/) · [Read API Docs](https://mailveri.com/docs/api)

Explore: [Make.com](https://mailveri.com/integrations/make) · [n8n Workflows](https://mailveri.com/integrations/n8n) · [Zapier](https://mailveri.com/integrations/zapier) · [Free Email Verifier](https://mailveri.com/tools/email-checker) · [Pricing ($59/100K)](https://mailveri.com/pricing) · [Compare 36 Verifiers →](https://mailveri.com/compare)

## Explore Related Verification Benchmarks, Integrations & Deliverability Hubs

Compare live 10K–5M verification rate cards, connect MailVeri to your outreach stack, or inspect domain-level SMTP rules.

Verifier Comparisons

[All 36 →](https://mailveri.com/compare)

- [MailVeri vs Snov.io100K checks: $59 vs $738/mo](https://mailveri.com/compare/mailveri-vs-snovio)
- [MailVeri vs Proofy100K checks: $59 vs $89](https://mailveri.com/compare/mailveri-vs-proofy)
- [MailVeri vs MillionVerifier100K checks: $59 vs $149](https://mailveri.com/compare/mailveri-vs-millionverifier)
- [MailVeri vs Bouncer100K checks: $59 vs $400](https://mailveri.com/compare/mailveri-vs-bouncer)
- [MailVeri vs Email Hippo100K checks: $59 vs $312](https://mailveri.com/compare/mailveri-vs-emailhippo)
- [MailVeri vs SafetyMails100K checks: $59 vs $212.80](https://mailveri.com/compare/mailveri-vs-safetymails)

CRM & Stack Guides

[All 13 →](https://mailveri.com/integrations)

- [n8n Self-Hosted WorkflowsAutomated HTTP Request node](https://mailveri.com/integrations/n8n)
- [HubSpot Marketing Contacts AuditPrevent 3% CRM bounce locks](https://mailveri.com/integrations/hubspot)
- [Zapier No-Code VerificationFilter invalid leads before CRM](https://mailveri.com/integrations/zapier)
- [Amazon SES & Sendy ProtectionStay safely below 5% SES probation](https://mailveri.com/integrations/aws-ses)
- [Clay.com HTTP API Waterfall0 Clay credits ($59 per 100K)](https://mailveri.com/integrations/clay)
- [FluentCRM & WordPress SMTPBulk CSV & PHP signup hooks](https://mailveri.com/integrations/fluentcrm)

Solutions & Free Tools

[All Tools →](https://mailveri.com/tools)

- [AI Startups & Indie HackersOutbound + trial token shield](https://mailveri.com/industries/ai-startups)
- [SPF Record Generator10-lookup validator & syntax builder](https://mailveri.com/tools/spf-generator)
- [Outbound & Lead Gen Agencies$299/1M bulk + 30% affiliate rev](https://mailveri.com/industries/outbound-agencies)
- [DMARC Record GeneratorConfigure p=quarantine / p=reject](https://mailveri.com/tools/dmarc-generator)
- [B2B SaaS Signup ProtectionBlock 100K+ burner domains](https://mailveri.com/industries/saas)
- [DNSBL Blacklist CheckerScan Spamhaus, Barracuda & SORBS](https://mailveri.com/tools/blacklist-checker)

Glossary & Domains

[Glossary](https://mailveri.com/glossary) · [Domains →](https://mailveri.com/domain)

- [Disposable EmailVerification & Address Types definition](https://mailveri.com/glossary/disposable-email)
- [Email ValidationVerification & Address Types definition](https://mailveri.com/glossary/email-validation)
- [Open RateList Hygiene & Campaign Metrics definition](https://mailveri.com/glossary/open-rate)
- [vercel.com B2B Domain ReportCloud platform MX & SPF status](https://mailveri.com/domain/vercel.com)
- [icloud.com & Hide My EmailApple relay & quota handling](https://mailveri.com/domain/icloud.com)
- [orange.fr French ISP Mail GuideTelecom webmail bounce protection](https://mailveri.com/domain/orange.fr)