Describe the problem/error/question
I have a simple Google Sheets node (version 4.7) that’s supposed to retrieve a document and one specific sheet within that document. I’m successfully authenticated, and the node finds the correct document, but I cannot get the node to identify any of the sheets within. I’ve tried by URL, by ID, and by “From list”, all failed.
I’ve been able to use this function correctly in other workflows, so I’m not sure why this is failing now. What am I doing wrong?
What is the error message (if any)?
I get this error when I try to use the “From List” option in the Sheet dropdown:
Could not load list
404 - The resource you are requesting could not be found
Requested entity was not found.
When I try to use the sheet ID, I get this error:
Full message
{ "error": { "code": 404, "message": "Requested entity was not found.", "status": "NOT_FOUND" } }
Please share your workflow
{
“nodes”: [
{
“parameters”: {
“documentId”: {
“__rl”: true,
“value”: “1TzEPTX1AB9NX_oIyQtSni0iof4MNdx3Fv5aBw_Qt4u0”,
“mode”: “list”,
“cachedResultName”: “REDACTED Contacts”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1TzEPTX1AB9NX_oIyQtSni0iof4MNdx3Fv5aBw_Qt4u0/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“mode”: “list”,
“value”: “”
}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.7,
“position”: [
208,
0
],
“id”: “58caa3d1-d8d9-494e-9f61-ae107b6e89cf”,
“name”: “Get row(s) in sheet1”,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “k4rnuOjKzLeQu6Q8”,
“name”: “REDACTED”
}
}
}
],
“connections”: {
“Get row(s) in sheet1”: {
“main”: [
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “30a183de5a2b597de5c5c98664f0f8d90ceaa4fafe2093356b29b83a724ec845”
}
}
(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.106.3
- Database (default: SQLite): dont know
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
- Operating system: MacOS