How to download Google Drive files without having API access enabled?

Question

Looking for a way to download specific files from a shared Google Drive. Something along the lines of a batch file would be great. Run it and it will download the 5/6 files needed and put them into a network drive location. Using Native windows stuff, no specific files (work related so restrictions on downloadss etc.).

I've tried a few things, but can't seem to get my head around it.

Things I have tried so far:

Tried using PowerShell, in various forms to do this. But have a funny feeling that the corporate proxy is blocking it from working.

Have tried:

$client = new-object System.Net.WebClient 
$client.Credentials = Get-Credential
$client.Proxy.Credentials[System.Net.CredentialCache]::DefaultNetworkCredentials
$client.DownloadFile("https://docs.google.com/a/mydomain.co.uk/spreadsheets/d/1in0m8PhfiYhu4qCWO1dxNc3OS3p8prF7HWRZ-bjnKBI/export?format=xlsx","W:\Corp\Comp Serv\Comp Op\Op Br\Dep Data\Call\Rota\WTR.xlsx")

And:

$source = "https://docs.google.com/a/mydomain.co.uk/spreadsheets/d/1in0m8PhfiYhu4qCWO1dxNc3OS3p8prF7HWRZ-bjnKBI/export?format=xlsx"
$dest = "W:\Corp\Comp Serv\Comp Op\Op Br\Dep Data\Call\Rota\WTR.xlsx"
$WebmyClient = New-Object System.Net.WebClient
$WebProxy = New-Object System.Net.WebProxy("http://myproxy.com:1111",$true)
$Credentials = New-Object Net.NetworkCredential("user,"","domain.local")
$Credentials = $Credentials.GetCredential("http://myproxy.com","1111", "KERBEROS");
$WebProxy.Credentials = $Credentials
$WebClient.Proxy = $WebProxy
$WebClient.DownloadFile($source,$dest)

Tried doing this using bitsadmin, but have had no luck, it returned - 'Unable to add file - 0x80070005'

bitsadmin /transfer myDownloadJob /download /priority normal https://docs.google.com/a/mydomain.co.uk/spreadsheets/d/1in0m8PhfiYhu4qCWO1dxNc3OS3p8prF7HWRZ-bjnKBI/export?format=xlsx W:\Corp\Comp Serv\Comp Op\Op Br\Dep Data\Call\Rota\WTR.xlsx

Tried doing it via batch but no joy. Using this script I found online:

   @echo off
    setlocal

    :: uses bitsadmin utility to download a file
    :: bitsadmin is not available in winXP Home edition
    :: the only way to download a file with 'pure' batch
   :download

    if "%2" equ "" (
      call :help
      exit /b 5
   )

   if "%1" equ "" (
      call :help
      exit /b 6
   )
    set url=%~1
    set file=%~2
    rem ----
    if "%~3" NEQ "" (
        set /A timeout=%~3
    ) else (
        set timeout=5
    )

    bitsadmin /cancel download >nul
    bitsadmin /create /download download >nul 
    call bitsadmin /addfile download "%url%" "%CD%\%file%" >nul
    bitsadmin /resume download >nul 
    bitsadmin /setproxysettings download AUTODETECT >nul

    set /a attempts=0
    :repeat
    set /a attempts +=1
    if "%attempts%" EQU "10" (
        echo TIMED OUT
        endlocal
        exit /b 1
    )
    bitsadmin /info download /verbose | find  "STATE: ERROR"  >nul 2>&1 && endlocal &&  bitsadmin /cancel download && echo SOME KIND OF ERROR && exit /b 2
    bitsadmin /info download /verbose | find  "STATE: SUSPENDED" >nul 2>&1 && endlocal &&  bitsadmin /cancel download &&echo FILE WAS NOT ADDED && exit /b 3
    bitsadmin /info download /verbose | find  "STATE: TRANSIENT_ERROR" >nul 2>&1 && endlocal &&  bitsadmin /cancel download &&echo TRANSIENT ERROR && exit /b 4
    bitsadmin /info download /verbose | find  "STATE: TRANSFERRED" >nul 2>&1 && goto :finishing 

   w32tm /stripchart /computer:localhost /period:1 /dataonly /samples:%timeout%  >nul 2>&1
    goto :repeat
    :finishing 
    bitsadmin /complete download >nul
    echo download finished
    endlocal
   goto :eof

   :help
   echo %~n0 url file [timeout]
   echo.
   echo  https://docs.google.com/a/domainname.co.uk/spreadsheets/d/1in0m8PhfiYhu4qCWO1dxNc3OS3p8prF7HWRF-bjnKBI/export?format=xlsx
   echo  W:\Corp\Comp Serv\Comp Op\Op Br\Dep Data\Call\Rota\WTR.xlsx
   echo  10
   echo.
   goto :eof

Answer 1

Assuming that you cannot enable api access to your account (see https://stackoverflow.com/a/27120094/2213940 where it shows how to enable api access to just an organization within your domain) you could do the following:
Using a browser debugger (I used chrome which opens using F12) go to your drive, and select one of the files you want to download.
In the chrome debugger, view the "Network" tab. clear it to make things easier.
Now download the file. If its a non-google file, just download it from there. You will see a post like "https://drive.google.com/uc?id=XXXXXXXXXX&authuser=0&export=download". You can use curl to do the same post, right-click the line and "copy as cURL" which will copy the cookie and such.
that post gives you a download url.

if its a google file (like a spreadsheet) you need to do something similar but it might only work if you do it by opening the spreadsheet first and using the menu to export as xlsx which will be the best backup format.
those urls will look like "https://docs.google.com/spreadsheets/d/XXXXX/export?format=xlsx&id=XXXX

Note that in both cases, the key is to include the same cookie that your browser is using. Ive used cookies like that (but for gmail not drive) and the cookie so far is lasting months and hasnt expired). Make sure to secure the scripts well as the cookie is for your own drive and can be used maliciously.