Google Sheets Add-on

Validate email lists directly in Google Sheets. One-click bulk verification of entire columns with full SMTP-level validation.

Download the Add-on Script

Get the Google Apps Script source files. Install manually from the Apps Script editor or deploy as a shareable add-on.

Download ZIP
email-validator-sheets.zip — 4 files (Code.gs, sidebar.html, settings.html, appsscript.json)

Overview

The Email Validator for Google Sheets add-on brings full SMTP email verification directly into your spreadsheets. Select any range of email addresses, click validate, and get color-coded results written right next to your data — all powered by the email-validaton.com API.

Perfect for data teams, marketers, and sales teams who manage email lists in Google Sheets. No more exporting to external tools or manually checking emails one by one.

How It Works

1. Connect Your API Key

Get your API key from the Email Validator dashboard, then paste it into the add-on settings. The key is stored securely in your Google account and never shared.

2. Select Your Emails

Select any range containing email addresses, or use "Validate Entire Column" to automatically find and process every email in a column. The add-on detects emails in mixed-content cells.

3. Validate with One Click

Click Email Validator → Validate Selected Emails from the Sheets menu. Each email is sent to the email-validaton.com API for full SMTP verification (MX lookup, SMTP handshake, mailbox check).

4. Get Color-Coded Results

Results are written two columns to the right of your selection. Each status is color-coded for instant visual scanning.

Valid (green) Invalid (red) Risky (amber) Catch-all (yellow) Disposable (orange) Unknown (gray)

Email Statuses Returned

Each validated email receives one of the following statuses:

Status Meaning Credit Cost
valid Email accepts mail (SMTP 250 response from destination server) 1 credit
invalid Email rejected (SMTP 550), no MX, bad domain, invalid format 1 credit
risky Low-reputation address, graylisted, temporary issues 1 credit
catch_all Server accepts all emails — cannot verify individual mailboxes Free
disposable Temporary/disposable email service (e.g. Mailinator) Free
unknown Could not determine (timeout, no response, network error) Free
retry Temporary server failure — try again later Free

Installation

  1. Download the ZIP file from the download box above and extract it.
  2. Open any Google Sheets spreadsheet.
  3. Go to Extensions → Apps Script.
  4. Delete any placeholder code in the default Code.gs file.
  5. Copy and paste the contents of Code.gs from the extracted files.
  6. Create new files in the Apps Script editor:
    • appsscript.json — copy the manifest
    • sidebar.html — copy the sidebar UI
    • settings.html — copy the settings dialog
  7. Click the Save button or press Ctrl+S.
  8. Reload your Google Sheet — you'll see Email Validator in the main menu.

Future versions will be available directly from the Google Workspace Marketplace.

Setup

  1. Open Google Sheets where you installed the add-on.
  2. Go to Email Validator → Settings from the menu.
  3. Enter your API key from email-validaton.com/dashboard → Account → API Keys.
  4. Click Save & Test. You'll see your plan name and credit balance if connected successfully.
  5. You're ready to validate!

Usage

Validate Selected Emails

  1. Select cells containing email addresses (any range).
  2. Go to Email Validator → Validate Selected Emails.
  3. Confirm the number of cells to validate.
  4. Results appear 2 columns to the right — status, confidence, MX server, reason.

Validate Entire Column

  1. Click any cell in the column containing emails.
  2. Go to Email Validator → Validate Entire Column.
  3. The add-on auto-detects all email addresses in that column and validates them.

Sidebar Control Panel

Open Email Validator → Start to access the sidebar with:

  • Live credit balance — always see remaining credits
  • Plan information — which tier you're on
  • One-click validate — the same options as the menu
  • Quick access to settings — change API key

Requirements

  • A Google account (personal or Workspace)
  • An API key from email-validaton.com (free registration required)
  • Credits or a subscription plan for validation:
    • Free Tier — 200 single checks per month
    • Credit Packs — pay-as-you-go, credits never expire
    • Subscription — monthly automatic renewal

Technical Architecture

API Endpoints Used

Endpoint Method Purpose
/api/v1/verify POST Validate a single email address
/api/v1/account GET Retrieve account details, plan, credit balance
/api/v1/credits GET Fast credit check (lightweight endpoint)

Data Flow

  1. User selects email range in Google Sheets.
  2. Add-on extracts unique email addresses from the selection.
  3. Credit check via /api/v1/credits to ensure enough quota.
  4. Emails are validated one-by-one via /api/v1/verify (POST).
  5. Results (status, confidence, MX server, reason) are written back to the sheet.
  6. Status cells are color-coded for instant visual scanning.

Rate Limiting

The add-on processes emails with a ~1.6 request/second pacing to respect API rate limits and ensure reliable delivery. For large lists (up to 5,000 emails), validation can take several minutes. Progress is displayed in the sidebar.

OAuth Scopes

  • spreadsheets.currentonly — read/write the current spreadsheet only
  • script.container.ui — display sidebar and modal dialogs
  • script.external_request — call the email-validaton.com API

Google Apps Script Runtime

  • Runtime: V8 (modern JavaScript)
  • Maximum execution: 6 minutes per invocation
  • API key storage: UserProperties (secure, per-user)
  • No external dependencies required

Support

← Back to All Add-ons