I have created a Zap to create an item in one of my boards in Monday.com everytime I receive a certain type of email. I was able to do this successfully, however I'd like the content of the email to be split up and populate in different columns of my board.
For example: The Zap is triggered when an email comes through saying “New Alert for Customer X”
The body of the email contains the following:
- details of the alert
- Customer Name
- Customer Phone number
- Customer Email
- Customer Address
Is there any way to separate that into the respective columns in my Monday.com board? Ideally the item name would be the customer name, the details would be in notes, and so on. As of now I can only seem to but the entire body of the email in the notes section, which gets tricky to read, especially in the app version.
I’m also wondering if there’s a possible work around by first having it populate and separate in Google Sheets? And from there go to Monday.com?
You’ll need to parse the contents of your email.
Try one of these email parsing apps…
Parser by Zapier: https://parser.zapier.com/
Thanks. After connecting that account, what steps would I need to take to link it all together?
Connecting what account?
Depends on what email app you are using.
What email app are you using? (e.g. Gmail)
If Gmail, you’ll have to setup a rule to forward emails to the email parser inbox.
Article to reference: https://support.google.com/mail/answer/6579?hl=en
The email parser app will have to be configured with it’s own rules to parse out the desired data points based on sample emails used as templates.
As an alternative to using Parser, you could use Split Text (Formatter), but only if the body of the email is consistent (as described in the original question).
If the email that you receive is a regular email from a coworker that includes a salutation, signature, etc, this is not going to work.
Just to clarify how the body of the message should look like for this to work, here’s an example:
Since this was a little while ago, I wanted to check in to see if you’d managed to solve this or whether you still needed help here. Please let us know!