Question

Creating a new calendar event at the right time based on when trigger runs

  • 11 October 2023
  • 9 replies
  • 114 views

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?


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

9 replies

Userlevel 7
Badge +14

Hi @JamieH 

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
Badge +14

@JamieH 

Have you clicked the [more] link to see the full field description?

Have you reviewed the help doc in the field description?

 

@Troy Tessalone Yes we have. More tells us nothing, and the help document doesn’t provide any instruction around how to achieve what we’re trying to do

Userlevel 7
Badge +14

@JamieH 

Did you review the available help articles for using GCal in Zaps?

https://zapier.com/apps/google-calendar/help

@Troy Tessalone Yes we have, hence the question to the forum. 

Userlevel 7
Badge +14

@JamieH 

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.

@Troy Tessalone This is not a question around date formatting, this is a question specifically around how we enter the correct prompt into Zapier to get it to do the thing we want it to do: i.e. I want to create an event plus 1 day after the trigger at 9am. We cannot find anything that instructs around how to write this specific kind of prompt.


We have searched the help articles, we have asked the chat bot, we have searched google. 

Userlevel 7
Badge +14

@JamieH 

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)
miscEye icon Note

By 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.