Hi team,
We’re trying to have Zapier create a new calendar event, but we’re having trouble establishing the event at the right time. At the moment, it’s simply creating the event when the trigger runs. However, we want it to be established ‘tomorrow at 9am’ and an end time of ‘tomorrow at 10am’. How do we get the event created to suit this?
Creating a new calendar event at the right time based on when trigger runs
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24595 replies
-
11 October 2023
Hi
Good question.
What calendar app are you using?
We would need to see screenshots with how your Zap steps are configured to have more context.
You may need to use a Formatter step to get the Date/Time value into the required format.
This may help:
Thanks Troy. We’re using Google Calendar. That article helps to an extent… what we’re trying to achieve is to create the event tomorrow at 9am for one hour. Something like: today +1d @ 9am (I know that’s not the right input though...)
Userlevel 7
+14
- Certified Zapier Expert
- 24595 replies
-
11 October 2023
Have you clicked the [more] link to see the full field description?
Have you reviewed the help doc in the field description?
Userlevel 7
+14
- Certified Zapier Expert
- 24595 replies
-
11 October 2023
Did you review the available help articles for using GCal in Zaps?
Userlevel 7
+14
- Certified Zapier Expert
- 24595 replies
-
11 October 2023
In one of the help article it indicates: https://help.zapier.com/hc/en-us/articles/8495964746381-Common-Problems-with-Google-Calendar#h_01H91DNF8Y7XS828N2FNBB0XFQ
Is the event created on the wrong date, specifically with the month and day switched?
Regardless of the settings in your Google Calendar, data sent through their API (as Zapier does) must be in MM/DD/YYYY format.
So, if you try to send an event for April 7, 2021 as 07/04/2021, Google Calendar will interpret that as July 4, 2021.
The dates need to be in MM/DD/YYYY format to ensure Google Calendar adds the event to the correct date(s). If your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.
We have searched the help articles, we have asked the chat bot, we have searched google.
Userlevel 7
+14
- Certified Zapier Expert
- 24595 replies
-
11 October 2023
Did you try testing with this format? (It worked for me)
Otherwise, you can use a Formatter step
Supported date/time formats
Zapier tries to interpret any date or time you provide. For example, all of the following date formats are supported:
- tomorrow at noon
- next Friday at 7PM (Friday of the next week, not the current week)
- 2/13/2020 8PM EST
- 2020-10-26T16:56 (standard ISO format)
- 1393462573 (a UNIX timestamp)
NoteBy default, Zapier uses the ISO 8601 standard for formatting dates. Some apps may use different date and time defaults. If needed, you can adjust date/time values in Zaps by adding or subtracting time from the value within the field.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.