Check Notion Database for Duplicates

[EugenWLF]

Hey Guys,

I want to use Pabbly to check if a Contact has already Opted In on our Systeme.io platform....and if it has I want to announce my sales team Discord Channel to contact them..and if not I want to create the Contact in my Notion Database.


I have created the filter, the query for the duplicates based on the email ..but I cannot seem to make it work. if you guys can give me a hand I would highly appreciate it..

So if a contact with the same Email address is already exists - send a Discord Message with a certain propriety (WHO) if the same item from the Notion Database.

If it does not exist - then Create it (I have managed to create this part properly)


Could you please help?

 

[ArshilAhmad]

Hi @EugenWLF,

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

Could you please state the reason why you have added two 'Search Object' action events to your workflow?

 

[EugenWLF]

One is to search if there is an existing item with the same address ....and one was for searching the corespondent Sales Agent for that person...but indeed in the end I need the following sequence - to query a Database Item and access it s proprieties if it exists to send them to the discord group

 

[ArshilAhmad]

I suggest you delete the Filter which is outside the Router.

Also, try using this Filter condition in Route 2 of your workflow.

 

[EugenWLF]

ok...but how do i search a database by their email address...when the email address is just a propriety? Thank you very much btw

 

[EugenWLF]

I suggest you delete the Filter which is outside the Router.
View attachment 39372

Also, try using this Filter condition in Route 2 of your workflow.
View attachment 39373

it does not show the same...i tried looking at 3..after i delete that filter

 

[Supreme]

ok...but how do i search a database by their email address...when the email address is just a propriety? Thank you very much btw

Please try using the Query Database action step which will provide you with the desired data in the response.