Back up google sheet - how often

[Jeff_Hager]

I have a script that runs once a week to make a backup copy of my sheet.

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…