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.

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. Before you click on 'verify' go to 'API Token' present at the bottom of the pop-up to link your account.
  2. API token is present in your Clearout profile.
  3. To get the token click on 'verify'. A new window will open with a link 'API Token here' which will take you directly to your profile.
  4. Copy the API and the respective Clearout account.
  5. Once linked, the name of the account holder will be visible on the pop-up.

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 dupicate

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.