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.
In simple terms: watches for an email with the cancellation text & the same email that’s in the notion database - then it updates a field in that same item in the notion database
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 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,
Not sure, how you are planning to use that. Do you have any application that you are developing that can consume the Make API for this? You can refer to the API document here,
