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.

Best answer

Extracting Date from within Email text

  • June 9, 2021
  • 1 reply
  • 1582 views
W

hello

i am new t this but after trying all combos i am stuck

all i want is for my gmail to link to calendar for work

the problem all the data is in the email date address etc

example:

Job Reference: NAP106212
Customer Name: abcdefgheud
Mobile Phone: 1982372894
Work Phone: 12345959
Install Date: 09 Jun 2021
Install Address: 35 iefheufh
Install Suburb: iejfief
Install City: eifhiehf

i dont know how to extract the date to crate a new event for as the date is just when the email arrived

do i need to have the email body split as i have tried the whole body as to no luck 

cheers 

 

Best answer by MarinaH

Hey @Warr Flooring!

Thanks for the question - it sounds like you need to extract the date from the body of an email.

A couple of options:

 

  1. Use named variables in the format of the email that is sent: https://zapier.com/help/create/customize/split-up-trigger-data-in-zaps
  2. If these emails are always received in the same format, Zapier offers a free email parser: https://zapier.com/apps/email-parser/integrations

You have those emails forwarded to the parser, you indicate which parts you want to extract and then on later steps of your Zap you can map those into the Google Calendar date and other fields.
More info on the Email Parser: https://zapier.com/help/create/email-and-text-messages/set-up-your-email-parser-account-in-zapier

The important part is having a way to automatically send those emails to the email parser, either directly from the form submission source (if they're notifications, for example) or setting something up within Gmail to have them forwarded to the Email Parser address you set up.

Thus your Zap will then begin with an Email Parser trigger.

Hope this helps! 
 

 

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

M
Forum|alt.badge.img+9
  • MarinaHZapier Staff
  • Zapier Staff
  • Answer
  • June 16, 2021

Hey @Warr Flooring!

Thanks for the question - it sounds like you need to extract the date from the body of an email.

A couple of options:

 

  1. Use named variables in the format of the email that is sent: https://zapier.com/help/create/customize/split-up-trigger-data-in-zaps
  2. If these emails are always received in the same format, Zapier offers a free email parser: https://zapier.com/apps/email-parser/integrations

You have those emails forwarded to the parser, you indicate which parts you want to extract and then on later steps of your Zap you can map those into the Google Calendar date and other fields.
More info on the Email Parser: https://zapier.com/help/create/email-and-text-messages/set-up-your-email-parser-account-in-zapier

The important part is having a way to automatically send those emails to the email parser, either directly from the form submission source (if they're notifications, for example) or setting something up within Gmail to have them forwarded to the Email Parser address you set up.

Thus your Zap will then begin with an Email Parser trigger.

Hope this helps! 
 

 

Terms & ConditionsAccessibility statement