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

Can I modify queries created by other user?


Do you have a query created by another user and you want to modify it or maybe you are getting the "Please try again to login into your data source" and you don't understand why?



In theory, you can't modify a query from another user but we will explain to you how to do it. The only thing you need is to have access to the same data source accounts as the person who created the original query.

You have to be logged in to the datasource with the new credentials you want to use.

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



In the "AL" column, change the email that appears in "Refresh with user account" to the email of the account that wants to modify the query (the one you are logging into the data source with). 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.


Can I change the creator of the query?



You can also change the created by user column in case you want to change the creator of the query.

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

You also have to take into account that you would have to change the "AL" column too.




Please besides these changes, DO NOT touch the DataslayerQueries sheet because you can break the queries you have. Learn more about this here.



As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!

Updated on: 14/09/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!