Email Validation Extension for Google Sheets

Installing the ZeroBounce extension

1. Go to a document within Google Sheets.
2. Under Extensions, go to Add-ons and click Get add-ons.

3. Search for ZeroBounce in the search bar. Click on the add-on listing.

4. Select ZeroBounce extension and then click Install.
5. Refresh Google Sheets. You will now see ZeroBounce Email Validator in the Extensions menu.
6. Go to the ZeroBounce Email Validator menu and click on Settings.

7. In the API key field, enter your ZeroBounce API key.

If necessary, please visit the URL to obtain your API key.

8. Click Save.

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

How to validate emails in Google Sheets

1. Go to the Sheet that contains the emails you wish to validate.
2. Go to ZeroBounce Email Validator from the Extensions menu, and click on Validate Emails.

The extension will automatically detect which column contains your emails.

3. A confirmation window will appear that reads “Are you sure you want to validate the emails?” Click Yes.

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

1. Go to ZeroBounce Email Validator in the Google Sheets Extensions menu.
2. Go to Credits and click Check Balance.

3. A pop-up window on the screen will tell you how many credits you have remaining.

Purchasing credits

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

1. Go to ZeroBounce Email Validator in the Google Sheets Extensions menu.
2. Go to Credits and click Buy Credits.

3. A new page in your browser directs you to the Pricing & Plans page within your ZeroBounce dashboard.

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.