The hack is to use Google Colab then mount google drive to it. After that, you can use ssh to access google collab file system as well as access mounted google drive. I have written a python notebook here and tried it with success. https://gist.github.com/bikcrum/f9d4cfb0c40dff23329b89cd664d4964
You can download a specific sheet using the ‘GID’. Each sheet has a GID, you can find GID of specific sheet in the URL of spreadsheet. Then you can use this link to download specific sheet – https://docs.google.com/spreadsheets/d/<KEY>/export?format=xlsx&gid=<GID> ex: https://docs.google.com/spreadsheets/d/1D5vzPaOJOx402RAEF41235qQTOs28_M51ee5glzPzj0/export?format=xlsx&gid=1990092150 KEY is the unique ID of the spreadsheet. source: https://www.quora.com/How-do-I-download-just-one-sheet-from-google-spreadsheet/answer/Ranjith-Kumar-339?srid=2YCg
Had the same issue and wasted hours before realizing that “unable to change permissions for owner: C:\Users\Quibbles.credentials\drive-api-quickstart” is just a warning. The real issue is the null pointer here. InputStream in = DriveQuickstart.class.getResourceAsStream(“/client_secret.json”); This line was the issue in my case. “in” was null and hence the null pointer. InputStream in = new FileInputStream(“<Full Path>\\client_secret.json”); … Read more
I’m assuming you’re trying to do Parallel downloads… This may not be an answer you’re looking for, but this is what I’ve experienced in my interactions with google drive api. I use C#, so it’s a bit different, but maybe it’ll help. I had to set a specific amount of threads to run at one … Read more
Blame for Google Drive documents
Give us a little more code, or check the call to gapi.auth.authorize() Check that you are using the correct scope to obtain the OAuth token. Scope should be https://www.googleapis.com/auth/drive Double-Check the scope declaration: https://developers.google.com/accounts/docs/OAuth2Login#sendauthrequest Check the call to gapi.auth.authorize() window.gapi.auth.authorize( { ‘client_id’: clientId, ‘scope’: scope, ‘immediate’: false }, handleAuthResult); from: https://developers.google.com/picker/docs/#hiworld Without an actual code … Read more
This is a CORS issue Cross Origin Resource Sharing. You will need to add CORS on your server so that it sets correct headers. What is CORS and how to solve Read up on: Wrong Origin using HTTPRequests