I am not sure what else to check, I have done some testing and for me it is working as expected. Can you try making a new file and see if you get the same issue with that? What version of n8n is your cloud instance running on?
So my initial thought is something still needs to be done on the Google Side which is why we display the permission denied message. Sadly though we cut out the full message which is normally something like…
Google Sheets API has not been used in project $foo before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/sheets.googleapis.com/overview?project=$foo then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry.
Yeah I tried to remove it on te google cloud console and update it again but there’s still the same problem… This feature is so nice and I was expecting so much from it but I guess i’ll have to do the call API by my self and not using the trigger node…
I too solved it even if I don’t know which of the steps was ok.
I removed Google sheets API, but doesn’t work.
So I removed Google sheets API and account, then I re-enabled API and create new account. But nothing.
I add Google drive API and finally the issue is fixed.
Hi. I just want to contribute after having a lot of trouble to make this work.
Even after disabling and enabling the Google Sheets API and Google Drive API (inside Google Cloud Services), it still wasn’t working.
So i discovered that inside Admin Console (Admin Console → Apps → Google Workspace → Service Status) the service “Drive and Documents” was disabled.
I hope this information can help somebody in the future (and I’m sorry about my English, not my mother language)