Csv Upload To N8n Data Table Without Duplicates
What this workflow does
The workflow contains these steps: CSV Upload Form → Import Settings → Check Uploaded File → File OK? → Upload Problem → Read CSV Text → Find Data Table → Table Found? → Table Not Found → Load Existing Rows → Parse and Check Rows → File Usable? → Nothing Imported → Rows to Write? → One Item per Row → Upsert Rows → Summarize Import → Any Rejected Rows? → One Item per Rejected Row → Build Rejected Rows CSV → Email Rejected Rows → Import Finished.
What you need
- An n8n instance to import and run the workflow.
- StickyNote access for the StickyNote steps listed in this workflow.
- FormTrigger access for the FormTrigger steps listed in this workflow.
- Set access for the Set steps listed in this workflow.
- Code access for the Code steps listed in this workflow.
- IF access for the IF steps listed in this workflow.
- Form access for the Form steps listed in this workflow.
- ExtractFromFile access for the ExtractFromFile steps listed in this workflow.
- DataTable access for the DataTable steps listed in this workflow.
- SplitOut access for the SplitOut steps listed in this workflow.
- ConvertToFile access for the ConvertToFile steps listed in this workflow.
- EmailSend access for the EmailSend steps listed in this workflow.
Workflow nodes
- CSV Upload Form (n8n-nodes-base.formTrigger)
- Import Settings (n8n-nodes-base.set)
- Check Uploaded File (n8n-nodes-base.code)
- File OK? (n8n-nodes-base.if)
- Upload Problem (n8n-nodes-base.form)
- Read CSV Text (n8n-nodes-base.extractFromFile)
- Find Data Table (n8n-nodes-base.dataTable)
- Table Found? (n8n-nodes-base.if)
- Table Not Found (n8n-nodes-base.form)
- Load Existing Rows (n8n-nodes-base.dataTable)
- Parse and Check Rows (n8n-nodes-base.code)
- File Usable? (n8n-nodes-base.if)
- Nothing Imported (n8n-nodes-base.form)
- Rows to Write? (n8n-nodes-base.if)
- One Item per Row (n8n-nodes-base.splitOut)
- Upsert Rows (n8n-nodes-base.dataTable)
- Summarize Import (n8n-nodes-base.code)
- Any Rejected Rows? (n8n-nodes-base.if)
- One Item per Rejected Row (n8n-nodes-base.splitOut)
- Build Rejected Rows CSV (n8n-nodes-base.convertToFile)
- Email Rejected Rows (n8n-nodes-base.emailSend)
- Import Finished (n8n-nodes-base.form)
StickyNoteFormTriggerSetCodeIFFormExtractFromFileDataTableSplitOutConvertToFileEmailSend
26 nodesOther
Need this workflow customized or debugged? Book a 30-min scope call →
Want this set up for you? Book a 30-min scope call
I build and fix n8n workflows for agencies and SaaS teams. 30-minute scope call — bring the problem, leave with an estimate.