[Goose DB] How to get Google Service Account Key (21.06.08.)

First, You must have google developer console project.

You can access at https://console.cloud.google.com/

Google Cloud Platform

Click NEW PROJECT button

Input your project name

And You have to enable apis. (google drive, google spreadsheet)

Google Drive API : https://console.cloud.google.com/apis/library/drive.googleapis.com/

 

Google Cloud Platform

Click USE button

Google Sheets API : https://console.cloud.google.com/apis/library/sheets.googleapis.com/

 

Google Cloud Platform

Click USE button

Then, you have to consent screen configuration.

 

Check Out and click TO MAKE button

Input your app info

Input your email address and click SAVE AND CONTINUE button

Update range with Check Google Drive API

Update range with Check Google Sheets API

Click PUBLISH YOUR APP button

Then, you have to create service account credentials.

 

Click CREATE CREDENTIALS button

Input your service account details

If you want to full access, Select Role to Project> Owner.

 

Choose a Role page

Create a new key

Download your credentials.json

If you want to use this key directly with goose-db library, rename your key to "credentials.json".