Before everything, please read the formal article to get the basic idea of auth.
However, Google did some security issue to the account control, which is very very very hard to determine. Now here comes “me" again.
1st of all, you may feel frustrated when you see this screen.
And then you may be re-directed to many many pages that is totally not even close to the answers. And the existing pages of discussion are too old.
OK. That’s why I’m here because I spent like 2 days on it. If you code in Python, it’s not a big deal. But it’s really fast if you use PDI as a tool without too many customized settings.
2nd Come to your setting pages in Google here.
https://console.cloud.google.com/apis/credentials
In 2021, you “HAVE TO" create the service account which is not necessary before. And then, the client-secret.json is
“NOT"
the one you downloaded from OAuth 2.0 Client IDs
3rd You have to create service account and download the client secret after the steps as this showed
And create a new key then download it
It’s the most important step
Which is the only way to success.
mythicalxxxxx . json
Use it as your “client-secret.json" instead
Have a nice day!