# 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="/files/hwRU1D3CaL8EhJi0vWtX" 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="/files/5sEChmkBT3fnsHQmkbx8" alt=""><figcaption></figcaption></figure>

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

![](/files/fMJWaTmfcCHv4Tt9nfhm)

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:**

<figure><img src="/files/iS0uXJSHxvGRmKz4Q3Ty" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.datacroft.de/getting-started-with-the-component-manager/migrate-to-the-google-sheets-add-on.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.