Library / Files & Cloud Storage
Files & Cloud Storage
Validate sales CSV uploads and generate approval review ZIPs with n8n forms
Triggered by a form upload, validates a UTF-8 sales CSV against previously released batches in Data Table, lets a reviewer approve or reject it, and returns an audit ZIP.
What it does
## Validate sales CSVs and generate review ZIPs with n8n forms Review recurring sales exports before a manual import. Upload one UTF-8 CSV, validate orders, compare them with previously released batches, and save an exact review. An authenticated reviewer can download, approve the accepted subset or reject it. Each result is returned as an audit ZIP. ### How it works Checks required columns, calendar dates, currency precision and duplicate groups. An n8n Data Table stores immutable batch snapshots and one authoritative release registry. Approval binds to the review hash and commits the release plus decision in one conditional update. Identical historical orders and conflicting IDs are excluded. No shop or accounting import is executed. ### Setup Run the separate setup utility once. Copy stateTableId and actual reviewer emails into both Configure nodes. Keep n8n User Auth and Include User in Output enabled on both forms. Run the credential-free demo, then upload examples/sample.csv with a unique batch ID. Copy batch_id and review_hash from report.json into the decision form. Approve requires typing RELEASE ACCEPTED ROWS. ### Requirements and limits Tested on n8n 2.28.6; Data Tables and n8n-user Forms required. Built-in nodes; no service credentials for this workflow. Required headers: order_id,order_date,amount,currency. One order per row, max 1,000 rows per upload. Run one intake at a time. Registry limits: 5,000 released orders, 1,000 decisions, 4,000,000 serialized characters. Decisions expire after 24 hours by default. Re-upload with a new batch ID if release history changes. Customize limits only with tests.
The steps
- Upload sales CSV for review
- Configure intake and authenticate
- Read uploaded CSV
- Parse CSV and check headers
- Validate sale fields
- Resolve duplicate order IDs
- Build review files
- Read canonical validation report
- Read release registry for intake
- Read history and preserve input
- Check unique batch ID
- Build immutable history-aware review
- Save immutable batch snapshot
- Verify saved review
30 steps in total.
Similar automations