pythongoogle-cloud-platformgoogle-sheets-api

Access Blocked: <project> has not completed the Google verification process


I am building a simple script which polls some data and then updates a spreadsheet that I am giving to my client. (It is a small project and I don't need anything fancy.)

So I created a Google Cloud project, enabled the Sheets API, and got a credential for a Desktop app. When I try to run the quickstart sample, I get an error:

Access blocked: <my project name> has not completed the Google verification process

I have tried googling and all the solutions seem to be oriented toward what a user should do if they see this, but I am the developer. I only need to grant my own self access to this spreadsheet, since my script is the only thing that will be changing it (I will also share it with the client).

What do I do?


Solution

  • You need to add the account as a test user under the OAuth consent screen:

    1.) From the dashboard go to APIs & Services and click OAuth concent screen

    enter image description here

    2.) Under the Test users, click +Add Users. A menu will prompt on the right panel. enter image description here

    3.) Input the users email enter image description here

    4.) Reload the URL provided.

    Reference: https://www.youtube.com/watch?v=bkZns_VOB6I

    Note: I am not affiliated with the video nor the owner of the youtube channel