Unable to sign in google sheet

pls is there a way out here, am kind of new here. i keep getting this error when trying to sign in google sheet

have tried other google account it is the same thing

Hey,

Go to https://console.cloud.google.com/auth/audience

And add a new test user, then try to log in, it will work.

Thanks

Hey @Thelumin ,

Welcome to the community, have you set the correct redirect Url ?

Thanks for this. The problem is that there’s no option to use OAuth, and I have a lot of projects on my console. I also tried it your way, but it’s still the same issue.

Hi, are you using n8n cloud?

Typically you would always need to add a redirect URL. There are a few ways to get this, and you can add multiple as n8n has been a bit buggy with these.

The first way is to actually create a google drive credential:

This would show what your redirect URL is.

If this doesn’t work, in your error details (once you get the error message press see error details) you can get the URL from there as well.

I’d recommend pasting both the n8n provided one and the one that google error details is providing into the Redirect URI in google console.

Hope this helps

Also another fix might be that you need to give yourself access in google console,

Like one of the previous users said, add a test user (the email you are trying to sign in with) and try

Hi @Thelumin I assume you’re using the n8n cloud instance. There has been a recent issue in version 2 with this. Make sure you are using the latest version 2.1.4 where this issue was fixed.

1 Like

thanks for this i will try this out

Thanks for the support i learnt a lot brother. but here i come i still have this error

How do i upgrade it brother

Here is documented how to update the cloud instance: Update your n8n Cloud version | n8n Docs

And here are the release notes that show that the bug was fixed with version 2.1.3: https://github.com/n8n-io/n8n/releases