Archive Data Add-On for Google Sheets

Comments:6

  1. Hi, I am using your great Google Sheets add-on! One question, is there a way I can check exactly what time the archive runs? The scheduling options only give a 1-hour range.

    1. I suggest adding the following formula to an empty cell in your source range: =now()
      That formula will produce a full timestamp like ‘7/9/2018 15:30:59’. When the archive process runs, it will paste-as-values all the data in your range, including the timestamp that was current at that moment.

  2. ScriptError: Authorization is required to perform that action.
    Hi, I received this when I try to archieve, what may be the possible cause?

    1. Can you please try logging out of all Google accounts in your browser and then logging back into just the one using the add-on, or using an incognito/private window? Google sometimes gets confused about permissions when you’re logged into multiple accounts. Let me know if that helps.

      1. thank you, it works.
        I also want to know: I have multiple sheets, where each sheet may contain different data, but I only want to archive active sheet only, is this possible?

      2. I’m not sure I totally understand your question, but currently there’s no way to set only some archives to run and not others.
        If you need to run archives based on some condition, would it be possible for you to make a new sheet with formulas that pull in your ‘active’ data? Then you could set up on archive for just that sheet.

Leave a Reply

Your email address will not be published.