All projects · Automation & Data Pipelines
CleanFlow — Chaotic Spreadsheet Data Cleaner (n8n)
An automated data extraction, normalization, and reconciliation pipeline built in n8n that ingests a chaotic, damaged Excel workbook with…
An automated data extraction, normalization, and reconciliation pipeline built in n8n that ingests a chaotic, damaged Excel workbook with unaligned tables and corrupted metadata, separates transactions into clean domain streams (Fleet Fuel, Office Refreshments, Operational Expenses), standardizes dates and currencies, purges joke entries and duplicates, and exports an audit-ready master ledger to Google Sheets.
- Treats damaged spreadsheets as raw unaligned sources, extracting 3 isolated domain streams (Fuel, Morale, Expenses)
- Resilient ingestion bypassing XML sheet title corruption and unaligned row boundaries
- Domain-specific normalizers: relative dates (Tue? 17 -> 2026-06-17), zero-VAT confectionery rules, and typo rectification
- Deduplication and schema harmonizer outputting 29 audit-ready rows into a Google Sheets master ledger
Built with: n8n, JavaScript (n8n Code nodes), Google Sheets API, Gmail Trigger, XLSX Extraction