New to n8n – Need Help to Classify Data in Spreadsheet

[danpinho]

Hi everyone,

I’m new to n8n and still finding my way around, so I’d really appreciate some help with a workflow I’m trying to build.

I have a spreadsheet with let’s say 50 dentist names in Column A, and I’d like to use the LLM to detect the gender based on the name. The output I’m aiming for is:

→ Gender in Column B
→ Original name again in Column C

I’ve managed to set this up in Make.com, but I’m struggling to recreate the same flow in n8n. I’m not sure how to structure the nodes for:

→ Reading the spreadsheet row by row
→ Sending each name to OpenAI (or another LLM)
→ Parsing the response (e.g., just getting “male” or “female”)
→ Writing the results back into the sheet in the correct format

If anyone has done something similar or can point me in the right direction, I’d be super grateful!

Ps.: The image shows a flow where I managed to get one response but it keeps repeating the same row. On make i can do it in chunks of 3, 5 or whatever.

Thanks in advance

[Franz]

Something like this.
I also added a Loop, so that the number of requests to the llm is limited. Probably similar to chunks in make). This is also important when you use llms that are rate limited or local llms with limited memory.

[danpinho]

Hallo Franz,

vielen, vielen Dank für deine ausführliche Hilfe – das ging wirklich weit über das hinaus, was ich erwartet hatte!

Thanks a lot – I really appreciate the time and effort you put into this!

Grüße aus Bayern!