How to append multiple rows in google sheet at once?

[Nexivo_Ai]

When I want to add multiple rows at once it doesnt allow me. i have ran it through code node to give me separate fields but it is just making things more difficult.

These are the fields that i get and then when i send this to google sheets its like this:

Now see i am only able to append one row which is B/D 0.

How can i add the rest as well in one go?

Information on your n8n setup

• Version 1.97.1
• n8n EXECUTIONS_PROCESS setting (default: main):
• Running n8n via n8n cloud
• Windows

[Gallo_AIA]

Ehy

The reason only one row is sent to Google Sheets is because you’re referencing index [0] in your expressions, so only the first item of the array is used.

To send all rows, you need to split the array into individual items using a Function node or the Item Lists node.
In the Function node, use code like: return $json["Balance B/D"].map(row => ({ json: row }));.
Then map fields without the [0] index in the Google Sheets node.

This way, each item becomes a separate row.

Tell me if works for you