## What is the Google Sheets add-on?

The Dropcontact add-on lets you enrich the contacts of a Google Sheets file without writing any code. It reads the rows of your sheet, sends them to Dropcontact, and writes the results back into your file.

It finds or verifies:

- Professional email addresses
- Phone numbers
- LinkedIn profiles
- Company details (website, SIREN/SIRET, address, headcount…)

The add-on detects your columns automatically (first name, last name, company, email, LinkedIn…). You choose where the results go: in the existing columns, in new columns, or in a new sheet. It can enrich up to 10,000 rows at a time, and uses the credits of your Dropcontact account, as described in the [Credits Policy](https://developer.dropcontact.com/en/credits/).

## Install the add-on

1. Open the [Dropcontact page on the Google Workspace Marketplace](https://workspace.google.com/marketplace/app/dropcontact/557472153363) and click **Install**.
2. In a Google Sheets file, go to **Extensions > Dropcontact > Open Sidebar**.

## Connect to your Dropcontact account

You need a Dropcontact account. If you don't have one yet, [create one for free](https://app.dropcontact.com/signup).

In the sidebar, open **Authentication** and choose one of the two methods.

### With your Google account (recommended)

Use this method if you sign in to Dropcontact with the same Google account as the one you use in Google Sheets.

1. Select the **Google Account** tab.
2. Click **Check my account**.
3. The add-on finds your Dropcontact account and shows **Account found!**

If you see `No Dropcontact account linked to this Google account.`, your Google account is not linked to a Dropcontact account. Create an account with this Google account, or use the API key method below.

### With your API key

Use this method if your Dropcontact account uses another email address.

1. Copy your API key from the [Dropcontact app](https://app.dropcontact.com/api).
2. In the sidebar, select the **API Token** tab.
3. Paste your API key and click **Save & test token**.
4. The add-on shows **Token saved and validated**.

Once connected, click **Start enriching data**.