# Issue with google sheet

**URL:** <https://community.n8n.io/t/issue-with-google-sheet/79508>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [February 19, 2025, 8:30am UTC](https://community.n8n.io/t/issue-with-google-sheet/79508 "2025-02-19T08:30:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sameer](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/sameer/32/58429_2.png) [@Sameer](https://community.n8n.io/u/Sameer)\
**Post date:** [February 19, 2025, 8:30am UTC](https://community.n8n.io/t/issue-with-google-sheet/79508/1 "2025-02-19T08:30:36Z")

</div>

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](https://europe1.discourse-cdn.com/n8n/original/3X/6/f/6ff50c728decfb6be8447afafd727d966f915dd4.png)  
 ![2](https://europe1.discourse-cdn.com/n8n/original/3X/1/2/1200141ef8e80e3dba52ecf05adb67881c1f8867.png)

- \*\*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](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”  
}  
}

---

<div class="post-metadata">

**Author:** ![barn4k](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/barn4k/32/8170_2.png) [@barn4k](https://community.n8n.io/u/barn4k)\
**Post date:** [February 19, 2025, 10:28am UTC](https://community.n8n.io/t/issue-with-google-sheet/79508/2 "2025-02-19T10:28:32Z")

</div>

> [@Sameer](#):
>
> It worked once when I manually added the link, but now I can’t select a sheet.

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”

---

<div class="post-metadata">

**Author:** ![Sameer](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/sameer/32/58429_2.png) [@Sameer](https://community.n8n.io/u/Sameer)\
**Post date:** [February 20, 2025, 9:58pm UTC](https://community.n8n.io/t/issue-with-google-sheet/79508/3 "2025-02-20T21:58:58Z")

</div>

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](https://europe1.discourse-cdn.com/n8n/original/3X/0/4/04580f8a9cad80a542bc7bd4af3193df051aca75.png)

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/36532_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [February 27, 2025, 9:59pm UTC](https://community.n8n.io/t/issue-with-google-sheet/79508/4 "2025-02-27T21:59:54Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.