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
creating calendar entry from email containing specific date/time
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
- 24171 replies
-
30 March 2023
Hi
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.