Google sheet node is not loading the list

[Jingxuan_Lu]

Describe the problem/error/question

Hi, I added a google sheet node in the workflow as a second node after the first manually trigger node. In the google sheet node, the list are not loading. I think I have got all the needed google data access for my API. Can anyone help me with that? The n8n is running on a server.

P.S. I tried google drive - download file node, and was able to get all the file list. And I also tried google sheet - create file node, it executed successfully.

What is the error message (if any)?

Please share your workflow

My google enabled APIs:

My google credential and n8n credential page:

And my oauth data access:

(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

Information on your n8n setup

• **n8n version: 1.98.2
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• **Running n8n via (Docker, npm, n8n cloud, desktop app):**Docker
• Operating system:

[jabbson]

Have you tried referencing the doc by id or using ‘From list’?

[Jingxuan_Lu]

Thank you for your reply!
I tried referencing the doc using ‘From list’, and only 2 of my excel files showed up in the list(I have many files in my drive). The very first file I want did not showed up. I selected 1 of the 2 files, the sheet selection function using “by list” worked well.

If I used “by ID” to select the file I want, the same error happened.