Templates / Prepare CSV files with GPT-4

Prepare CSV files with GPT-4

Needs changes

by n8n Team ✓ · 7,745 views · created 2023-10-30 · Document Extraction, Multimodal AI

Needs changes. This template uses 4 thing(s) that n8n 3.0 removes: OpenAI (legacy), Item Lists (legacy), Write Binary File, Convert to/from binary data. 4 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 9 nodes and runs manually, when you click “Execute workflow”. It uses only n8n's built-in nodes.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. OpenAI: work with chat
  2. Split In Batches (Loop Over Items (Split in Batches)): loops over the items in batches
  3. Parse JSON (Edit Fields (Set)): sets or maps fields
  4. Make JSON Table (Item Lists): reshapes item lists (legacy Item Lists node)
  5. Convert to CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
  6. Strip UTF BOM bytes (Convert to/from binary data): uses Convert to/from binary data
  7. Create valid binary (Convert to/from binary data): uses Convert to/from binary data
  8. Save to Disk (Write Binary File): uses Write Binary File

Before you upgrade to n8n 3.0

4 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:

  • OpenAI (legacy) in OpenAI: replace with OpenAI node (AI section).
  • Item Lists (legacy) in Make JSON Table: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
  • Write Binary File in Save to Disk: replace with Read/Write Files from Disk.
  • Convert to/from binary data in Strip UTF BOM bytes, Create valid binary: replace with Convert to File or Extract from File.
  • Also check Spreadsheet File: Convert to File / Extract from File.
Removed in 3.0Replace with
OpenAI (legacy)
OpenAI
OpenAI node (AI section)
Item Lists (legacy)
Make JSON Table
Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used)
Write Binary File
Save to Disk
Read/Write Files from Disk
Convert to/from binary data
Strip UTF BOM bytes, Create valid binary
Convert to File or Extract from File

Nodes used (8)

From the author

This workflow generates CSV files containing a list of 10 random users with specific characteristics using OpenAI's GPT-4 model. It then splits this data into batches, converts it to CSV format, and saves it to disk for further use. 1. The execution of the…

Excerpt from n8n Team's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.