Google sheets get rows not working properly

Myk3 · October 3, 2025, 7:20pm

Describe the problem/error/question

I am attempting to read each row from a google sheet, I have verified there is data on the sheet, but when I run the node, it shows there is no data.

What is the error message (if any)?

None, just shows no data

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

There is no output as it is the first node.

Information on your n8n setup

n8n version: 1.113.3
Database (default: SQLite):
n8n EXECUTIONS_PROCESS setting (default: own, main):
Running n8n via (Docker, npm, n8n cloud, desktop app): Attempted on cloud and local
Operating system:

starkissed · October 3, 2025, 8:31pm

I noticed you have multiple google sheet account credentials. Could it be that you might be using the wrong credential that is pointing to an empty table?

I’m not sure why it is outputting nothing. To me the setup looks correct.

Myk3 · October 3, 2025, 8:50pm

I am using the right one, I had this automation working, but then instead of front loading the trigger with a click to run, I added the get row behind it..

It is using the same credentials as the nodes that are updating a sheet further in the workflow, and that is what I had already working…

Myk3 · October 6, 2025, 2:18pm

popping in to see if anyone else has any suggestions..

jabbson · October 6, 2025, 5:10pm

If you make the doc/sheet public, I can take a look at why it doesn’t return data and whether it works for me.

Myk3 · October 6, 2025, 5:29pm

Sent you a pm with the spreadsheet

Parintele_Damaskin · October 6, 2025, 5:33pm

If you try to add a filter by clicking Add Filter(does load of your column names so you can choose like you did with sheet?)

jabbson · October 6, 2025, 5:37pm

Thank you, this is what I get when I try to get rows from your document

Myk3 · October 6, 2025, 5:37pm

Yes it sees the sheet, name, columns, etc..

jabbson · October 6, 2025, 5:38pm

Did you rename the document - in your previous example the document name has a space and the one you shared has a dash in it.

Myk3 · October 6, 2025, 5:56pm

I did, I was testing to see if spaces in the name was causing issues..

jabbson · October 6, 2025, 5:58pm

Well, it read the file just fine for me as you can see above - read all 347 rows.

Myk3 · October 6, 2025, 6:09pm

I deleted the node, saved, and readded the node.. and now it is working.. not sure what happened..

Thanks for testing it at least..

system · January 4, 2026, 6:09pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.