This post documents a complete intake & validation pipeline built with n8n.
Core objective: Ensure that only valid, unique, and file-available YouTube upload jobs enter the system.
What’s covered
- Google Sheets date-based intake
- Data sanitization & validation
- Google Drive file existence check
- Merge behavior (Combine by Position)
- Idempotency key strategy
- MySQL schema & duplicate prevention
- Why this workflow is safe to run repeatedly
Included files
- ✅ Workflow JSON
- ✅ MySQL table schema
- ✅ Installation guide
- ✅ Sample input data
This is designed as a foundation workflow — the actual YouTube upload worker comes next.
If you’re learning n8n for real-world systems (not demos), this pattern is worth mastering.