how can I create a new sheet every week, with the data of the last 7 days?
I want to create the queries and refresh the data every week, but I need to display each week in its own sheet (without overwriting the old data).
Is it possible?
Supermetrics Support Forum
Using just queries it is not possible. It might be possible to build a query with "Combine new results with old" and setting a weekly trigger. When new line is added for new week, a script would copy new data and paste it in to a new sheet.
Unfortunately we don't have an example of the script as that would happen on Google systems and not Supermetrics.
Best regards,
-Supermetrics Team