Cannot retrieve documents from Google Sheets (Shows empty)

I have connected my Google Sheets & Google Drive credentials in my n8n successfully. I have made sure to turn on both the API in google cloud project.

However, when I add a Google Sheet node, it shows up empty for me. I am able to however create a new spreadsheet and that works fine. Not only that, but the list shows the newly created spreadsheet but doesn’t show list of other spreadsheets in my Google Sheets.

Not only that, but when I delete the Test spreadsheet from Google Drive (the one I created via n8n that did show up on the list), it still shows up on N8N. It doesn’t look like its getting the latest version and might be relying on local storage for that.

Does anyone else know what could be causing this and what could be the fix?

Enabled API:

  • n8n version:1.72.1
  • Database (default: SQLite):PostgreSQL via Supabase
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker compose
  • Operating system: Ubuntu
  • Hosting: Hosted: self-hosted (but the same error happens when I tried with a n8n account on their website)

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Welcome to the community @Nimit !

Tip for sharing information

Pasting your n8n workflow


Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

That implies to any JSON output you would like to share with us.

Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!


If I’m not mistaken, to be able to list the documents you should have Cloud Resource Manager API enabled in your GCP app.

Hey I had the same issue and solved it by giving N8N full credentials. Before I didn’t allow access to the metadata which is why it didn’t work.

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