Update multiple rows in Google Sheet

[jotyrojo]

Hey I’ll cut right thought the chase. I’m using Gemini to output 5 Ideas for social media post. These is what I ask it to return. Id, idea, script, and some other columns that are always returned the same value. Later, I use that output to Update a row in google sheet. But is only updating the first row. I’m pretty sure it has to be in another JSON format that I don’t know how to output or how to convert. Here’s the output:

I’m asking to output in in object JSON format using an output parser (since is needed for Gemini).

What am I missing ? What do I have to do for the GSheet node update all the 5 rows?

Share the output returned by the last node

Information on your n8n setup

• n8n version: 3.7
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting: main
• Running n8n via Docker
• Operating system: Linux srv832602 6.8.0-60-generic #63-Ubuntu SMP PREEMPT_DYNAMIC Tue Apr 15 19:04:15 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux

[darrell_tw]

You missed a split out node in the workflow.

As you can see : Gemini return 5 data within one big object call data

Then Google Sheet only process the one data. Not 5 rows

We need to take out the 5 items in the data and let Google Sheet append.

[jotyrojo]

I knew it was something really simple. Thank you darrell_tw!