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.
- **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”: “Data.csv - Google Drive”,
“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”
}
}
