Open navigation

How to reauthenticate or remove a Looker Studio, Google Sheets, or Excel data source

Reauthenticating can solve these errors, among others:

  • Error: Invalid credentials

  • Authentication failed


Instructions

Google Sheets Looker Studio Excel


  1. Open a Google Sheets file.
  2. Click Extensions → Supermetrics → Launch to open the sidebar.
  3. Select a query that uses the data source you want to reauthenticate from the sidebar. Click the 3-dot menu next to its name.
  4. Click Manage data source connection.
  5. In the data source list, click the chevron next to the data source's name.
  6. Click + Add connection.
  7. 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 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, for example, it'll read Select views.

Did you find it helpful? Yes No

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