#GOOGLE HOURS SPREADSHEET SOFTWARE#
#GOOGLE HOURS SPREADSHEET CODE#

#GOOGLE HOURS SPREADSHEET SOFTWARE#

Var file = DriveApp.getFileById(SlidesApp.getActivePresentation().I used to use this approach to keep a tab on stocks that I own but I have since moved to using other software since Google Finance data can sometimes be inaccurate or stale.

Var name = SlidesApp.getActivePresentation().getName() + ' Copy ' + formattedDate Var file = DriveApp.getFileById(DocumentApp.getActiveDocument().getId()) Var destination = DriveApp.getFolderById('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') Var name = DocumentApp.getActiveDocument().getName() + ' Copy ' + formattedDate Var formattedDate = Utilities.formatDate(new Date(), 'GMT', 'yyyy-MM-dd' 'HH:mm:ss') pyTo(range, ) Р”Р„wesome post and very helpful! Made some adjustments if someone wants to backup a google doc or google slides. Var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Stats')

#GOOGLE HOURS SPREADSHEET CODE#

The original code overwrites all formulas with the cells' calculated values. Is there a way to 'freeze' the data written to the backup file? I modified the script below and added it to the end of the backup script but just get a second copy of the backup. Unfortunately, my backups open and reload current data for the cells with importhtml. I don't know if there's a way to back up the sheet without backing up its attached scripts too.Р”В¬an you (or someone else) help me with the authorization issue, at least? I assume there's nothing that can be done about that, but I thought I'd call that out.

When I delete and re-add the trigger, it requests to be authorized again.Р”Р„dditionally, the script makes a backup of the script itself as attached to the spreadsheet. In the meantime, I created a button to call the script that I can manually click in the spreadsheet, but I'd like to do nightly backups when no one is using it. I think the issue is that the authorization is somehow falling off. Var name = SpreadsheetApp.getActiveSpreadsheet().getName() + '_Backup_' + formattedDate + ' PST' TypeError: Cannot call method 'getName' of null. I set this up and the script works if I run it manually - authorizes and everything, but the scheduled trigger always fails with the error: makes copy of 'file' with 'name' at the 'destination' getFolderById ( 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' ) REPLACE xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx with your folder's ID that you can get by opening the folder in Google Drive and checking the URL in the browser's address bar gets the destination folder by their ID. gets the name of the original file and appends the word 'copy' followed by the timestamp stored in formattedDate formatDate ( new Date ( ), 'GMT', 'yyyy-MM-dd' 'HH:mm:ss' ) generates the timestamp and stores in variable formattedDate as year-month-date hour-minute-second Google Apps Script to make copies of Google Sheet in specified destination folder Select the time interval as per your desire.Р”В¬lick on 'Continue' to authorize running the script you just made.Р”В¬lick on 'Allow' to let the script run on your Google Sheet.Р”Р„fter the set interval(which was every minute in my case), you can see the automatic scheduled backup copies of your Google Sheet saved in the folder you created. Once the script editor opens, copy and paste the code from the 2-MakeCopy.gs file (see file below) into the 'Code.gs' file, replacing the code that's already included.Р”В¬opy the ID of the folder you created earlier and paste in place of the xxxxxxxxxxxxxxxxxxxxxxx in the code.Р”В¬lick on the clocked shaped 'Trigger' button. Open your Google Sheet and select menu item 'Tools' -> 'Script Editor' You will be able to see its ID in the URL displayed in your browser's address bar. Open your Google Drive and create a new folder right where your Google Sheet is.

Google hours spreadsheet