Spreadsheet data

[Rosewebstudio]

Not spreadsheet magic, but, what happens if your spreadsheet is corrupt, is deleted in error? No app! Is this a concern for you?

How do you handle backups?

[Jeff_Hager]

I run a backup script set to a trigger that runs it weekly.

Backup My Data In My Spreadsheet

First of all, google does keep a history of any changes. You can access them by clicking the link at the top of the sheet: [Capture] I also use this script to backup my sheet every week. The only thing that needs to change in the script is the destination folder. This gives me a weekly backup with a timestamp attached to the name: // Abhijeet Chopra // 26 February 2016 // Google Apps Script to make copies of Google Sheet in specified destination folder function makeCopy() { // generates …

[Rosewebstudio]

Thanks