Ensuring duplicates are not added to notion database

Hello,

First post! Woo!

The problem I’m facing is that I am unable to filter out duplicate incoming input by comparing to existing pages in a notion database.

Below is what I am expecting.
Round 1 of automation-
Input data:

  • Video A
  • Video B
  • Video C
  • Video D

Output that should go in database:

  • Video A added
  • Video B added
  • Video C added
  • Video D added

Tagged as Completed Video in database:

  • Video D

Round 2 of automation -
Input data:

  • Video C
  • Video D
  • Video E
  • Video F

Ideal Output that should go in database:

  • Video E added
  • Video F added

How should it work?
• Irrespective of whether a video has been tagged as “Complete” or not, we just need to check if input video (YouTube node) has titles which don’t match titles in notion database node.

If they don’t match, then that means its a unique title. And we only want unique items to be outputted so i can connect that to a add page node.

However, for the life of me, I can’t get it to work.

Can you help please? See screenshots below.

Thanks

Nodes from Canvas:

Information on your n8n setup

  • n8n version: 1.91.3
  • **Database (default: SQLite):**Default
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):**Default
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**n8n cloud
  • **Operating system:**Mac

Hi, I think I can help.

Could you share the workflow but using the guide below.
n8n attach workflow

Thanks for that! Here you go :slight_smile:

1 Like