Issue with new Google Sheets credential: File not listed and 404 on ID

Questions
1

image
image1195×616 28.6 KB

I don´t have the option to fill my Client ID

image
image498×695 41.4 KB
Whe
When I try to create a new credential, a new google sheet conection, it ‘s already connected to my account, it doesn´t matter if I deleted it

before.Describe the problem/error/question

What is the error message (if any)?

image
image385×712 29.4 KB

Please share your workflow

image
image613×235 10.8 KB

I was just starting my workflow

It´s running via cloud, I’m ussing Mac Sonoma 14.12

2

Hey @BobgCastro !

Deleting credentials or reconnect them should solve the issue.

4

Thank you very much for your reply. I actually tried this several times already. The issue is that even if I delete the credentials from n8n, the Gmail account I was using remains connected. So when I create a new credential, I still get the same error.

5

Stupid question here but did you follow the instructions to enable the google sheets api in the GCP console?

You can also try using a service account instead of oauth and then make sure you share the document or drive folder with the service account email address which gcp will give you.

6

Hey @BobgCastro , when creating a new credential in n8n, use an incognito/private browser window or clear your cookies.

If even this doesn’t work, suggest to create new app in Google… with new credentials… weird anyway :thinking:.

Or maybe as @Wouter_Nigrini suggested, that will be key point as well.

7

I appreciate your response, I followed the instructions step by step to configure the google Sheet api in the GPC Console, but the problem it’s in n8n in the window that I show you, once I have my Client ID I cannot conect it to my n8n module, because as I show you there is no blank field to fill in.

I will try as a Service account but as far as I know I should have the option to use the oauth
Thanx for your help
8

I’ll try that Wounter thanks a lot!

9

set sheet field, By Id and paste your sheet id in it, maybe your node work.

is it your credential in credential window is green and showing Account connected?

10

The problem here to me seems like it is a permission thing. If you cannot browse the google doc/sheet from the dropdown list, then either you are missing a permission in GCP or your user which you oauth with does not have access. This is why I recommend a service account as it is a more permanent user auth (oauth access might expire and then the workflow stops to work), and you can control what folders/docs the service account email can control.