WARNING: Don’t restore your google sheets to earlier time

[Jeff_Hager]

I’d suggest not restoring an old version of your sheet it you know that the layout had changed. I’d suggest making regular backups of the entire sheet instead and only restoring data via copy paste. I run a script on a trigger to create a backup weekly off my entire sheet. There’s just too many unknowns using Google’s restore feature.

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…