I need to extract some details from email received by a 3rd party via Gmail. And push this data to my CRM. My CRM is connected to Zapier and is easily able to accept and match any data fields from the zap. However, I can’t seem to extract the precise data I need.
Below is a sample of what comes into my Gmail business account from a 3rd party commercial website. I don’t want this sender email in my CRM, only the data they send me. The sender email is always the same so it’s easy to identify these emails for the zap. It comes in the following format (in HTML).
Sent from: mail@xxx.com (this is the sender)
This enquiry has been sent from a user on xxx.com. View the details of the property: 123 Main Street, Somewhere (NEW WAREHOUSE FOR SALE...) From: Joe Bloggs Email: joe@mail.com Phone: 0400 12 3456 Message: Hi there, wanting to inquire about the 500m2 warehouse. Can you please send a map of the complex to let us know where the available ones are located in this complex. Listing ID: 12345678 User IP Address: 123.456.789.123
| From: | Joe Bloggs |
| Email: | joe@mail.com |
| Phone: | 0400 12 3456 |
| Message: | Hi there, wanting to inquire about the 500m2 warehouse. Can you please send a map of the complex to let us know where the available ones are located in this complex. |
The problem is; the data I need is in the body of the email (which includes the table) not the sender fields. When searching for fields to extract, Zapier picks up the whole body without extracting the separate fields I need.
The desired (ideal) fields for extraction are;
- First Name:
- Last Name:
- Email:
- Phone:
- Message:
- Property Address: in red
- Listing ID: in blue
I’ve had a look at Email Parser by Zapier, but it doesn’t make sense. Seems to provide less options than standard Gmail extraction if anything.
If there was a way to add extra hooks to the ‘body’ data it might work. Something like;
body: (all the body data here)+Phone=” ”
Any ideas gratefully accepted.
