Articles on: Google Sheets

Why should I not modify the "DataslayerQueries" sheet and what is it for?

When using Dataslayer in Google Sheets, the hidden sheet "DataslayerQueries" is the place where all the query information and data needed for Dataslayer to work is stored.

Therefore, it is very important that the user NEVER modifies or deletes anything from this sheet (including deleting the first header row), as this could cause failures in Dataslayer and other related problems.

In case you have made any modification to the "DataslayerQueries" sheet and Dataslayer or any of its queries are not working properly, please follow the following steps:

Change the name of the "DataslayerQueries" sheet to a different one.

Reload the document and open the Dataslayer Add-on (the sidebar). This will generate a new DataslayerQueries sheet.

Copy the query information from the old sheet to the new one.

This process will work in the majority of cases. It is the user's responsibility not to modify the DataslayerQueries sheet under any circumstances unless directed to do so.

Therefore, it is very important that the user NEVER modify or delete anything on this sheet (e.g., deleting the first header row of the sheet or deleting the queries stored on it), as this may cause Dataslayer errors and other related problems, such as queries NOT being updated.

Updated on: 18/08/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!