How to automatically create google calendar event based on natural language within an email?

Hi ​@Cheetah5000 

There might be simpler way to solve for this but one idea I can come up with is using ChatGPT to interpret the email body with a prompt like:

“Does this message constitute an event? If so in your output please provide date, time, and location in a fixed format(some sort of key:value pairs or json). If not, please output “no event”. 

Your next step would be a filter to check if the text “no event” appears from the chatgpt output. 

From the fixed format you could use Code by Zapier to extract the fields and use them as inputs for your calendar. 
 

Hope this helps and excited to see what others come up with for this question!

Hi ​@Cheetah5000 

Try these Zap steps:

1. Trigger: Gmail - New Labeled Email
   1. Create a new Label that you will use to trigger the Zap
2. Action: AI by Zapier - Analyze and Return Data
   1. Configure the inputs/outputs and prompt to use to derive the meeting info needed for the GCal Event
3. Action: Filter
   1. Check to make sure the AI step returned info to use in the GCal step
4. Action: GCal - Quick Add Event

Hi ​@Cheetah5000 

I've created a Zapier automation that addresses your needs, inspired by @robintrainward.

Below, you'll find a step-by-step video demonstrating the Zap, which converts emails into Google Calendar events. The Zap utilizes a ChatGPT prompt to extract essential event details, followed by Formatter by Zapier to refine the responses.

Please let me know if you have any questions or require further explanation.

https://drive.google.com/file/d/1Fn411uy_sMly7GFBa1N8wtM4VESBH1WJ/view?usp=sharing

Thanks!

Nice job ​@Eli Queso!

Hi ​@Eli Queso,

Thank you for sharing your resolution to get the Zap running. This will significantly help our Community members to have as a reference for the same issue.