Articles on: Google Sheets
This article is also available in:

Can I modify queries created by other user?

Due to how the code works internally, you can only modify queries if you have access to the same credentials with which they were created, but there is a method to trick the code and be able to modify queries even if you do not have the credentials.

To do this you must follow these steps:

Go to the hidden sheet "DataslayerQueries" by clicking on the "all sheets" button.

In the "AL" column, change the email that appears in "refresh with user account" by the email of the account that wants to modify the query. That's it!

If you have a shared Google Sheet document, when you make a query with any data source, the other users can refresh or modify it as those users have an active session in the same data source.

Updated on: 24/10/2022

Was this article helpful?

Share your feedback


Thank you!