Watch email => Text parse => monday item

I’m new to Make and I have searched for solutions and scenarios on how to get text from an email to an output to a sheet. So far I have had zero luck getting this to work.

My intent is the following:
I get emails with the following format:

"Client name - Lead

Name
name@gmail.com
12345678"

I want the name be inputted as an item name for monday.com. I want the email to be put in the email column and at last the phonenumber in the phone column.

Under I will post screenshots on how I have set it up. You can bet it is wrong, but I feel completely lost.

Flow

Text Parser Advanced Setting

Pattern input
{s:\d+:“name”;s:\d+:“(?.+?)”;s:\d+:“email”;s:\d+:“(?.+?)”;s:\d+:“phone”;s:\d+:“(?.+?)”;}

Monday settings part 1/2

Monday settings part 2/2

The flow works, but I quess I am completely wrong with the set up. I tried watching videos and everything, but still wrap my head around this. Would be very much appreciated if anyone could help me with this!

Welcome to the Make community!

When reaching out for assistance with your regex pattern for a Text Parser module, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.

Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without exact examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster.

1. This forum might have or already changed your text

When pasting text into this forum, you should format the example text using the rich-text editor, otherwise the forum software might modify the displayed text, and you might get incorrect answers from others because of it.

Some things this forum software might do to mangle your text:

– remove extra spaces (which may be necessary)
– convert links to titles (when copied is incorrect)
– incorrect joined links
– convert single and double quotes to smart angled quotes ()
– emojis
– etc.

This interferes with you receiving correct answers, because it:

– makes JSON invalid (you can verify when copy-paste into https://jsonformatter.org)
– makes incorrect text examples when we need to build a pattern for text parsing

2. To prevent this in future, please format text in code blocks

A. Type code fence manually
Either add three backticks ``` before and after the text, like this:

```
content goes here
```

B. Highlight and click the format button
Or use the format code button in the editor:
Screenshot_2023-10-02_191027

3. You might need to re-copy the original text

Once the post has been submitted, it’s too late to format it since it’s already butchered, and you need to make a re-copy of the text, and format it before submitting the forum post.

Please let us know once you have corrected the issue. This will avoid others potentially providing wrong answers based on incorrect text in your question.

Thank you!

2 Likes

Final solution:

‘’’
(?.+)\s+(?.+@.+)\s+(?[+\d]+)
‘’’

1 Like

Hi @Tobias_Schoyen

Glad to know that your issue is resolved.

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!