Hi guys 👋, 5 years ago I wrote a simple tool with HTML, CSS, JS to generate direct download links of Google Drive files from the share link. It is a simple string manipulation tool that is good for one or two files. To automate the process, last year I launched the first version of Drive Explorer, it just exported the direct links and names of the files to the sheet. It was well received by the users and they started giving feedbacks and suggestions to make it better. After a lot of iterations and feature additions, we are here now 😅. Use cases 🗒️: If you use Google Drive a lot at work, Drive Explorer can save you a lot of time and increase your productivity. People use Drive Explorer for variety of purposes. Some use it to manage their inventory. Some use it to share direct download links of files with their customers. With Drive Explorer 💪, You can see all your files from different folders in a sheet tab instead of going back and forth on your Google Drive. You can sort your files on tab based on name, size, created date, modified date, last viewed date either in ascending or descending order. This makes searching of files easy and saves you a lot of time. You can fetch nested files & folders. Just pick the parent folder and tick a checkbox when exporting. You can export files fast. A test run proved it can export 1000 files in approximately 16 seconds. You will be able to share files and get share link or change the existing share settings directly from the sheet. List of fields Drive Explorer can export 😇: Folder name, Folder Path, Filename, Preview Link, Direct Link, Share Status, File Size, Owner, Viewers, Commenters, Editors, Created At, Last Modified At, Export PDF Link, Export ePub Link, Export CSV Link, Export ZIP Link, Export DOCX Link, Export XLSX Link, Filetype, Width, Height, Video Duration, File Extension. Link to written tutorial - Drive Explorer - tutorial YouTube video - https://youtu.be/wMFC2r241f8 What other features you would like? Your feedback is most welcome.

Ganapathy Vignesh

Board Game Manual

Maker

5yr ago

Anna Filou

Would be so awesome if you could add a way to batch-rename files. It's a lot easier to do when you see them in list, spreadsheet like that. It could rename files before sharing or exporting them with the new names while preserving the original file with the old name.

@anna_0x Sure will implement that in future. Thanks for the suggestion.

Gabriel Sorrentino

Awesome!! I developed one myself using google script in the sheets, but it is very slow :( I am running 3 months until today, and it does not finished my folder that I have 500GB of data. Maybe I will try it later, because I saw that it can make 1000 files in 6 seconds. I dont know how you did that but good work.

@gabriel_sorrentino Maybe you used Appscript default DriveApp API. This add-on uses dedicated Drive API V2. I think that's why it is fast.

Drive Explorer

Export your Google Drive files 🗂️to Google Sheet 📗

Export your Google Drive files 🗂️to Google Sheet 📗

Drive Explorer

Export your Google Drive files 🗂️to Google Sheet 📗

Export your Google Drive files 🗂️to Google Sheet 📗

Do you use Drive Explorer?

Do you use Drive Explorer?

You might also like