gauth | Google Authenticator Code Validation and Generation | Authentication library

From your question and replying comments, when I added the text of àèìòù to the Spreadsheet and run the script in your question, the created file can be seen as the correct inputted text. So, unfortunately, I cannot replicate your situation.

And, from your following previous replying,

Thank you again Tanaike. I only insert the string and launch the script... Nothing else, I can't understand. Even if use the link via browser "https://docs.google.com/spreadsheets/d/[fileid]/export?format=csv&gid=[sheetid]" I download the file without charset problems, but I don't how I can use this link in the script.

When you want to change the endpoint from 'https://docs.google.com/spreadsheets/d/' + spreadsheetId + '/gviz/tq?tqx=out:csv&gid=' + sheetId to https://docs.google.com/spreadsheets/d/[fileid]/export?format=csv&gid=[sheetid], please modify the script as follows.

This will put the file in the top level of your Drive (https://drive.google.com/drive/my-drive):

The python sample code that is used in the create folder example uses google-api-python-client based on the Python Quickstart, You can refer to this Drive API documentation for the list of methods available in google-api-python-client.

pydrive has a different methods used for Creating and updating file. You need to use CreateFile(metadata) to create an instance of GoogleDriveFile then use Upload()

Sample Code:

I managed a way by performing iterative requests. Don't know if this is the correct way, but it works...

Here's the code, now using the FolderPath with format /folder1/folder2/folderN

This is solved after I changed the authentication from application default credentials to dedicated service account.

According to that upgrade of PySocs with pip3.8 install --user --force-reinstall PySocks should help.

I was importing connect_google_drive_api() into another script, say script x.py.

Both the connect_google_drive_api() function and x.py had the line os.chdir('/Users/my/fol/ders/access_google_drive') to set the working directory to where the client_secrets.json was.

With the following code, I actually make a connection without any issue,

When you run via command line it picks path for json file and others.Cron could not find path.Be absolute in path, It will run smoothly. If absolute path not possible, try relative path with respect to CRON location path.

I made changes according to this Solution by Dano. The save and load of mycreds.txt helped to solve this issue.