n8n 1.45.1 self hosted (sqlite)
I have weird filter behaviour - I am trying to filter out all items which already appear in Google Sheets (by ID column) to implement basic " insert new " strategy and one item (last row?) is always not discarded even though it exists in the sheet.
It looks like your topic is missing some important information. Could you provide the following if applicable.
I realized I had misunderstood how the Filter node (and n8n data items flow in general) works.
For anyone else struggling with this, if you want to implement an “process/append only new items” strategy, you need to use the “Merge” node in “Keep non-matches” mode to only process new entities.
The Filter node’s behavior still doesn’t seem very intuitive to me. The “1 kept, 3 discarded” result made me think it was working, but it wasn’t.
Here is a working example of “insert only new items, by ID field” for Google Sheets and Google Drive.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
