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

Setting up daily Google folders for Timelapse camera photos?

  • 28 September 2022
  • 13 replies
  • 107 views
S
Userlevel 1

My business has a number of Timelapse cameras set up.

 

These take 1 photo per hour each, which are emailed to an inbox. 

Currently, the email is the trigger for the image attachment to upload to the folder of each respective camera. 

 

In order to make this data easier to view, I would like to set up Zapier to create a new folder at midnight each day, labelled with a ‘pretty date’, and for all photos taken on that day to be uploaded into that folder. I am new to Zapier and am struggling to set this up. 

 

Any help with his problem would be greatly appreciated!

icon

Best answer by MohSwellam 28 September 2022, 07:59

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.

13 replies

MohSwellam
Userlevel 7
Badge +8

Hi @SST 

 

This seems like a pretty easy setup.

 

First of all you need a zap that triggers with Schedule By Zapier where you can set the time to midnight. Then using the results of that trigger you can create an action for Google Drive to Create a Folder using the pretty date (which is a result in the trigger) 


Now in the other zap with the email trigger all you have to do is add a step that Finds the Google Folder with today’s name and setup the upload file action to upload to the found folder :) 

 

Let me know of this helps

 

Founder of GeekyAir.com
S
Userlevel 1

Hi @MohSwellam 

Thanks for the reply!

I suspected this path would be the answer, however I am still not sure how to add the step that finds a folder with today’s date, should it be an option under this menu? 

 

Thanks in advance again! 

 

MohSwellam
Userlevel 7
Badge +8

My pleasure @SST :) 

 

Yes, in this part you should be able to find the date of the email. If the pretty date is not one of the options, then you need to add a Formatter By Zapier step to convert the format of the date from the Gmail step

Founder of GeekyAir.com
S
Userlevel 1

Thanks so much @MohSwellam 

I think I am close but the pretty date has a comma in it (Oct 5, 2022) and you cannot select that in the find a folder, the closest is Oct 5 2022

Is there a troubleshoot for this?  Thanks in advance

MohSwellam
Userlevel 7
Badge +8

Hi @SST , 

 

You can remove the comma using Formatter by Zapier , it should be pretty easy :) Just do it as a Date formatter and make your own format without the comma 

 

let me know when this works :)

Founder of GeekyAir.com
S
Userlevel 1

Thanks @MohSwellam 

When running a test, it is coming up 

Failed to create an upload file in Google Drive

The app returned "File not found: Oct 05 2022".

Formatter by Zapier solves the formatting thank you.  However, changing the file name to the date and trying to match it to the folder doesn’t seem to want to work.  The folder exists.

 

Thanks so much

MohSwellam
Userlevel 7
Badge +8

Hi @SST , 

 

can you please show me a screenshot of this step of the Zap? 
 

Also, can you try removing the mapped value Oct 05 2022 and type it instead? Maybe check the exact name on Google Drive? Is it Oct 05 or Oct 5

Founder of GeekyAir.com
S
Userlevel 1

Thanks @MohSwellam 

This is the workflow of zaps and what looks like the critical piece but I’m not sure… It’s cloase.  The format of the folder is def Oct 05 2022 - that bit is identical.

2 Attachments
MohSwellam
Userlevel 7
Badge +8

I don’t understand what you mean by “cloase” :) 

 

The problem is the Folder field in Step 5, you are mapping the Title while you should be mapping the folder ID from the Find A Folder step results :) 

 

Founder of GeekyAir.com
S
Userlevel 1

Ah it was a typo, I meant it’s close.

It is mapping from the find a folder step but I can’t see how to change it to ‘folder’ rather than ‘title’

 

1 Attachment
MohSwellam
Userlevel 7
Badge +8


this is the value you need, remove the existing value in this field (3. Title: Oct 05 2022) and add this one instead , and congrats, its working 😁

Founder of GeekyAir.com
S
Userlevel 1

Oh wow, that might’ve done it!  Amazing, appreciate your help.

MohSwellam
Userlevel 7
Badge +8

Its my pleasure ;)

 

please mark the reply that helped you as Answer so others can benefit from it :) 

Founder of GeekyAir.com
Terms & Conditions