## Download impacted assets in Google Sheets

URL: https://docs.atlan.com/product/integrations/collaboration/spreadsheets/how-tos/download-impacted-assets-in-google-sheets

> Once you've [connected Atlan with Google Sheets](/product/integrations/collaboration/spreadsheets/how-tos/integrate-atlan-with-google-sheets), you can download impacted assets in Google Sheets. This can help you assess the downstream impact of any changes made to an upstream asset for [impact analysis](/product/capabilities/lineage/concepts/what-is-lineage#impact-analysis).

Once you've [connected Atlan with Google Sheets](https://docs.atlan.com/llms/governance/integrations/integrate-atlan-with-google-sheets/llms.txt), you can download impacted assets in Google Sheets. This can help you assess the downstream impact of any changes made to an upstream asset for [impact analysis](https://docs.atlan.com/llms/catalog/lineage/what-is-lineage/llms.txt).

:::warning
You need to be logged into your Atlan instance before you can download impacted assets from Atlan in Google Sheets.
:::

## Download impacted assets in Google Sheets

To import lineage in Google Sheets:

1. In the menu bar of your Google spreadsheet, click **Extensions**.
2. From the dropdown menu, click **Atlan**.
3. From the list of options in the Atlan add-on, click **Import Lineage** to open a list of your assets in a sidebar.
4. (Optional) To filter your assets by a specific asset type, in the Atlan sidebar, select the asset type.
5. In the Atlan sidebar on your spreadsheet, select the asset(s) you want to import.
6. To select the type of impacted assets you'd like to download, in the Atlan sidebar, from the _Direction_ dropdown:
 - To download downstream assets for [impact analysis](https://docs.atlan.com/llms/catalog/lineage/what-is-lineage/llms.txt), click **Downstream**.
 - To download upstream assets for [root cause analysis](https://docs.atlan.com/llms/catalog/lineage/what-is-lineage/llms.txt), click **Upstream**.
 - To download all impacted assets, click **Both**.
7. To download the impacted assets in Google Sheets:
 - Click **Import Lineage** to download all the impacted assets in one sheet. 
 - Click the **vertical three dots** and then click **Import to new sheet** to download the assets in separate sheet tabs.
8. (Optional) Once download is successful, click the asset links in your spreadsheet to view the assets in Atlan.

The impacted assets are now available in Google Sheets! 🎉

## Update column metadata for impacted assets

Once you've imported your impacted assets from Atlan, you can edit the column metadata for impacted assets in Google Sheets. You can make changes to the column metadata once all the columns have been imported successfully.

You can only make changes to the metadata in the following columns:

- [_Description_](https://docs.atlan.com/llms/catalog/discovery/add-descriptions/llms.txt)
- [_Owner Users_](https://docs.atlan.com/llms/catalog/discovery/add-owners/llms.txt)
- [_Owner Groups_](https://docs.atlan.com/llms/catalog/discovery/add-owners/llms.txt)
- [_Certification Status_](https://docs.atlan.com/llms/catalog/discovery/add-certificates/llms.txt)
- _Certification Message_
- [_Announcement Type_](https://docs.atlan.com/llms/governance/integrations/create-announcements/llms.txt)
- _Announcement Title_
- _Announcement Message_
- _[Tags](https://docs.atlan.com/llms/governance/tags/attach-a-tag/llms.txt)_

You **cannot** make the following changes:

- Edit headers for any of the columns
- Edit the metadata in the following columns:
 - _Source Asset_
 - _Source Asset Connector_
 - _Source Asset Type_
 - _Impacted Asset_
 - _Impacted Asset Connector_
 - _Impacted Asset Type_
 - _Direction_
 - _Terms_
 - _Propagated Tags_
 - _Source URL_
 - _Qualified Name_
 - _Source Asset GUID_
 - _Impacted Asset GUID_
 - _Immediate Upstream_ and _Immediate Downstream_
- Delete any columns or rows

Any of these changes will not be pushed to Atlan and you'll receive an error message.

:::info **Did you know?** 
 When [adding tags](https://docs.atlan.com/llms/governance/integrations/update-column-metadata-in-google-sheets/llms.txt) or owners for impacted assets in Google Sheets, the tag or user name for the owner user or group must already exist in Atlan; name match is case-sensitive, format the value exactly as it exists in Atlan; and you can add multiple tags or owners as comma-separated values.

:::

## Push changes to Atlan

Once you've made changes to the column metadata, to push your changes:

1. In the menu bar of your Google spreadsheet, click **Extensions**.
2. From the dropdown menu, click **Atlan** and then click **Push to Atlan**.
3. A dialog box will appear once the changes have synced.

:::warning

If you do not have the [permission](https://docs.atlan.com/llms/governance/access-control/delegate-administration/llms.txt) to update asset metadata, your changes will neither be pushed to Atlan nor will a request be created for approval - even if you receive a success message in Google Sheets. Ensure that you have the requisite permissions to update an asset before pushing your changes. Your user permissions are used to determine the bulk updates you can make to ensure that there is no adverse impact on assets beyond your scope of access.

:::

---