# Migrate to the Google Sheets Add-on

## What changes with the Add-on?

Since January 2023, the Adobe Analytics Component Manager for Google Sheets is available as an [official Google Sheets Add-on in the Google Workspace Marketplace](https://workspace.google.com/marketplace/app/aa_component_manager/561445625333). 

This has a lot of benefits:

* The installation is a lot **easier and faster** and there are no more scary "unsafe" messages etc.
* You **automatically benefit from updates** - no need anymore to manually update the Component Manager to a new version
* The **app is faster** as we don't need to do things like version checks with data from a separate spreadsheet every time a function runs
* **Security:** your Google Workspace Admins can whitelist this particular app instead of having to give you unrestricted access to any unapproved Apps Script apps

## Do I need to migrate?

The old version will keep working until **Februar 28 2023**. We will not fix bugs or issues there. Migration is easy. Simply follow the steps below:

## How to migrate

Migration requires 2 steps:

### 1. Install the [official Google Sheets Add-on in the Google Workspace Marketplace](https://workspace.google.com/marketplace/app/aa_component_manager/561445625333). 

### 2. Remove the Apps Script code and Library connection in each of your Component Manager sheets:

I. Go to Extensions -> Apps Script.

<figure><img src="https://1078995354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MboPawbBXUHMz6mjuP9%2Fuploads%2FOM5ZtUg4iE9do60idvy6%2Fimage.png?alt=media&#x26;token=c38f0438-0a48-411a-918b-c982c69d1888" alt=""><figcaption></figcaption></figure>

II. Delete all code in the Code.gs panel and click the "Save" icon. If you cannot edit or save, make sure you are viewing the page with a Google account that has Editor rights.

<figure><img src="https://1078995354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MboPawbBXUHMz6mjuP9%2Fuploads%2FLApDdUnwphFvMfHkd9FW%2Fimage.png?alt=media&#x26;token=a3dfa4fe-aff5-49ea-8797-8b8c9f19b8b0" alt=""><figcaption></figcaption></figure>

III. Under "**Libraries**", click on the three dots next to "**libComponentEditor**", and then "**Remove**".

![](https://1078995354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MboPawbBXUHMz6mjuP9%2Fuploads%2FCReidpFNjEvApH2CBqyE%2Fimage.png?alt=media\&token=1816e21a-a179-4266-8baf-e1914255db2a)

IV. Reload your Google Sheet. Done.

You will now no longer see the "AA Component Manager" menu on top. Instead, all the Component Manager functions are now under **Extensions -> AA Component Manager:**&#x20;

<figure><img src="https://1078995354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MboPawbBXUHMz6mjuP9%2Fuploads%2FZ2gQoprVbTxlxhCHsHPX%2Fimage.png?alt=media&#x26;token=30a43fb1-8ab0-4d2b-ab3d-993f132f7ac8" alt=""><figcaption></figcaption></figure>