creating calendar entry from email containing specific date/time

  • 30 March 2023
  • 1 reply

Our company uses google mail and all of the google apps.

We’re looking to be able to automate calendar entries based on the invite sent to their email (gmail).

The email contains meeting specifics in this format:


Date: 4/23/23

Time: 7:33am

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

1 reply

Userlevel 7
Badge +14

Hi @tkjr 

Good question.


You would first need to do email parsing, then data translation.

Email parsing can be done with a series of Formatter > Text steps.

Or email parsing can be done in a Code step.

Then you can use a Formatter > Date / Time > Format step to get the date into the format that GCal requires. (see below)


Another option is to use AI to parse the email and transform it into the desired format.




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.