3 years ago, I had shared a tool to generate direct download link for a file. Soon people started asking me over mail how to get links for a set of files at a time. So I started working on the same and published a Sheets Add-on for the same.
How it works
Upon installation it requires permission to access your Google drive files. Once provided it analyses your files one by one and fills the spreadsheet with details of your files which includes Folder name, File name, Direct link & share details of the file. Each row on spreadsheet represents a file on your Drive.
How to install
You can install the Add-on using this link - Direct Download links for Google Drive. Click on Free, a spreadsheet will be opened and it will ask for your permission. Click Continue and choose your Google account to authorize the app.
Now you're all set to use the Add-on, on your sheet select Add-ons → Direct Drive Links → Generate Links. Within seconds your sheet will be filled with the details of all your files on Google Drive.
Note: The sheet will generate
Settings and Configuration
For now, there are two configurations for you to use according to your needs,
1. Auto refresh
By default, whenever you open the sheet, it'll refresh the links automatically for you. But if you open the sheet more than once between 6 hour interval, automatic refresh won't happen. If you want to get the links of newly added files in the mean time, you can use
Refresh Links option that's available under Add-ons → Direct Drive Links.
You can also disable the auto refresh option all together, select Add-ons → Direct Drive Links → ✓ Autorefresh on open.
2. Getting links for Shared with me files
By default, files shared with you won't be considered. If you want to include
Shared with me files select Add-ons → Direct Drive Links → Include Shared with me Files. Of course, you can turn if off by doing the same again.
Update Share details
If any of the files is not shared with anyone or you want to share that with more people, You can do that using your sheet, you don't have go the Google Drive to update access of the file.
All you have to do is, hover over the file name for which you want to update share details click on the link, you'll be redirected to the file preview page.
On top right corner of the page, left to your profile picture, click on the menu and then Share. Now you can share that file with anyone you want.
Issues and Feature requests
If you ran into any issues or you want any feature to be added to this add-on, do leave a comment in this post. I'll see what best I can do.
The Google sheets Add-on 'Drive Direct Links' is free to use and it doesn't collect or use or share any user info in any form. However authorization is required just to get access to your Google Drive.