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
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
