Using Python to do basic Google Drive operations without web server authentication

Question

I want to create a Python script that can do some really basic things (add/remove files in a shared google drive) The script will be running on remote PCs so anything involving web authentication is off the table

I read online that using a service account was the way to go, so I did the following:

Created a project
Enabled the Google Drive API for the project
Created a service account for the project (left "Grant this service account access to project", couldn't figure out what, if anything, I should put here)

Created a key for the service account, downloaded it and tried to use it the following way:

 service_account_info = json.load(open('service_account.json'))
 SCOPES = ['https://www.googleapis.com/auth/drive.metadata.readonly&#39',
           "https://www.googleapis.com/auth/drive.file",
           "https://www.googleapis.com/auth/drive"]

 creds = service_account.Credentials.from_service_account_info(service_account_info, scopes=SCOPES)

 service = build('drive', 'v3', credentials=creds)

 results = service.files().list(pageSize=10, fields="nextPageToken, files(id, name)").execute()
 items = results.get('files', [])

Which results in an exception after my "results" line executes:

google.auth.exceptions.RefreshError: ('No access token in response.', {'id_token': '[longtoken'})

I saw something that hinted I needed to use the "OAuth 2.0 Playground" where I tick off "Use your own Oauth credentials", specify the ClientID and ClientSecret and authorize the Google Drive APIs but when I try to do that I Just get "Error 400: redirect_uri_mismatch" (and I'm not sure if resolving this will actually get me anywhere)

Is there a viable way of doing what I want to do?

A quick search showed many similar questions, have you tried this?stackoverflow.com/a/28322123/8363401 — Danish Hasan
– Danish Hasan, Commented Nov 17, 2020 at 18:38
In your question, you say Created a key for the service account, downloaded it and tried to use it the following way:. But the script is trying to retrieve the file list instead of the download of file. Can I ask you about the detail of your goal? If I misunderstood your question, I apologize. — Tanaike
– Tanaike, Commented Nov 17, 2020 at 22:25
Sorry, retrieving a file list was just a proof-of-concept to show that I could do something with service — Adam Vengroff
– Adam Vengroff, Commented Nov 18, 2020 at 1:09
For installed applications, please read the OAuth 2.0 protocol and the sub section Installed Aplications — Aerials
– Aerials, Commented Nov 18, 2020 at 8:29
@AdamVengroff were you successful in achieving what you wanted? — Aerials
– Aerials, Commented Nov 24, 2020 at 16:03

4th_haim_sister · Accepted Answer · 2022-05-11 16:08:13Z

0

You're missing these steps:

Setting up Oauth consent
Create OAuth Client ID Credentials for a Desktop App using the OAuth Consent
Tunnel a remote port from your server to your local Machine

Service account is possible but it is also possible to authenticate on a remote machine -see here

answered May 11, 2022 at 16:08

4th_haim_sister

611 silver badge1 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Python to do basic Google Drive operations without web server authentication

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related