LInk email to notion

Hi @Shaun_Culkin,

It won’t work like that cause the String contains lots of different text and how contains works is like,

If in Notion you have johndoe@gmail.com and if you do contains against johndoe it will return results, however, if you have some text johndoe@gmail.com it won’t work cause it will try to match against all the data, in your case the whole email body.

What you can do is use a Text Parser, And, Extract the email address from the Email Body and then use that for Notion Database query,

Expression,

([a-zA-Z0-9.±]+@[a-zA-Z0-9.-]+.[a-zA-Z0-9._-]+)


Screenshot from 2023-04-20 13-32-04

You can then use the result from Text Parser to use in Notion Contains or Equals query.

1 Like