Process sales CSVs into invoices with data tables and email notifications

🧾 Smart Sales Invoice Processor (Data tables Edition)

Transform uploaded sales CSV files into validated, enriched invoices, all handled natively inside n8n using Data tables, validation logic, enrichment, duplicate detection, and automated email notifications.

This workflow demonstrates a full ETL + business automation pattern, turning raw CSV data into structured, auditable records ready for storage and customer notifications.

---

✨ Features - ✅ Multi-format CSV input (file upload or raw text) - ✅ Validation for email, quantity, date, and required fields - ✅ Automatic error handling with 400 Bad Request JSON response for invalid CSVs - ✅ Product enrichment from Products Datatable - ✅ Invoice creation and storage in Invoices Datatable - ✅ Automated subtotal, tax, and total calculation - ✅ Duplicate order detection with 409 Conflict response - ✅ Ready-to-send email confirmations (simulated in this version) - ✅ Fully native, no external integrations required

---

🧩 Use Cases - E-commerce order and invoice automation - Internal accounting or ERP data ingestion - Migrating CSV-based legacy systems into n8n - Automated business logic for B2B integrations

---