App Icon
Ganapathy S
•  129,880
Overview
List your Google Drive files. Fetch direct download links, image URLs to host, file path, size and more. Sort files by name, size & dates. Rename files/folders.
Drive Explorer lets you pick folders/files from your Google Drive, Shared Drive, or the files shared with you to list in a Google Sheet or on the browser. 

Sheet columns contain metadata of the files like the name of the file, containing folder, folder path on your Google drive, direct download link, download links of files in PDF, CSV, ZIP, DOCX, XLSX formats, image URL if it's an image, etc. The whole list of fields it can pull is given below.

Drive Explorer is fast 🚀, it can export 1000 files in approximately 16 seconds.

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 by size, name, created date, modified date, last viewed date either in ascending or descending order. This makes searching for files easy and saves you a lot of time.

You will be able to share files and get a share link or change the existing share settings directly from the sheet.

You can rename, add/edit description to multiple files/folders at a time directly from the sheet.

Do you have any folder which has nested series of folders & files? Drive Explorer can also fetch files & folders in nested folders. Just pick the parent folder and tick a checkbox when exporting.

You can automatically refresh (you can enable this config) the sheet when you open it, meaning, your sheet will have details of the files you recently uploaded on the Drive.

🏆 Use cases:
-----------------------------
If you use Google Drive a lot at work, Drive Explorer can save you a lot of time and increase your productivity. 
- Create direct download links of files in bulk.
- Get image URLs of files to directly display it on the browser or host it on websites.
- Know the size of the files.
- Run security audits.
- Get download links of files in different formats like PDF, CSV, ZIP, etc.
and much more. You can let me know how you're using it at vignesh@syncwithtech.org, I'll add it here :)

📃 List of fields you can export:
-----------------------------
Folder name, Folder Path, Filename, Share Status, File Size, Description, Owner, Viewers, Commenters, Editors, Created At, Last Modified At, Filetype, Width, Height, Video Duration, File Extension, Thumbnail, File Link, Folder Link, Preview Link and types of direct links: PDF, ePub, CSV, ZIP, DOCX, XLSX.

🎁 Features:
-----------------------------
➤ Export direct download links of selected files on your Google drive
or for all your files. Export download links for different file types like DOCX, XLSX, PDF, CSV, ZIP, ePub for applicable files.
➤ Export files inside the nested folders.
➤ Provision to sort the files by size, name, last viewed, and last modified.
➤ Add/Edit/Remove permission details of files directly from the sheet.
➤ Share multiple files at once with people.
➤ Update file/folder name & description directly from the Google Sheet.
➤ Supports Shared drives (Formerly Team drives).
➤ On open, auto-refresh links with an option to disable.
➤ Pick and export only the fields that matter to you.
➤ Links to open files & folders on Google Drive.
➤ Can be used as a Google Drive file manager.
➤ Customize the look of fields and add custom alias to the fields.

🔐 Needed permissions explained:
-----------------------------
➤ See, edit, create and delete Drive files
Your files are safe. For sharing file from the sheet & updating name, description this permission is required.

➤ Add itself to Google Drive
To list your file details directly from Google Drive to a webpage. Right-click any file and select Open with → Drive Explorer.

➤ See, edit, create and delete your spreadsheets in Google Drive
As the metrics are exported to a spreadsheet this permission is needed. Drive Explorer doesn’t delete or create any spreadsheet.

➤ Connect to an external service
Drive Explorer makes requests to the developer’s backend to check if you are a premium user.

➤ Allow this application to run when you are not present
Auto-refresh on open feature needs this permission to work. Drive Explorer won’t ever run on its own in the background when the sheet is closed.

➤ Display and run third-party web content in prompts and sidebars inside Google applications
If you want premium features, payment can be done within the sheet. To run payment gateway in the sidebar, this permission is required. 

🤔 How to use:
-----------------------------
After installing, in a Google Sheet, select Add-ons → Drive Explorer → Start Export.
or
On the Google Drive dashboard, select one or more files, right-click Open with → Drive Explorer.

💫 Premium:
-----------------------------
Drive Explorer is absolutely free to use with some limitations in its functionalities. However, you can upgrade to premium to use it without any limitations.

For example, a free version of the add-on can be used in only one tab of only one sheet etc.

Select Add-ons → Drive Explorer → Buy Premium to unlock premium features.

ℹ️ Resources
-----------------------------
Detailed instructions on how to use the product - https://goo.gl/riEVN5
YouTube video - https://youtu.be/0LWtPMfSpAs

🙋 Feature Requests
-----------------------------
I constantly work to improve the add-on. If you want any new feature, feel free to drop a mail at vignesh@syncwithtech.org.
Reviews
Language:
Sort by:
Profile Picture
Richard Jackson
November 29, 2020
Very helpful script, thanks
Is this review helpful?
Yes
No
Profile Picture
Asaki Gurk
November 29, 2020
I LOVE IT, it's really great and helps me with everything.
Is this review helpful?
Yes
No
Profile Picture
Syafiq Shanizam
November 28, 2020
I have been using this add on for over a year now and I love it! It makes listing file in the drive so much easy and if you have thousands of files in your drive, this add on can make it easy to create a directory list on an excel file. then you can find your files more easily
Is this review helpful?
Yes
No
Profile Picture
Pratik Parmar
November 28, 2020
This is One of the Most useful Google Addon. I am Loving it, Because It gives the Ability to Use the Drive Files and List it on Google Sheets. Since this addon is universal, any level of expertise is adequate to use this addon for their work. Pro Tip : Let's say You wan to make a Google Sheet for Contact Sheet for your Images Folder, Use this addon along with a =Image() Google Sheet Formula to make a Contact Sheet. This Outputs of this Addon is Quite Useful, if you are maintaining the Data/Files on the Google Sheets. Making List of Files for further use with Google Direct Links is Very Easy. I would recommend this addon for all sorts of Business and Personal Use. Literally Saving Time, if you don't use this Addon then Manual procedure to share Items takes time.
Is this review helpful?
Yes
No
Profile Picture
Let Share
November 28, 2020
This is a great script.
Is this review helpful?
Yes
No
Profile Picture
AKASH CHHABRA
November 26, 2020
Great Script
Is this review helpful?
Yes
No
Profile Picture
SAROJ KUMAR SASAMAL
November 26, 2020
Great
Is this review helpful?
Yes
No
Profile Picture
Travis Gutierrez
November 25, 2020
So far so good, I really like the fact that it give a text version of the folder paths (which is useful for things like IFTTT applets).
Is this review helpful?
Yes
No
Profile Picture
Josh Foster
November 24, 2020
great APP!
Is this review helpful?
Yes
No
Profile Picture
Research Department
November 24, 2020
Great
Is this review helpful?
Yes
No
1-10 of 103
Additional information
Ganapathy S
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu