Cannot find Sheet when connected to Google Sheet

Questions
1

my n8n is locally installed with node.js. I’m looking to append rows to a google sheet. I’ve created OAuth account, connected Google Sheet credential to n8n - got message saying connection is successful. I found the Document I want to access in node set up simply by choosing “From list”, however in the “Sheet” column, i’m unable to find the Sheet name (In this case “Sheet1”).

Error message
Could not load list

404 - The resource you are requesting could not be found

Requested entity was not found.

Workflow could be found here: (http://localhost:5678/workflow/aEckYNuMHzEc5xMb)

2

Hi there, have you tried refreshing or relogging your credentials? or a simple delete the node and add it again, i usually do that and it works

3

Hi yes! that solved the problem apparently i didn’t give access to deleting my google sheet (i thought that was a lot of access to grant)..but apparently i needed that …thank you!