Email Validation Extension for Google Sheets

ZeroBounce now offers an extension through the Google Workspace Marketplace for Google Sheets. This add-on can validate your email list directly within Google Sheets.

All you’ll need is your ZeroBounce API key and a spreadsheet containing the email addresses you wish to validate.

Installing the ZeroBounce extension

Once the extension verifies your API key, you can validate emails in Google Sheets.

How to validate emails in Google Sheets

The extension will automatically create a new Status column next to the column containing your emails. This will not impact or remove any other existing columns.

As the ZeroBounce email validator begins to process your list, the status column will show the email as “Valid” in green or “Invalid” in red.

If the email address is invalid, it will also provide the email’s sub-status in parentheses, i.e., “Invalid (do_not_mail).”

Our documentation provides a full breakdown of our email validation status codes. You can access our documentation anytime by clicking on the extension and selecting “Documentation.”

If you previously used the extension and already have the Status column present, a new validation attempt will reset any existing status values. Then, the latest status for each email will appear in the same column.

Once finished, you’ll receive a notification in the bottom-right corner of the sheet that reads “Email Validationⓘ Finished.” The notice will also display how many credits were used and how many still remain in your account.

Checking your credit balance

To check on your ZeroBounce credit balance from Google Sheets

Purchasing credits

You can also top off your ZeroBounce credit balance directly from the Google Sheets extension.

Take advantage of the Google Sheets extension to easily validate your email list without visiting the ZeroBounce dashboard.

If you have any questions or need assistance setting up your extension, please contact our support team - available 24/7.