# Textparser with monday and SMTP email
**URL:** https://community.make.com/t/textparser-with-monday-and-smtp-email/39616
**Category:** Beginner Questions
**Tags:** text-parser
**Created:** [May 30, 2024, 7:58pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616 "2024-05-30T19:58:44Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [May 30, 2024, 7:58pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/1 "2024-05-30T19:58:44Z")
Hello! I am new to [make.com](http://make.com) and have been trying to create items in a Monday board from emails for a good while now.
The emails body text look like this:
"Coach Haugen - Kundeemne
Name
[name@gmail.com](mailto:name@gmail.com)
12345678"
The first line is the name of the lead, the second line is the email and the last the phone number. They can sometimes add a “+47” which is the Norwegian land code.
**The flow**
This is the flow. The email is SMTP and I know I got the correct one. However, the issue starts already at the “Text parser” module.
**Text parser advanced settings**
I found from other posts where they got the name, email and phonenumber with this:
“{s:\d+:“name”;s:\d+:”(?.+?)“;s:\d+:“email”;s:\d+:”(?.+?)“;s:\d+:“phone”;s:\d+:”(?.+?)“;}”
My intention is then to add the name, email and phonenumber in each of the columns in Monday.
However, the only options I get from the text parser is:
I would suspect this is not correct.
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [May 31, 2024, 2:03am UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/2 "2024-05-31T02:03:12Z")
You are using the Text Parser Match Pattern (Advanced) module, which outputs differently compared to the non-advanced version.
It doesn’t seem like you need the Advanced module, so why are you using it? Simply switch back to the normal module first, and provide new screenshots of the output if you still need assistance.
[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)
> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers!
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [May 31, 2024, 8:47am UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/3 "2024-05-31T08:47:16Z")
Ok! Will do! I will give it a shot! Thanks for the advice.
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [May 31, 2024, 8:49am UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/4 "2024-05-31T08:49:19Z")
My guy! You solved it! Thanks! Simple fixes does wonders!
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [May 31, 2024, 8:57am UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/5 "2024-05-31T08:57:39Z")
I’ll keep this thread active until I get an item created in Monday to ensure it works.
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [June 6, 2024, 9:46pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/6 "2024-06-06T21:46:54Z")
So I almost solved it, but items are still **not** created.
So this is the updated flow:
**Flow**
**Email module settings**
Criteria: All emails
Sender email address: No input
Recipient email address: No input
Subject: “New Message From “clientdomain””
Phrase: No input
Mark message(s) as read when fetched: Yes
Maximum number of results: 20
**Text Parser setting**
Pattern:
“{s:\d+:“name”;s:\d+:”(?.+?)“;s:\d+:“email”;s:\d+:”(?.+?)“;s:\d+:“phone”;s:\d+:”(?.+?)“;}”
Global match: No
Case sensitive: Yes
Multiline: Yes
Singleline: No
Continue the execution of the route even if the module finds no matches: No
Text: “Text content”
**[Monday.com](http://Monday.com) settings**
Item Name: “15. name” (option from the text parser)
Board ID: Client board selected
Group ID: “New leads”
Array of column values to change:
Item 1
Column ID: Phone
Value
Phone (digits only): “15. phone” (option from the text parser)
Item 2
Column ID: Email
Value
Email: “15. email” (option from the text parser)
Create Labels if Missing: No
What can be the reason for it to not create items? I know the email is correctly connected as it reads my emails and mark them as read.
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [June 7, 2024, 2:34am UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/7 "2024-06-07T02:34:56Z")
Welcome to the Make community!
If you need further assistance, please provide the following:
## 1. Screenshots of module fields and filters
Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.
You can upload images here using the Upload icon in the text editor:
## 2. Scenario blueprint
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
(Note: Exporting your scenario will not include private information or keys to your connections)
Uploading it here will look like this:
> blueprint.json (12.3 KB)
## 3. And most importantly, Input/Output bundles
Please provide the **input** and **output** bundles of the modules by running the scenario (or get from the [scenario History tab](https://www.make.com/en/help/scenarios/scenario-execution-history)), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
### A.
Save each bundle contents in your text editor as a `bundle.txt` file, and upload it here into this discussion thread.
Uploading them here will look like this:
> module-1-input-bundle.txt (12.3 KB)
> module-1-output-bundle.txt (12.3 KB)
### B.
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:
- Either add three backticks ````` before and after the code, like this:
- Or use the format code button in the editor:
Providing the input/output bundles will allow others to _replicate_ what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here. Thanks!
[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)
> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers!
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [June 8, 2024, 12:54am UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/8 "2024-06-08T00:54:02Z")
Will do. I will upload it when I get home.
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [June 8, 2024, 5:02pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/9 "2024-06-08T17:02:56Z")
So the screenshot is the same. Nothing is different.
## Scenario blueprint
[blueprint.json](https://community.make.com/uploads/short-url/4FlR9fldeaZkoO458dypUxHjPKz.json) (11.4 KB)
## Input/Output bundles
### Input/Output bundles - Email (Watch Emails)
[module-1-input-bundle.txt](https://community.make.com/uploads/short-url/lF2P2ivKaY0yKndcTtWfjHBAITW.txt) (2 Bytes)
[Module-1-Email\_Output-bundle .txt](https://community.make.com/uploads/short-url/7kV1b7mTKxLTdFZvTQTX4fHFMls.txt) (11.6 KB)
### Input/Output bundles - Text parser
[Module-2-Text-parser\_Input-bundle .txt](https://community.make.com/uploads/short-url/7WeLiIr0MJWEOj2LMILKXkfPf5d.txt) (111 Bytes)
[module-1-input-bundle.txt](https://community.make.com/uploads/short-url/lF2P2ivKaY0yKndcTtWfjHBAITW.txt) (2 Bytes)
### Input/Output bundles - Monday (Create item)
No input or output created.
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [June 9, 2024, 4:59am UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/10 "2024-06-09T04:59:01Z")
Your pattern was incorrect:
The correct regex pattern should be
You can use a Text Parser “[Match Pattern](https://www.make.com/en/help/tools/text-parser)” module with this Pattern (regular expression):
```plaintext
(?.+)\s+(?.+@.+)\s+(?[+\d\s]+)
```
### Proof
[https://regex101.com/r/KQuR4D](https://regex101.com/r/KQuR4D)
### Important Info
- ⚠ **Global match** must be set to **NO**!
# Output
* * *
For more information, see [Text Parser](https://www.make.com/en/help/tools/text-parser) in the Make Help Center:
> **Match Pattern**
> The **Match pattern** module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a [regular expression](https://en.wikipedia.org/wiki/Regular_expression) (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.
>
> - The complete list of metacharacters can be found on the [MDN web docs website](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions).
> - For a tutorial on how to create regular expressions, we recommend the [RegexOne website](https://regexone.com/).
> - For an easy, quick regex generator, try the [Regular Expressions generator](https://regex-generator.olafneumann.org/).
> - For experimenting with regular expressions, we recommend the [regular expressions 101 website](https://regex101.com/). Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.
Hope this helps!
[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)
> ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers!
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [June 12, 2024, 2:05pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/11 "2024-06-12T14:05:17Z")
Thank you very much! I will retry and come up with an update. As always, I appreciate you taking the time to help out!
---
### Author:  [@Tobias\_Schoyen](https://community.make.com/u/Tobias_Schoyen)
#### Post date: [June 13, 2024, 8:39pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/12 "2024-06-13T20:39:11Z")
After changing the pattern, I got this message from the [monday.com](http://monday.com) module:
“[200] invalid value, please check our API documentation for the correct data structure for this column. [Guide to changing column values](https://developer.monday.com/api-reference/docs/change-column-values) [Error Code: ColumnValueException / Error Details: {“column\_value”:”{"phone"=\>"47301668\n\n", "countryShortName"=\>"NO"}“,“column\_type”:“PhoneColumn”}]”
Input data:
[
{
“name”: “Kevin”,
“boardId”: “6338832804”,
“groupId”: “topics”,
“columnValuesToChange”: [
{
“columnId”: “phone\_\_1”,
“columnValue”: {
“phone”: “47301668\n\n”,
“countryShortName”: “NO”
}
},
{
“columnId”: “email”,
“columnValue”: {
“text”: “[Kevin.mollerstuen@gmail.com](mailto:Kevin.mollerstuen@gmail.com)”,
“email”: “[Kevin.mollerstuen@gmail.com](mailto:Kevin.mollerstuen@gmail.com)”
}
}
],
“create\_labels\_if\_missing”: false
}
]
Output data:
[
null
]
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [June 13, 2024, 10:46pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/13 "2024-06-13T22:46:26Z")
No problem, glad I could help!
1. If anyone has a new question in the future, please **start a new thread**. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The [Make Community guidelines](https://community.make.com/t/make-community-the-ultimate-topic/11682) encourages users to try to **mark helpful replies as solutions** to help keep the Community organized.
This marks the topic as solved, so that:
- others can _save time_ when catching up with the latest activity here, and
- allows others to _quickly jump to the solution_ if they come across the same problem
To do this, simply **click the checkbox** at the bottom of the post that answers your question:
3. Don’t forget to like and **bookmark** this topic so you can get back to it easily in future!
4. Do **join** the unofficial [Make Discord server](https://samliew.com/make-discord-invite) for live chat and video assistance
[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)
> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers!
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [September 11, 2024, 10:51pm UTC](https://community.make.com/t/textparser-with-monday-and-smtp-email/39616/14 "2024-09-11T22:51:22Z")