Hi everyone!
There is a matter that I am having difficulty with.
I get emails every day with leads.
The body of the email in outlook looks like this:
“Hi Mati, please call James Smith at phone number XXX”
The first name will always be word #5, and the last name will always be word #6.
I want to take them and put them in Google Sheets. How do you do it?
Thank you very much everyone!
If you have access to chatgpt you can just use the structured text action
I prefer to use a tool from within MAKE and not an external tool like ChatGPT.
Hello @MatiJ,
Try the Text Parser(Match Pattern) tool. Set up this and run it.
(?:\b\w+\b[^a-zA-Z]*){4}(\b\w+\b\s+\b\w+\b)
Check here → regex101: build, test, and debug regex
P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions 
and give 
If you need expert help or have questions? Contact or comment below! 
