Google Sheets Add-ons
Verify, Find emails in Google Sheets with Clearout
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 Google sheet better by avoiding multiple uploads and downloads and running between the lists.
How can I obtain the Clearout Add-on?
The procedure is straightforward and will take less than 5 minutes.
Log in to your Gmail account
Open a Google Sheet.
Go to ‘Add-ons’ in the ‘Menu-Bar’
Go to ‘Get Add-ons’ and search for ‘Clearout’
Click on ‘Install’ (If you have an existing account on ‘Clearout’, great otherwise start off with creating an account)- Register
Once installed and allowed access, a pop-up will open on the right of your sheet.
How to integrate Google Sheets with Clearout?
Once the Add-on is installed, link the Clearout account with these steps
Go to 'API Token' at the bottom of the pop-up to link your account.
A new window will open with a link 'API token here'. Click on the link shown, and you will be redirected to your Clearout account.
To generate a new token, click on Developer → API.
Copy the newly generated API token, paste it in the Clearout window on Google Sheets, and click on 'save.'
How do I 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 (a brief of all options given below)
Once done, the sheet will be updated with results, and the credit charges will be deducted.
Available Verification Options
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 Time
Select the maximum time feasible for 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.
Example: The data from row 17 to row 22 has to be verified. Select this option and then select the respective rows/columns.
Last updated
Was this helpful?