# Backups: sending google spreadsheet via email **URL:** \ **Category:** Ask for Help\ **Created:** [April 8, 2022, 9:41am UTC](https://community.glideapps.com/t/backups-sending-google-spreadsheet-via-email/40516 "2022-04-08T09:41:48Z")\ **Posts on this page:** 1\ **Showing post:** 10
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 9, 2022, 1:12pm UTC](https://community.glideapps.com/t/backups-sending-google-spreadsheet-via-email/40516/10 "2022-04-09T13:12:27Z")
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](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/2): > > 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: 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… --- _[View the full topic](https://community.glideapps.com/t/backups-sending-google-spreadsheet-via-email/40516)._