Clearout - Email verification Add-on for Google sheets

Clearout add-on for Google Sheets allows you to verify and validate email addresses directly on Google sheets.
Integrate your Google Sheets with Clearout to run the verifications at your convenience. With this feature, you can manage your database better by avoiding multiple uploads, downloads, and running between the lists.

How to Verify emails in Google Sheets in just 3 Simple Steps

1) How to get Clearout Add-on?

The procedure is straight forward will take less than 5 minutes.

  1. Login to your Gmail account
  2. Open a Google sheet
  3. Go to ‘Add-ons’ in the ‘Menu-Bar’
  4. Go to ‘Get Add-ons’ and search for ‘Clearout’
  5. Click on ‘Install’ (If you have an existing account on ‘Clearout’, great otherwise start off with creating an account)- Register
  6. Once installed and allowed access, a pop-up will open on the right of your sheet.

2) How to integrate Google sheets with Clearout?

Once the Add-on is installed, link the Clearout account with these steps
  1. Go to 'API Token' at the bottom of the pop-up to link your account.
  2. A new window will open with a link 'API token here'. Click on the link and you will be redirected to your Clearout account.
  3. To generate a new token click on 'Clearout Server App'.
  4. Click on 'Create App' and select 'Server'. Give a suitable name to the token and click on 'Create'
  5. Copy the newly generated API token, paste it in the Clearout window on Google Sheets and click on 'save'

3) How to Verify the email addresses in the Google sheet?

Once the linking procedure is completed, go ahead with the verification.
  • Before starting the verification ensure that the email addresses have a header that says either - email, emails or email addresses.
  • Select how you would like to verify the email addresses in your sheet (Brief of all options given below)
  • Once done the sheet will be updated with results, and the credits charges will be deducted.

A brief of all the options for verification

By removing duplicate

Remove any email address existing more than once in the sheet. No credits charged for duplicates.

By removing empty

Removes empty cells existing in the email address column.

Re-verify if my last verified

Automate the re-verification of the email addresses by selecting a suitable time range.The time range varies from 1 hour to 24 hours.

Append clearout standard columns

Add standard columns to your verified results, along with the ‘status’ of the email addresses.

Don't let each verify to take

Select the maximum time feasible or the verification of each email address in the concerned sheet. You may increase or decrease it based on your level of urgency.

Verify within selected range

This option lets you verify the email addresses within a selected range. For Example: Data between 17 to Row 22 has to be verified. Select this option and then select the respective rows/columns.