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

    1. CSV Upload Form (n8n-nodes-base.formTrigger)
    2. Import Settings (n8n-nodes-base.set)
    3. Check Uploaded File (n8n-nodes-base.code)
    4. File OK? (n8n-nodes-base.if)
    5. Upload Problem (n8n-nodes-base.form)
    6. Read CSV Text (n8n-nodes-base.extractFromFile)
    7. Find Data Table (n8n-nodes-base.dataTable)
    8. Table Found? (n8n-nodes-base.if)
    9. Table Not Found (n8n-nodes-base.form)
    10. Load Existing Rows (n8n-nodes-base.dataTable)
    11. Parse and Check Rows (n8n-nodes-base.code)
    12. File Usable? (n8n-nodes-base.if)
    13. Nothing Imported (n8n-nodes-base.form)
    14. Rows to Write? (n8n-nodes-base.if)
    15. One Item per Row (n8n-nodes-base.splitOut)
    16. Upsert Rows (n8n-nodes-base.dataTable)
    17. Summarize Import (n8n-nodes-base.code)
    18. Any Rejected Rows? (n8n-nodes-base.if)
    19. One Item per Rejected Row (n8n-nodes-base.splitOut)
    20. Build Rejected Rows CSV (n8n-nodes-base.convertToFile)
    21. Email Rejected Rows (n8n-nodes-base.emailSend)
    22. Import Finished (n8n-nodes-base.form)
    StickyNoteFormTriggerSetCodeIFFormExtractFromFileDataTableSplitOutConvertToFileEmailSend
    26 nodesOther
    View on GitHub

    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.

    Related workflows