Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I have a zap that sends information to ChatGPT. I want to bring this information over to Google Drive inside of a Google Doc.

First, I want Zapier to look for a file in Google Drive based on a date (20240415 - YYYY/MM/DD). If the file does not exist, I want it to create that file with that file name. If the file does exist, it would append the information from ChatGPT into that Google Doc.

That’s not difficult.

The part that is tricky is that I want the date to be variable. If the Zap is running today (20240415), it should be looking for tomorrow’s date (20240416). Then if the zap runs tomorrow, it should be looking the following day’s date (20240417).

It’s essentially compiling news stories and information for me a day in advanced, but I don’t know how to get that date to be variable. This is all I have so far because I’m stuck on the “Required file name” in Google Drive.

 

Hi @ninefivefree 

Add this Zap action: Formatter > Date & Time > Format

https://help.zapier.com/hc/en-us/articles/8496275717261#iso-8601-timestamps-0-1

Hi @ninefivefree 

Add this Zap action: Formatter > Date & Time > Format

https://help.zapier.com/hc/en-us/articles/8496275717261#iso-8601-timestamps-0-1

I had seen this, but didn’t fully understand how it worked. To clarify for anyone else who finds this post:

{{zap_meta_human_now}} creates a field that can be placed as an input into other areas of your Zap:

 

This will output the date & time the zap ran. In my case, I’d always be running the zap a day in advanced, so I had to add an “expression” of +1 day and select that the format that I wanted for my filename to be “Tomorrow’s date”.

 

Thanks Troy! I appreciate the resources and help.

That’s awesome @ninefivefree! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Terms & Conditions