How to Avoid Duplicate Notion

Help me Build my Workflow
,
1

So;
Same Old Same Old
Me again wondering how to avoid duplicate :wink:

I got the point; use a IF
if exist then UPDATE or STOP to not create a duplicate

in reality; I`m unable to make it happen.
example
from rss I shoot it into a Notion DB
fine; if I rerun the workflow it create duplicate
so I tried to compare guid which are unique URL
and say if don’t match then Create in Notion DB.
but

  1. Notion is super slow as it get entries
  2. the IF fail
2

@bartv thanks for the edition :wink:

Also I saw your workflow with GMail and Notion; which inspired me

image

but I was unable to adapt it to my own usage.

would you mind to explain to me how the Merge is potentially the solution to my issue ?

3

Hello, you already filter out the page you are looking for in your Notion db node, so the “If” node will always be false.

More importantly, if the rss URL is not in the db, the workflow will stop because the “getAllPage” Notion node will not return anything, to prevent that, toggle the option to always output data.

Lastly, change the “If” node to check if the output is empty or not → If it is empty, then the rss URL is not in DB → create a new page. If not empty, then the URL is already in the db, do something else.

Here is an example :

There is the example with 2 cases, one where the rss URL is in the db and the other one where it is not. Hope this helps you ! :slight_smile:

1 Like