What im trying to do is connect my gmail to my notion, so that when i receive an email that contains a customers name, it searches for that name in the notion database so it knows which database item to update, and them updates a specfic checkbox field in the database item to “true”
I think im nearly there with it, i’ve just got the “contains name” and “searching for name” parts wrong.
I pretty much got it to work, but if i have 2 different customers names in seperate emails, it doensn’t properly work.
hello @Shaun_Culkin, it looks like you’re in the right direction. One question I have: why don’t you have any filter on the “Search object” Notion module? It sounds like you would like to filter for “Customer Name” equals “Customer Name from email” – although filtering by email instead of name may be a better solution here
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 email@example.com and if you do contains against johndoe it will return results, however, if you have some text firstname.lastname@example.org 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,