## Integrate Atlan with Google Sheets

URL: https://docs.atlan.com/product/integrations/collaboration/spreadsheets/how-tos/integrate-atlan-with-google-sheets

> The Atlan add-on for Google Sheets makes it easy to edit column metadata in bulk for your data assets in Atlan.

The Atlan add-on for Google Sheets makes it easy to edit column metadata in bulk for your data assets in Atlan. 

Integrating Atlan with Google Sheets allows you to:

- Import column metadata for your data assets into Google Sheets
- Update column metadata for your imported assets directly in Google Sheets
- View data asset profiles on Google Sheets
- Download downstream impacted assets in Google Sheets

:::warning Who can do this?
 Any individual in your organization with access to Atlan can install the Atlan add-on for Google Sheets. You can even install the Atlan add-on if you have a Google account with a non-gmail address. However, the Atlan add-on can also be installed at the workspace level. To install the app for users in your organization, follow this [guide](https://support.google.com/a/answer/172482?hl=en).

:::

You'll also need the following permissions for Google Sheets within your organization:

- Display and run third-party web content in prompts and sidebars within Google apps
- View and manage the spreadsheets with the Atlan add-on

## Install Atlan in Google Sheets

To install the Atlan add-on from the Google Workspace Marketplace, use [this link](https://workspace.google.com/marketplace/app/atlan/1024304204657).

To install the Atlan add-on directly in Google Sheets, follow these steps:

1. In the menu bar of your Google spreadsheet, click **Extensions**.
2. In the dropdown menu, click **Add-ons**.
3. Click **Get add-ons** to view available add-ons in the Google Workspace Marketplace.
4. In the search bar of your Google Workspace Marketplace, type `Atlan` and press enter.
5. Click **Install** to install the Atlan add-on.
6. If you see a dialog box pop up asking for permissions, click **Allow** to continue.

## Connect Atlan with Google Sheets

To connect Atlan with your Google spreadsheets:

1. In the menu bar of your Google spreadsheet, click **Extensions**.
2. From the dropdown menu, click **Atlan** and then click **Setup Atlan**.
3. In the dialog box, enter your Atlan instance URL and click **Continue**.

Congrats on connecting Atlan with Google Sheets! 🎉

:::warning

For every new spreadsheet that you create using Google Sheets, you will need to follow the steps outlined above to connect Atlan with that spreadsheet. The Atlan add-on will remain connected for all tabs within an already connected spreadsheet.

:::

---