About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Automate a daily backup of a Google Sheet

  • 20 August 2021
  • 6 replies
  • 2893 views
wczapper
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

Troy Tessalone
Userlevel 7
Badge +14

Hi @wczapper 

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
wczapper
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:

H

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!

AppGuyAaron
Userlevel 3
Badge +1

Hi @hddan 

 

Try something like this:

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

Aaron Watkins - Can It Be Automated? I'm pretty sure it can!
wczapper
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!

H

@wczapper - mighty helpful, thanks!

Terms & Conditions