# Google Sheets Add-ons

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.

{% embed url="<https://www.youtube.com/watch?v=zJ37fOLobwI>" %}

{% stepper %}
{% step %}

### How can I obtain the Clearout Add-on? <a href="#j8y02" id="j8y02"></a>

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](https://app.clearout.io/register?utm_referrer=https%3A%2F%2Fwww.google.com%2F)
* Once installed and allowed access, a pop-up will open on the right of your sheet.

<div data-with-frame="true"><figure><img src="https://93738666-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEXQQW0hsXyH0YD4ePoxb%2Fuploads%2FNu1WlB2xiZu4lSRejVp1%2Fclearout-how-to-get-clearout-addon-1.webp?alt=media&#x26;token=b3a71fd5-131e-40f6-bf9c-f44d8f6a7aba" alt="Add Clearout Add-on on Google Sheets"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}

### How to integrate Google Sheets with Clearout? <a href="#gvrcw" id="gvrcw"></a>

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.](https://app.clearout.io/developer/api/list)
* Copy the newly generated API token, paste it in the Clearout window on Google Sheets, and click on 'save.'

<div data-with-frame="true"><figure><img src="https://93738666-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEXQQW0hsXyH0YD4ePoxb%2Fuploads%2FzGufOojlidu1HlbQHEwM%2Fhow-to-integrate-gs-with-clearout-1.webp?alt=media&#x26;token=43878416-1a7f-4269-b61f-a2a9ad6221f6" alt="Adding API Token to integrate Google Sheets add-on for validation"><figcaption></figcaption></figure></div>
{% endstep %}

{% step %}

### How do I verify the email addresses in the Google Sheet? <a href="#iiefv" id="iiefv"></a>

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.

<div data-with-frame="true"><figure><img src="https://93738666-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEXQQW0hsXyH0YD4ePoxb%2Fuploads%2FnaYczhrjwsoJLvB3F1RP%2Fhow-to-verify-the-email-address-in-the-gs-1.webp?alt=media&#x26;token=6bf8efc3-dd9e-4f72-a84b-b6d228d1191e" alt="Verify Email Addresses on Google Sheets"><figcaption></figcaption></figure></div>
{% endstep %}
{% endstepper %}

## Available Verification Options <a href="#id-3tutv" id="id-3tutv"></a>

<table><thead><tr><th width="308.408203125">Options</th><th>Descriptions</th></tr></thead><tbody><tr><td><p>By Removing Duplicate</p><p></p></td><td>Remove any email address existing more than once in the sheet. No credits charged for duplicates.</td></tr><tr><td><p>By Removing Empty</p><p></p></td><td>Removes empty cells existing in the email address column.</td></tr><tr><td><p>Re-Verify if My Last Verified</p><p></p></td><td>Automate the re-verification of the email addresses by selecting a suitable time range. The time range varies from 1 hour to 24 hours.</td></tr><tr><td>Append Clearout Standard Columns</td><td>Add standard columns to your verified results, along with the ‘status’ of the email addresses.</td></tr><tr><td>Don't Let Each Verify To Take Time</td><td>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.</td></tr><tr><td><p>Verify Within Selected Range</p><p></p></td><td><p>This option lets you verify the email addresses within a selected range. </p><p>Example: The data from row 17 to row 22 has to be verified. Select this option and then select the respective rows/columns.</p></td></tr></tbody></table>