Backups: sending google spreadsheet via email

[Jeff_Hager]

I use a script triggered to run once a week. It create a timestamped duplicate of the sheet in my google drive. I have almost 3 years of weekly backups and they take up very little space in my google drive.

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…