Extracting Date from within Email text

Question

helloi am new t this but after trying all combos i am stuckall i want is for my gmail to link to calendar for workthe problem all the data is in the email date address etcexample:Job Reference: NAP106212Customer Name: abcdefgheudMobile Phone: 1982372894Work Phone: 12345959Install Date: 09 Jun 2021Install Address: 35 iefheufhInstall Suburb: iejfiefInstall City: eifhiehfi dont know how to extract the date to crate a new event for as the date is just when the email arriveddo i need to have the email body split as i have tried the whole body as to no luck cheers

MarinaH · Accepted Answer

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:Use named variables in the format of the email that is sent:https://zapier.com/help/create/customize/split-up-trigger-data-in-zapsIf these emails are always received in the same format, Zapier offers a free email parser: https://zapier.com/apps/email-parser/integrationsYou 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-zapierThe 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!

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded