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?
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?
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