When you create a query in Google Sheets, your data source connection and license are used to fetch data — in other words, you become the query owner or query editor. Whenever anyone else refreshes the query, the query editor's login credentials will be used to refresh the query.
If you see the "[User] needs to log into data source as..." error, this means that Supermetrics couldn't find the original connection used in the query. This can happen, for example, because the query editor needs to reauthenticate or the query was edited manually and something went wrong.
To fix this, renew the connection to the data source if you're the owner of the query. If you're not the owner of the query, you can transfer the query ownership to you and refresh the query with your connection.
Instructions
- Click Extensions → Supermetrics → Launch to open the sidebar.
- Go to the Queries tab.
- Select a query that uses the data source you want to reauthenticate from the sidebar. Click the 3-dot menu next to its name.
- Click Manage data source connection.
- In the data source list, click the chevron next to the data source's name.
- Click Add connection or Add new user.
- Authenticate the data source again.
- Refresh the query.
- Open the Supermetrics sidebar.
- Make sure you're logged in to the data source and have the necessary permissions to get the data requested in the query. Learn more about data source permissions.
- Open the SupermetricsQueries tab. (This is hidden by default. Click Extensions → Supermetrics → Manage queries to open it.)
- For each query with the error, delete the "Query ID" (column A) and "Refresh with user account" (column AU) values in that query's row.
- Once all the queries have been prepared, open the sidebar, scroll down to Templates and workflow, and click Refresh all queries.
If you have more than one login to a data source, first create a new query with the connection you'd like to use:
- Create a new query using the needed connection.
- Open the SupermetricsQueries tab (if hidden, click Extensions → Supermetrics → Manage queries).
- Copy the value in the "Refresh with user account" column (column AU) from the newly created query.
- Paste the copied value to all query rows you want to run using the new connection.
- For each query to run with the new connection, delete the "Query ID" (column A) value in that query's row.
- Once all the queries have been prepared, open the sidebar, scroll down to Templates and workflow, and click Refresh all queries.
After you refresh, you'll see a new Query ID value in column A.