Question

creating calendar entry from email containing specific date/time

  • 30 March 2023
  • 1 reply
  • 42 views

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:

Details

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.

ChatGPT: https://zapier.com/apps/chatgpt/integrations

OpenAI: https://zapier.com/apps/openai/integrations

 

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.