Component trigger in App to send entire Google Sheet via email

[Jeff_Hager]

If you are looking for more of a backup option, here is a script I use to create weekly backups. The script could be modified to also clear or reset a sheet nightly.

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…