creating calendar entry from email containing specific date/time

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.