downloadspreadsheetgoogle-docs

Download Google Docs From Links

I have a list of 500 Google Docs links on a spreadsheet. Would like to download all the Google Docs in a one go WITHOUT opening the Google links?

Solution

  • Put the links in an excel spreadsheet and use formulas to change the links like so:

    Google doc web viewer link:

    https://www.drive.google.com/file/d/FILE_ID/edit?usp=sharing

    to

    https://www.drive.google.com/uc?export=download&id=FILE_ID

    formula:

    =CONCATENATE("https://www.drive.google.com/uc?export=download&id=",MID(<original_link>,33,SEARCH("/",RIGHT(<original_link>,LEN(<original_link>)-33))))

    now you have links that you can click and it will directly download. With the help of a simple batch file you can open and download all files: code required to launch each link:

    start chrome <link>

    change formula:

    =CONCATENATE("start chrome https://www.drive.google.com/uc?export=download&id=",MID(<original_link>,33,SEARCH("/",RIGHT(<original_link>,LEN(<original_link>)-33))))

    Make a .txt file: (paste links)

    @echo off
start chrome <link>
start chrome <link>
start chrome <link>
.
.
.

    change extension to .bat

    double-click bat file to run