How do I create a credential to use Google Sheets in n8n. Because I saw all the tutorials, I finally get the client id and client secret but it gives the message: access
blocked: authorization error
1 Like
Assuming you have correctly configured the consent screen with a valid redirect URL, and you have successfully connected the credential with a user, you may have forgotten to enable apis in the app that your workflow needs to use.
2 Likes
Additionally,
if Your App Is in Testing Mode:
- On the same OAuth consent screen, scroll to Test users.
- Click Add Users and enter YOUR Google account email (or team members’ emails).
- Save.
This lets you grant consent for non-verified apps without full verification.
If You Publish Your App
- Any scopes classified as “Sensitive” or “Restricted” (like Drive) will require Google’s verification before public use.
- Until verification is approved, only your listed Test users can authenticate.
- Once verified, remove test-user restrictions so anyone can connect.
2 Likes
Also, probably need to check the call back URL maybe? Good thoughts though
1 Like