Data Sync & ETL
Archive Duplicate Items in a Notion Database
Every day, or when a page is added, it reads all items in a Notion database, finds duplicates and archives the extra pages.
What it does
# 🧹 Archive (delete) duplicate items from a Notion database ## Overview Automated workflow: 🧹 Archive (delete) duplicate items from a Notion database. This workflow integrates 7 different services: notionTrigger, stickyNote, code, scheduleTrigger, set. It contains 11 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 11 - Node Types: 7 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Every day: scheduleTrigger - Get pages from database: notion - Aggregate all items: aggregate - Format items properly: set - Filter duplicates: code - Archive pages: notion - When a page is added to the database: notionTrigger - Sticky Note: stickyNote - Sticky Note1: stickyNote - Sticky Note2: stickyNote - ... and 1 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- Every day
- Get pages from database
- Aggregate all items
- Format items properly
- Filter duplicates
- Archive pages
- When a page is added to the database
- Error Handler
Similar automations