N8n not reading google sheets

[Zafeer]

Describe the problem/error/question

I have two work flows one that extracts my emails and stores them in a google sheet. And another that is set up as a telegram trigger, points to a agent, using gpt 5 mini and and conversaiton memory for tools I have get rows in google sheet and finally, a gmail draft tool. When I ask what are my latest invoices it goes to the agent the gpt the memory the get rows google sheet tool, and in the output i see the email and the column extracted from the google shete, but then the model returns “I couldnt retrieve the latest invoice data”

NOTE: That my previous prompt used to work on the n8n free API credit, when I changed the API key this started to show. Not sure how to fix this. Any Help to trouble shoot would be appreciated!

What is the error message (if any)?

The model keeps outputting this - I couldn’t retrieve the latest invoices data from the sheet at this moment. Could you please confirm if the invoice data is properly uploaded or specify any particular contractors or work types for me to look up?

Please share your workflow

Share the output returned by the last node

I have included a picuture below

2
From : SOME EMAIL ACTUALLY PRESENT [email protected]
Email:Body - this is email oyd

email_subject - this is subject

recieevd - date 2026-01-14T04:26:31.000Z
dedupe_key - a key to check for deuplicates

but the idea is , the data is there the model is not reading it not sure why

Information on your n8n setup

n8n version: 2.1.5

Database (default: SQLite): Google sheets

n8n EXECUTIONS_PROCESS setting (default: own, main):

Running n8n via (Docker, npm, n8n cloud, desktop app): the website

Operating system: MacOS Sequoia

This is what the google sheet output shows, filled with information from the email. But the Agent doesnt pick up on it for some reason. While Before I chnaged the API key it did

[elsmr]

Hi @Zafeer!

Could you share your workflow? You can either use the Download button from the overflow menu, or copy-paste selected nodes from the workflow page.

This will help pinpoint whether it’s a prompt issue, tool configuration issue, or something else.

[Zafeer]

[Zafeer]

[Zafeer]

Hi Elias @elsmr,

Thank you for looking into this, this is definitely weird and the first time this is happening. These are my two workflows in the same file, I tried copy pasting both but wasn’t able to paste it. I’ve included four images showing the workflow working with the free n8n API credits, the bot not working when I change the API key, and the output of the Get rows in Contractor Invoices google sheets node.

Image 1 Shows the bot working with free n8n API credits,

Image 2 Shows the bot working with free n8n API credits,

Image 3 Shows the bot not working my API credits, I tried gpt 4 mini and gpt 5 mini

The google sheet output which clearly shows data from google sheet, but the agent is not picking it up for some reason.

After changing the API key I did not change any prompt in the agent or nodes. Thank you for helping me out with this! Looking forward to troubleshooting