8

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?

luqui
  • 59,485
  • 12
  • 145
  • 204
  • 4
    Have you tried adding your account as a test user under the OAuth consent screen? You can use this link as a reference: https://www.youtube.com/watch?v=bkZns_VOB6I – Twilight Feb 15 '23 at 05:42
  • I'm glad it worked, let me compose it as an answer. By doing so, other people in the community, who may have the same concern as you, will know that theirs can be resolved. – Twilight Feb 15 '23 at 22:37
  • pretty crazy that they release an incomplete documentation. Thanks for this – cryanbhu Apr 16 '23 at 13:05

1 Answers1

23

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

Twilight
  • 1,399
  • 2
  • 11
  • N.B. in the end, using a service account ended up being a better move than a test user. – luqui Apr 17 '23 at 06:40