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?

  • 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

Login to post a comment