I’m trying to extract information from an email and send that data to a Google Sheet. I’m using the “New Email Matching Search” trigger, but when I run a test, it only shows me the raw code of the email instead of the actual content.
Could this be related to the email format?
Any advice on how to fix this or what steps I should take would be greatly appreciated.
Here’s the sample output when I run it and below is the email
Have scrolled through the test sample’s output entirely? You’ve only shown 3 output datasets, but there is usually many multiples. Including the “pretty” body as well as the html body.
If you’re not able to scroll through, try typing “body” into the field search container and see if it shows up.
Hi
Try using one of these variables from Gmail:
Help links for resources to do email parsing…
Try using this Zap action: AI by Zapier - Analyze and Return Data
Have scrolled through the test sample’s output entirely? You’ve only shown 3 output datasets, but there is usually many multiples. Including the “pretty” body as well as the html body.
If you’re not able to scroll through, try typing “body” into the field search container and see if it shows up.
All output shows the same from top to bottom if I scroll down. I don’t see the “pretty” body unfortunately.
Hi
Try using one of these variables from Gmail:
Help links for resources to do email parsing…
Try using this Zap action: AI by Zapier - Analyze and Return Data
Hi David, I used the Formatter by Zapier > Split Text and in the input this is what it shows me. From top to bottom, it all says Raw Payload Parts ….
When mapping variables, you can search by the variable label or value. (see screenshot below)
Help for how to map variables to input fields between Zap steps: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields
If you are looking to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory
When mapping variables, you can search by the variable label or value. (see screenshot below)
Help for how to map variables to input fields between Zap steps: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields
Got it! It show the Body Html and Body Plain. When I choose Body Plain, the output only shows the signature and disclaimer part of the email. Do you think it has something to do with format of the email. Email looks like this
Make sure you are selecting a Gmail Zap trigger step example that has the email body data to use to parse.
It can take some trial and error.
Try testing both:
I do this type of email parsing all the time for my clients, pretty basic stuff once you use the correct examples and variables to configure the Zap steps.
Make sure you are selecting a Gmail Zap trigger step example that has the email body data to use to parse.
It can take some trial and error.
Try testing both:
I do this type of email parsing all the time for my clients, pretty basic stuff once you use the correct examples and variables to configure the Zap steps.
Okay, I will do that. Thank you!
HTML-only emails often show as raw MIME in search triggers.
Okay, I will do that. Thank you!
Did that work then??
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.