Templates / Deduplicate and archive Notion database rows daily with an audit log

Deduplicate and archive Notion database rows daily with an audit log

Ready for 3.0

by Kevin Yu ✓ · 259 views · created 2026-07-03 · File Management

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 6 nodes and runs on a schedule (every day at 02:00). Along the way it connects Notion.

How it runs

Trigger: On a schedule (every day at 02:00).

Get Database Rows (Notion): get many (database page)
Find Duplicates and Build Recap (Code): runs custom JavaScript code
Route by Item Type (Switch): routes items into 2 branches
Archive Duplicate Page (HTTP Request): calls an HTTP API (PATCH)
Append Run to Audit Log (Notion): append (block)

Services it uses

Notion

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (5)

Schedule Triggern8n-nodes-base.scheduleTrigger
Notionn8n-nodes-base.notion
Coden8n-nodes-base.code
Switchn8n-nodes-base.switch
HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow runs daily and deduplicates a Notion database by grouping pages on a chosen property, keeping one “best” page per group (newest by default) and archiving the rest, then appending an audit recap line to a Notion log page. How it…
Excerpt from Kevin Yu's description on n8n.io.

View the original on n8n.io → Check your own copy

Deduplicate and archive Notion database rows daily with an audit log

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (5)

From the author

Get the weekly “what broke” email