Best answer

Automate a daily backup of a Google Sheet

  • 20 August 2021
  • 6 replies
  • 3031 views

Userlevel 1

I would like to create an automated backup. At 4:00 am EST every day, I want to create a copy of an existing Google Sheet in my Google Drive, rename the file, and than move it to a specific folder in my Google Drive. I’ve searched the forum and help articles and haven’t found anything that will allow me to set a trigger without something happening in the Google Sheet first.

icon

Best answer by Troy Tessalone 20 August 2021, 22:51

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Userlevel 7
Badge +14

Hi @wczapper 

Try using the Schedule app as the trigger: https://zapier.com/apps/schedule/integrations

Userlevel 1

Hi, @Troy Tessalone . I appreciate your suggestion...sounds like that will do the trick for this specific zap and helpful for others as well. Thanks for taking time to share your expertise. :thumbsup:

Hey @wczapper! I’m looking for this exact solution - would you care to share yours with me? I tried using Trigger > Upload but am getting stuck. Thanks!

Userlevel 3
Badge +1

Hi @hddan 

 

Try something like this:

https://zapier.com/shared/05835c4c675d63b33c859b266de924b47a76de43

Userlevel 1

Hi, @hddan . I actually ended up using a Google App script instead so there was one less layer of integration. You can set up a script inside of the Google Sheet itself, the process is super simple, and you can check out the steps here:  https://gist.github.com/abhijeetchopra/99a11fb6016a70287112.

I was able to set this up and test the script in about 10 minutes. I hope this helps!

@wczapper - mighty helpful, thanks!