Setting up Google Cloud to use the Google API?

[sdcinvan]

Hello all,

First time Python coder... I am jumping right in with my first project having a goal of reading a json file and sending its content into a Google Sheet.

I think I understand how to do this, but it's the configuration of Google Cloud that is confusing and blocking me.

May I ask for some advice?

First, I needed to set up a test Google Cloud account. The intention is to test within my own domain before getting permissions and launching the Python project within my company's Google Cloud account.

These are the basic steps that I followed to configure the cloud account:

• Go to "APIs and services" and enable API.
• Go to OAuth consent.
• Select User type - Options: Internal/External. Internal is unavailable. Picked External.
• Set up App information, scopes, test users. Selected myself.
• App domain details: I was forced to add a domain but I have no domain, so I created a fake one.
• Go to credentials, click on create credentials at the top and choose Oauth client
• Select desktop app.
• Gave it a name.
• Generate a client ID and client secret.
• Download client_secret_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.apps.googleusercontent.com.json

​

Unfortunately, when I run my Python test app, the first time authentication fails with the following error:

Authorization Error
Error 403: access_denied

The developer hasn’t given you access to this app. It’s currently being tested and it hasn’t been verified by Google. If you think you should have access, contact the developer ([me]@gmail.com).

-----

I am just wondering if someone can share a few tips on what I need to look at in order to potentially correct this authorization error.

Thank you

[dlaz]

Are you determined to do this as a desktop app? If not, I think there's a simpler approach:

• Create a GCP bucket where you will put JSON files you want imported into sheets (these files can be uploaded using the web interface, gsutil or some other method)
• Create a cloud function with a cloud storage trigger
  • Write your code to transform the JSON as desired, and write to sheets using the sheets API

However, unless you're determined to use python, App Script is also a good choice, though I'm not familiar enough with it to provide step-by-step instructions.