# Error: Authorization Is Required to Perform That Action

> **Note:** This article provides troubleshooting steps for the "Authorization is required to perform that action" error. This error can occur when using Power My Analytics with Google services, including the Google Sheets add-on, Data Studio connectors, or other Google-authenticated integrations.

This article will help to resolve the following error:

Google Error: **Authorization is required to perform that action.**

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-authorization-is-required-to-perform-that-action-1.png)

This error appears on a Google authorization flow page when attempting to authenticate or use the Power My Analytics Google Sheets add-on.

## Causes

This error can occur for several reasons:

- **Multiple Google Accounts:** You are logged into multiple Google accounts, and at least one of them does not have access to the report or spreadsheet you are attempting to view.
- **Permission Scope Conflicts (Google Sheets Add-on):** If you previously connected a Google-based data source (such as Google Ads, Google Analytics 4, or Google Search Console) through your PMA hub before installing the Google Sheets add-on, the required permissions for Google Sheets may not have been properly requested during authentication. This can cause the authentication process to fail.
- **Browser or Network Blocking:** Ad blockers, browser extensions, or network security settings may be blocking the authentication requests from reaching Power My Analytics servers.
- **Stale Authentication Token:** Your existing Power My Analytics authorization may have become corrupted or expired.
- **Google Workspace Admin Settings:** If you sign in with a Google Workspace account, your organization may require your administrator to approve third-party apps before anyone can use them. Until your administrator allows the Power My Analytics add-on, signing in to the add-on can fail.

## Solutions

### Log Out of Other Google Accounts

If you are logged into multiple Google accounts, this can cause authorization conflicts.

1. Log out of all Google accounts.
2. Log back into only the Google account that has access to your Power My Analytics hub and the spreadsheet you wish to use.

    ![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-authorization-is-required-to-perform-that-action-2.png)
3. Retry the action that triggered the error.

### Sign Out and Sign Back Into the PMA Add-on

If you are experiencing this error specifically in Google Sheets, try signing out of the Power My Analytics add-on and signing back in:

1. Open your Google Sheets spreadsheet.
2. Navigate to **Extensions > Power My Analytics > Sign out**.
3. Navigate to **Extensions > Power My Analytics > Open sidebar**, then click **Sign in** in the sidebar.
4. Finish signing in on the new tab that opens, and complete any Google permission prompts.
5. Return to your spreadsheet. The sidebar updates on its own once you're signed in.

### Remove Power My Analytics from Google Account Connections and Reauthorize

> **Note:** This solution may be needed if you had connected other Google-based data sources to your PMA hub before installing the Google Sheets add-on. Removing and re-adding the Power My Analytics connection forces Google to request all required permissions, including those needed for the Sheets add-on.

Follow these steps to remove Power My Analytics from your Google account and reauthorize:

1. Go to your Google Account's third-party connections page at [https://myaccount.google.com/connections](https://myaccount.google.com/connections) or navigate to **Google Account > Security > Your connections to third-party apps & services**.
2. In the **Third-party apps & services** list, locate **Power My Analytics**. Click on **Power My Analytics** to view its connection details.
3. Scroll down and click on **Delete all connections you have with Power My Analytics**. Confirm the removal when prompted.
4. Next, reauthorize the Google Sheets add-on. Navigate to **Extensions > Power My Analytics > Open sidebar**, then click **Sign in** in the sidebar.
5. A Google permission dialog will appear requesting access for Power My Analytics. Review the permissions requested, which should include:

    - See, edit, create, and delete all your Google Sheets spreadsheets
    - Connect to an external service
    - Send email as you
    - Allow this application to run when you are not present
    - Display and run third-party web content in prompts and sidebars inside Google applications
6. Click **Continue** to grant the necessary permissions.
7. Return to your spreadsheet. If the sidebar doesn't update on its own, reload the page.

### Try Incognito Mode or Disable Browser Extensions

If the authentication requests are being blocked by your browser or network, try the following:

1. **Use Incognito/Private Mode:** Open a new incognito or private browsing window and attempt to authenticate again. This bypasses most browser extensions.
2. **Disable Ad Blockers:** Temporarily disable any ad blockers or privacy extensions that may be blocking requests to Power My Analytics servers.
3. **Try a Different Browser:** Test the authentication in a different web browser to rule out browser-specific issues.
4. **Check Network Settings:** If you are on a corporate or restricted network, check with your IT department to ensure that requests to `powermyanalytics.com` and `hub.powermyanalytics.com` are not being blocked.

### Ask Your Google Workspace Administrator to Allow Power My Analytics

If you use a Google Workspace account and your organization limits which third-party apps people can use, your Google Workspace administrator needs to allow the Power My Analytics add-on. Before you ask, try the steps above while signed in to only the Google account that uses the spreadsheet: most of the time, this error means Google ran the sign-in under a different account.

Share these steps with your administrator:

1. **Allow the add-on in the Google Workspace Marketplace.** In the [Google Admin console](https://admin.google.com/), go to **Apps > Google Workspace Marketplace apps > Apps list**, click **Allowlist app**, search for **Power My Analytics** (Marketplace app ID `606653648723`), and follow the prompts. Google's [allowlist instructions](https://support.google.com/a/answer/6089179) have the details. The add-on's own OAuth client ID changes with each add-on release, so allowing the Marketplace app is the setting that keeps working.
2. **Trust the client ID for Google data sources.** If your team also connects Google data sources (such as Google Ads or Google Analytics 4) in your Hub, your administrator also sets Power My Analytics to **Trusted** under **Security > Access and data control > API controls**, using the client ID `606653648723-k566fvtsbo079dgdtctekhuih0eiccnn.apps.googleusercontent.com`. See [Error 400: admin_policy_enforced](https://knowledge.powermyanalytics.com/application/troubleshooting/error-400-admin-policy-enforced/) for the steps.

> **Note:** Signing in to your Hub with Google uses a separate app, **Power My Analytics Sign In**. It only reads your basic Google profile (your name and email address), so your administrator doesn't need to approve it.

Once your administrator has made these changes, sign out of the add-on (**Extensions > Power My Analytics > Sign out**), then open the sidebar (**Extensions > Power My Analytics > Open sidebar**) and click **Sign in**.

## Still Having Issues?

If you have tried all of the solutions above and continue to experience the "Authorization is required to perform that action" error, please [submit a support ticket](https://knowledge.powermyanalytics.com/support/submit-a-ticket/) with the following information:

- The email address associated with your Power My Analytics hub
- The email address of the Google account you are using with Google Sheets
- Whether that Google account is a Google Workspace account, and whether your administrator has allowed Power My Analytics
- Screenshots of any error messages you are seeing
- A description of the steps you have already tried

## Related Articles

- [Installing the Power My Analytics Add-on for Google Sheets](https://knowledge.powermyanalytics.com/application/reports/installing-the-power-my-analytics-add-on-for-google-sheets/)
- [Google Sheets Data Integration Guide](https://knowledge.powermyanalytics.com/application/reports/google-sheets-data-integration-guide/)
- [Google Sheets Error: "Exception: You do not have permission to access the requested document."](https://knowledge.powermyanalytics.com/application/troubleshooting/google-sheets-error-exception-you-do-not-have-permission-to-access-the-requested-document-2-5-2024/)
