# Installing the Power My Analytics Add-on for Google Sheets

---

***If you'd like to merge and manipulate data from popular sales*** ***and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the [Power My Analytics Sheets Data Connector](https://workspace.google.com/marketplace/app/power_my_analytics/606653648723).***

---

<iframe src="https://www.youtube.com/embed/bdwY8yCSE7c" width="560" height="315" title="Video" allowfullscreen></iframe>

## Step 1 - Install Google Sheets Add-on

1. Open a new [Google Sheet](https://docs.google.com/spreadsheets/), then navigate to **Extensions** **\>** **Add-ons** and click **Get add-ons**.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-on-for-google-sheets-1.png)
2. Search for "Power My Analytics," then click the **Install** button.

> > **Note:** If you get an error that says, "App is not allowed for install by admin," you'll need to follow these instructions to [Add Google Workspace Marketplace apps to your allowlist](https://support.google.com/a/answer/6089179).
>
> ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-on-for-google-sheets-2.png)

## Step 2 - Log In to Power My Analytics

> **Note:** If you have more than one Google Account, make sure you are logged into just the email associated with your Power My Analytics hub.

1. Navigate to **Extensions > Power My Analytics** and click **Log In**.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-on-for-google-sheets-3.png)
2. Click **Continue** to grant permissions to Power My Analytics.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-on-for-google-sheets-4.png)
3. Once logged into Power My Analytics, refresh the Google Sheet by hitting F5 or clicking the reload/refresh button on your browser.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-on-for-google-sheets-5.png)

## Step 3 - Show Sidebar

1. Navigate to **Extensions > Power My Analytics** and click **Show Sidebar**.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-on-for-google-sheets-6.png)

    The sidebar will appear.

    ![](https://knowledge.powermyanalytics.com/application/reports/images/installing-the-power-my-analytics-add-on-for-google-sheets-7.png)
