Add data in a Google Sheet based on the letter of columns

[Alister_Flandrinck]

Hey!
I am using N8N to send data to my Google Sheets, but for this one, I need to send complex data.

On my Google Sheet, the “Tamis” have few columns, so I can’t use the automatic column mapping method.

Is there a method to link data based on the letter of columns?

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[gualter]

hi @Alister_Flandrinck

Assuming you are using the insert row action on the Sheet node, I believe it currently reads from the header row (in your case Densité, Observations and Tamis) and that’s what it recognizes as the columns.

Do you have a fix number of Tamis columns? If so, one thing you could try is having a top header hidden row with all the necessary columns so you’d be able to pick them in the manual column select on the node’s options:

Hope this helps!

[Alister_Flandrinck]

Hey, the problem is, I can’t edit the sheet It needs to stay like that.
Tamis can have a variable number of columns.

[gualter]

Got it! Can you please share the current workflow (paste it inside a code format in your reply) you’re using so I can have a bit more context?

Also, if I understood correctly:

• the row to input can have n number of Tamis columns
• Has 1 Observations and 1 Densité column

any other conditionals to consider?

Thanks!

[Alister_Flandrinck]

yes that’s correct

[gualter]

Thanks! can you please share the current workflow you have at the moment?