Automatic Backup Spreadsheet with Google Apps Script

Learn how to automate backups for your Google Spreadsheets using Google Apps Script in this step-by-step tutorial. Protect your data by scheduling regular backups, managing the number of backup copies, and specifying a destination folder in Google Drive, all through custom script automation. Whether you're managing personal projects, business data, or collaborative spreadsheets, this tutorial ensures your information remains safe and recoverable.

In this video, we'll cover:

Creating a custom menu in Google Sheets for easy backup management.
Writing a script to automatically copy your spreadsheet to a specified Google Drive folder.

Setting up a system to limit the number of backups and automatically remove the oldest backups, keeping your Drive organized.

Implementing user prompts to customize backup settings directly within your spreadsheet.

By the end of this tutorial, you'll have a fully functional backup system integrated into your Google Spreadsheet, giving you peace of mind and safeguarding against data loss.

Full Code:

Join this channel to get access to perks:

[AlberichRheinmann]

hi grandmaster ARIS ... i am a script junkie ... and i work 99% with appscript, but very beautiful presentation ... thanks a lot for your effort

[shamsulhuda]

Is it possible to schedule the backup process daily, weekly or monthly automatic not by clicking? The script is run automatically.

[stephenoxlade]

A really excellent video and script which works very well - a big thank you for sharing !

[christianrobertadzic]

Thank you for the videos you shared. I really like your content and you web site too.
Everything is very valuable to me and probably others too who are learning this kind of data aggregation.
My best wishes to you and keep going with your channel.

[RanggaDamas]

sir i have problem Error Exception: Cannot call SpreadsheetApp.getUi() from this context.
at onOpen(Code:2:27) when execute trigger, how can solved this problem? thankyou

[agungpriambodo]

Hi Mr Aris…tks for the video..
please make a tutorial for this apps backup script to run via appsheet and script to clear data sheet

[pdeelen]

After many times i stil get ID error, cant set backup to the folder

[guevarrajjd]

encountered this error : Failed to access the destination folder. Please check the folder ID.

[noranoranha]

I need your help, how do I create a validation in the name field to allow only letters?😘

[michaelmeier]

Hi Aris,

I am new to App Scripts and found this very helpful. When setting backups to happen on a 5 minute cadence I received this error "Error
Exception: Cannot call SpreadsheetApp.getUi() from this context.
at onOpen(Code:2:27)"

Would you be able to direct me to the problem? Thank you very much!