Open navigation

How to reauthenticate a data source connection in Looker Studio, Google Sheets, Excel, and Supermetrics Hub

Sometimes your connection to a data source times out, or your connection needs to be renewed for another reason.


Reauthenticating can solve these errors, among others:

  • Error: Invalid credentials

  • Authentication failed


Follow these steps to reauthenticate the data source connection.


Instructions

Google Sheets


  1. Open a Google Sheets file.
  2. Click Extensions → Supermetrics → Launch to open the sidebar.
  3. Go to the Queries tab.
  4. Select a query that uses the data source you want to reauthenticate from the sidebar. Click the 3-dot menu next to its name. Updating one query will refresh all queries using the same token.
  5. Click Manage data source connection.
  6. In the data source list, click the chevron next to the data source's name.
  7. Click + Add connection.
  8. Authenticate the data source again.

If you're using an older version of Supermetrics, skip step 3. Instead, just select the data source from the sidebar and then follow steps 5 through 7.


Troubleshooting

  • If your account still doesn't appear on the account list, reauthenticate again in an incognito window.
  • If you encounter one of the Google errors below, follow these instructions.
    • This action is not supported when you are logged with multiple accounts 
    • This was a reauthorization request for user A but you logged in as user B
  • If you encounter an error that reads  No accounts selected, it means you haven't selected any accounts when authenticating the data source. 
    • To fix this, open the data source settings by selecting the data source in the sidebar in Google Sheets, and select at least one account under Select accounts. Note that this option sometimes uses a different name — if you're using Google Analytics 4, for example, it'll read Select properties.
Looker Studio


  1. Open Looker Studio. Click on the data source you'd like to reauthenticate.
    If you're actively editing a report, click the Edit icon () next to your data source (or click Resource → Managed added data sources and click Edit there).
  2. On the left side, click Edit connection.
  3. Navigate to the link at the end of the sentence that starts with “To add more/manage user accounts…”
  4. Choose the team that the connection you'd like to authenticate belongs to.
  5. Click Add connection.
  6. Authenticate the data source again.
  7. Click Done.

  8. Click Reconnect.

  9. Click Done.


Remove a data source from Looker Studio

  1. Navigate to Resource → Manage added data sources.
  2. Find the data source in the list that you want to remove and click Remove.
  3. Click Remove data source to confirm.


Revoke a data source in Looker Studio

  1. On the top sidebar, click Add data.
  2. Find the data source’s name with "by Supermetrics" beneath it.
  3. Click the three-dot menu on the card to open the options menu.
  4. Click Revoke access.
  5. Click Remove to proceed. 
  6. Click Remove anyway to confirm. 


Troubleshooting

  • If your account still doesn't appear on the account list,  reauthenticate again in an incognito window.
  • If you encounter one of the Google errors below, follow these instructions.
    • This action is not supported when you are logged with multiple accounts 
    • This was a reauthorization request for user A but you logged in as user B
  • If you encounter an error that reads  No accounts selected, it means you haven't selected any accounts when authenticating the data source. 
    • To fix this, open the data source settings by selecting the data source and clicking the edit icon, and select at least one account under Select accounts. Note that this option sometimes uses a different name — if you're using Google Analytics 4, for example, it'll read Select properties.

Excel
  1. Open an Excel file.
  2. Click DataShow Supermetrics. If you're actively editing an existing query, navigate to Query → Stop modifying.
  3. Open the Data source section.
  4. Navigate to the data source. Click the chevron next to the data source's name.
  5. Click Add connection.
  6. Authenticate the data source again.


Troubleshooting

  • If you encounter one of the Google errors below, follow these instructions.
    • This action is not supported when you are logged with multiple accounts 
    • This was a reauthorization request for user A but you logged in as user B
  • If you encounter an error that reads  No accounts selected, it means you haven't selected any accounts when authenticating the data source. 
    • To fix this, open the data source settings by selecting the data source in the sidebar in Excel, and select at least one account under Select accounts. Note that this option sometimes uses a different name — if you're using Google Analytics 4, for example, it'll read Select properties.
Supermetrics Hub
  1. Go to the Data sources page on the Hub.
  2. Click the data source you need to authenticate and find the connection to reauthenticate.
  3. Click the reconnect icon (  ) at the end of the row.
  4. Follow the data source-specific instructions to connect to the data source.

Take a look at our support article for more instructions on how to manage data source connections on the Hub.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.