# Component trigger in App to send entire Google Sheet via email **URL:** \ **Category:** Ask for Help\ **Created:** [November 26, 2019, 9:15pm UTC](https://community.glideapps.com/t/component-trigger-in-app-to-send-entire-google-sheet-via-email/2431 "2019-11-26T21:15:35Z")\ **Posts on this page:** 1\ **Showing post:** 4
**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:** [November 27, 2019, 12:07am UTC](https://community.glideapps.com/t/component-trigger-in-app-to-send-entire-google-sheet-via-email/2431/4 "2019-11-27T00:07:29Z")
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](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/component-trigger-in-app-to-send-entire-google-sheet-via-email/2431)._