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?
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.