Issue with google sheet

Questions
1

Whenever I use the Google Sheets trigger, the list doesn’t load, even though I’ve enabled the APIs for Google Drive and Google Sheets. It worked once when I manually added the link, but now I can’t select a sheet.

image
image1917×866 54.7 KB

2
21918×811 49.6 KB

  • **n8n version: 1.78.1
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system: Windows 11 PRO (23H2 version)

WORKFLOW
{
“nodes”: [
{
“parameters”: {
“pollTimes”: {
“item”: [
{
“mode”: “everyMinute”
}
]
},
“documentId”: {
“__rl”: true,
“value”: “https://drive.google.com/file/d/1SkTblr7rqkWfbHLk_rxiR0h-cLrlImgl/view?usp=sharing”,
“mode”: “url”
},
“sheetName”: {
“__rl”: true,
“mode”: “list”,
“value”: “”
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheetsTrigger”,
“typeVersion”: 1,
“position”: [
0,
0
],
“id”: “00754262-af72-4463-af01-b27a9b16b801”,
“name”: “Google Sheets Trigger”,
“credentials”: {
“googleSheetsTriggerOAuth2Api”: {
“id”: “wiIlLqmDK7UVuNs8”,
“name”: “Google Sheets Trigger account 3”
}
}
}
],
“connections”: {},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “fe7ccd31f041f454c4789c97bbfe178f380ea1a10e4df1c5c289f17c3734899c”
}
}

2

That’s because you have provided a link to gDrive file instead of the spreadsheet file.

To see the list of files, enable the “Cloud Resource Manager API”

3

OMG! Thank you very much, i’m learning to use n8n and i was so frustrated becuase i just couldn’t find any solution since last few days but this was really helpful. I see the list now.

image
image540×325 11 KB