AI Agent only returns the first item from Google Sheets “Get row(s)” output instead of all results

[Tenzin_Nyima_10B15]

Hello everyone
I’m working on a workflow in n8n where I use an AI Agent connected to Google Gemini, Simple Memory, and two Google Sheets tools — one for fetching rows and another for appending/updating them.

Here’s the workflow structure (screenshot attached):

• When chat message received → AI Agent
• AI Agent uses:
  • Google Gemini Chat Model (for LLM)
  • Simple Memory
  • Get row(s) in Google Sheets (to fetch records)
  • Append or update row in Google Sheets (to modify/add records)

The issue I’m facing is with the “Get row(s) in Google Sheets” node.
It correctly outputs 2 items (as shown in the execution output panel).
However, when the data passes through the AI Agent, the AI only receives and processes the first item and it ignores the second one.

Here’s what happens:

• “Get row(s)” output → 2 records found
• “AI Agent” output → Only 1 record is returned

I want the AI Agent to see and respond with all the fetched rows, not just the first one.

Is there a way to make the ai agent process all the items from the “Get row(s) from Google Sheet” node instead of just the first one?

Any suggestions or examples would be super helpful

Information on your n8n setup

• n8n version: I guess the latest docker version.
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Windows 11

[mohamed3nan]

Tools with "Get Many" operations returns only a single item

As I mentioned, it works on AI Agent v3 and n8n v1.119.0. It also seems that this was a bug which has now been fixed [image]

[John_Trader]

When will it be on the prod? (https://xxxxxxxxxxxxx.app.n8n.cloud/)

I have the same issue right now and the latest version that I can see there is 1.118.2

[Tenzin_Nyima_10B15]

Thank you @mohamed3nan. It worked

[Jess_Carmona]

Thanks @mohamed3nan , this also help me with the same problem !

[khubilla]

My solution is using the AI Agent v2.2 while waiting for the n8n v1.119.0. I copy and paste from my previous workflows. But if this is your first, try copy and pasting this to your workflow

[lawrenceteo]

V1.119.2 still has the same issue. It doesn’t resolve the issue for my case.

[lawrenceteo]

Is there a way to use Agent 2.2?

[Tenzin_Nyima_10B15]

Hey @lawrenceteo, where are you running your n8n?
I’m using Docker, and I updated my n8n version through command Prompt with chatGPT’s help.

Just to be safe, you should verify your version too.

I ran this command to check mine:
docker exec -it n8n n8n --version
and it returned: 1.119.0

[lawrenceteo]

Yes, my n8n information shows it is v1.119. I run on Google Cloud.

[Pooyanght]

I have the latest versions working with the website and not Docker. Still, I have the same problem that only the first row of the data is being considered. The Google Sheet node outputs all the data correctly, but the AI agent does not consider them all.

[Tenzin_Nyima_10B15]

Here, I’m using n8n from the official website and not Docker.

As you can see from the screenshot, it’s working. I tested it both with filters and without filters on the Google Sheets Tool node, and both methods worked. I just had to be careful about what I set in the Filters field on the Google Sheets Tool node.

[lawrenceteo]

@Tenzin_Nyima_10B15 Not sure if the quantity plays a part. My Google Sheets is more than 5000 rows. I have since moved away from Google Sheets to Supabase to avoid this issue.