Download Google Docs From Links

Question

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?

Please help me on this as soon as possible.

Answer 1

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