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
🤓 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.
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.
To install the Atlan add-on directly in Google Sheets, follow these steps:
- In the menu bar of your Google spreadsheet, click Extensions.
- In the dropdown menu, click Add-ons.
- Click Get add-ons to view available add-ons in the Google Workspace Marketplace.
- In the search bar of your Google Workspace Marketplace, type
Atlanand press enter. - Click Install to install the Atlan add-on.
- 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:
- In the menu bar of your Google spreadsheet, click Extensions.
- From the dropdown menu, click Atlan and then click Setup Atlan.
- In the dialog box, enter your Atlan instance URL and click Continue.
Congrats on connecting Atlan with Google Sheets! 🎉
🚨 Careful! 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.