Google sheets get rows not working properly

Questions
1

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

image
image3353×892 242 KB

image
image2251×1751 160 KB

image
image1237×1932 446 KB

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

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.

3

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…

4

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

5

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.

6

Sent you a pm with the spreadsheet

7

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

8

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

image
image970×730 44.7 KB

9

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

10

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.

11

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

12

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

13

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

Thanks for testing it at least..