Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I receive a lot of emails that contain non-standardized calendar event information.  For example, an email from a friend suggesting we meet for coffee, an email from my children’s school announcing an upcoming school event, etc.  My thought was could I forward those emails onto Zapier, and have Zapier do a natural language parsing and create a google calendar event (on my calendar).  For example, if a friend emails me and says “Let’s meet for coffee next Thursday at 8:00am”...can I forward that and Zapier will create a google calendar event for that date/time, without any additional formatting of the contents of the email.  The events would primarily be just for my own knowledge on my calendar, so they don’t need to be automatically sent out to other invitees, etc. 

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.

Reply


Terms & Conditions