Best answer

Extracting Date from within Email text

  • 9 June 2021
  • 1 reply
  • 1124 views

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 

 

icon

Best answer by MarinaH 17 June 2021, 01:18

View original

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

Userlevel 4
Badge +9

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!