I am working on moving a database from Excel to Notion.
The issue I’m facing is that the automation moves rows even if the data already exists in Notion.
My goal is to transfer the data once and, in the future, only update or add new rows from Excel to Notion. All matched columns should stay consistent between the two systems.
Let me know if you have any suggestions to fix this.
You could add a Notion “search objects” module before the “Create a database item”. You can use a unique field that’s both in Excel and Notion to find if the item already exists.
Then, you could add a Router with two branches: (1) if nothing found → create database item; (2) if found → update database item
Hey Simo.
Thanks for helping out. What you are saying does make sense. But as you guessed i am begginer at this, so found this part confusing.
(1) if nothing found → create database item;
(2) if found → update database item;
How do i set up this filters between router and notion moduels?
No problem Nika - you can add the filter on each branch, by using “page id” “exists” and “page id” “does not exist”. You can map “page id” from the “Search objects” module
