Cannot connect to google sheet api with secret client and client id

Describe the problem/error/question

I have created a client ID and secret ID from google but when I go to connect it I log into google. 

After I finish logging in it says that I'm not authorized to access the app and then when I refresh the page I get this message.

n8n has not completed the Google verification process. The app is currently being tested, and can only be accessed by developer-approved testers. If you think you should have access, contact the developer.
If you are a developer of n8n, see error details.
Error 403: access_denied

Request details: access_type=offline scope=https://www.googleapis.com/auth/drive.file https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive.metadata response_type=code redirect_uri=http://localhost:5678/rest/oauth2-credential/callback state=eyJ0b2tlbiI6IkF4U0NGeG1ZLWlVMmdUNGI5Q1NrTURKNTV2bGQwUUR3NlVKNCIsImNpZCI6ImtDWlBCMEo5dG1GR0tzT24iLCJjcmVhdGVkQXQiOjE3NjQ4Mzc3NTUwNzF9 prompt=consent flowName=GeneralOAuthFlow client_id=554842810862-f3jplnh7uqadaf6hal0bbmrmhd2k2sig.apps.googleusercontent.com

Please share your workflow

Just logging into Google.

Information on your n8n setup

  • n8n version: Local host the latest one, just got it yesterday.
  • Database (default: SQLite): NA
  • n8n EXECUTIONS_PROCESS setting (default: own, main): NA
  • Running n8n via (Docker, npm, n8n cloud, desktop app): NA
  • Operating system: Windows 11

1 Like

Have you added your email that you are using for authentication into the test users audience side menu option of your Google Cloud project?

1 Like

Yes I ended up watching a youtube and solved it, leaving it for anyone here with this problem - https://www.youtube.com/watch?v=mH1Hgn-JnZw

2 Likes

That’s Good! Can you please mark my reply as a solution?

1 Like