How to Verify Emails in Google Sheets (Free Method)

Got a list of emails in Google Sheets and need to verify them?

You don't need to export, upload, and re-import. You can verify emails right inside Google Sheets with a simple method.

Here's how to do it — step by step.

Why Verify Emails in Google Sheets?

If you collect emails from:

• Lead generation forms
• Event registrations
• Manual research
• Partner lists

...you need to verify them before sending campaigns.

Invalid emails hurt your sender reputation and waste your email marketing budget.

Google Sheets makes it easy to clean your lists without switching tools.

Method 1: Use PureMail API with Google Apps Script (Free)

This method connects Google Sheets directly to PureMail's API.

Step 1: Get Your PureMail API Key

Sign up for PureMail and grab your API key from the dashboard.

Go to Dashboard > API Keys and copy your key.

Step 2: Open Your Google Sheet

Open the spreadsheet with your email list.

Make sure your emails are in a single column (e.g., Column A).

Step 3: Open Apps Script Editor

In Google Sheets:

1. Click Extensions > Apps Script
2. Delete any existing code
3. Paste this script:

function verifyEmails() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const apiKey = 'YOUR_PUREMAIL_API_KEY'; // Replace with your actual API key

  // Get email column (assuming emails are in column A)
  const emailRange = sheet.getRange('A2:A' + sheet.getLastRow());
  const emails = emailRange.getValues();

  // Add headers if not present
  if (sheet.getRange('B1').getValue() === '') {
    sheet.getRange('B1').setValue('Status');
    sheet.getRange('C1').setValue('Reason');
  }

  // Verify each email
  emails.forEach((row, index) => {
    const email = row[0];

    if (email) {
      try {
        const url = 'https://puremail.dev/api/v1/verify/single';
        const options = {
          method: 'post',
          headers: {
            'Authorization': 'Bearer ' + apiKey,
            'Content-Type': 'application/json'
          },
          payload: JSON.stringify({ email: email })
        };

        const response = UrlFetchApp.fetch(url, options);
        const result = JSON.parse(response.getContentText());

        // Write results back to sheet
        sheet.getRange(index + 2, 2).setValue(result.status);
        sheet.getRange(index + 2, 3).setValue(result.reason || '');

        // Add delay to avoid rate limiting
        Utilities.sleep(500);

      } catch (error) {
        sheet.getRange(index + 2, 2).setValue('Error');
        sheet.getRange(index + 2, 3).setValue(error.message);
      }
    }
  });

  SpreadsheetApp.getUi().alert('Verification complete!');
}

Step 4: Replace Your API Key

Find this line:

const apiKey = 'YOUR_PUREMAIL_API_KEY';

Replace YOUR_PUREMAIL_API_KEY with your actual API key.

Step 5: Save and Run

1. Click the Save icon
2. Name your project (e.g., "Email Verifier")
3. Click Run > verifyEmails
4. Grant permissions when prompted

The script will verify each email and add results in columns B and C.

Step 6: Review Results

Once complete, you'll see:

• Column B: Status (valid, invalid, risky)
• Column C: Reason (if invalid or risky)

Now you can filter and remove invalid emails before sending.

Method 2: Manual Verification with PureMail (No Code)

Don't want to use scripts? No problem.

Step 1: Export Your List

1. Select your email column in Google Sheets
2. Copy the emails
3. Paste into a text editor or CSV file

Step 2: Upload to PureMail

1. Go to PureMail Dashboard
2. Click Verify Emails > Bulk Upload
3. Upload your CSV or paste emails

Step 3: Download Results

PureMail will verify your list and provide:

• Valid emails
• Invalid emails
• Risky emails
• Detailed reasons for each

Step 4: Re-Import to Google Sheets

Download the verified list and paste it back into your Google Sheet.

Filter out invalid emails and you're ready to send.

Pro Tips

Verify regularly: Even good emails go bad over time. Re-verify your lists every 3-6 months.

Use conditional formatting: In Google Sheets, highlight "invalid" rows in red for easy filtering.

Batch large lists: If you have 10,000+ emails, verify in batches of 5,000 to avoid timeouts.

Cache results: Store verification results so you don't verify the same email twice.

Why PureMail for Google Sheets?

• Fast API with real-time verification
• Clear results with reasons (not just pass/fail)
• Developer-friendly for custom scripts
• Free tier available to get started

The Bottom Line

Verifying emails in Google Sheets doesn't have to be complicated.

Use the Apps Script method for automation, or the manual method for simplicity.

Either way, you'll clean your list and protect your sender reputation — without leaving your spreadsheet.

Stop sending to bad emails. Start verifying in Google Sheets.

👉 Get your free PureMail API key and start verifying