Ganapathy S
•  35,246
Overview
Export your Google Drive files to Google Sheet. Get direct download links to files. Export files and folders in nested folders. Sort files based on name, file size. Share files from the sheet.
Drive Explorer lets you pick folders/files from your Google Drive, Shared Drive or the files shared with you to export to the Google Sheet. Sheet columns contain metadata of the files like 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 etc. Whole list of fields it can pull is given below.

Drive Explorer is fast as it uses Drive v2 APIs to pull data. A test run proved it exports 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 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 will be able to share files and get share link or change the existing share settings 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.

Drive Explorer by default refreshes (you can disable 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. 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.

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

Features:
-----------------------------
➤ Export direct download links of selected files/folders on your Google drive
or for all your files. Export links for different file types like DOCX, XLSX, PDF, CSV, ZIP, ePub for applicable files.
➤ 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 Google Drive file manager.
➤ Supports Shared drives (Formerly Team drives).
➤ Provision to sort the files based on name, size, last viewed and last modified.
➤ Customize the look of fields and add custom alias to the fields.
➤ Add/Edit/Remove permission details of files directly from the sheet.
➤ Share multiple files at once with people.
➤ Export the nested folders and files.

Needed permissions explained:
-----------------------------
➤ See, edit, create and delete Drive files
Your files are safe. Drive Explorer doesn’t create/edit/delete any files. For share from sheet feature to work, this permission is required.

➤ 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 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 PayPal in the sidebar,  this permission is required. 

How to use:
-----------------------------
After installing, select Add-ons → Drive Explorer → Start Export.

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

For example, free version of the add-on can be used in only one tab of only one sheet, you can add not more than 5 custom files/folders etc.

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

Detailed instructions - https://goo.gl/riEVN5

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:
A User of Drive Explorer - Google Drive on Sheet
May 27, 2020
FYI. This is ultra buggy in Firefox and really doesnt run properly. considerably better in chrome. The batching system is currently broken due to a bug with google. This means large folders arent complete. in my case I have many large folders so there is tons of manually breaking things up for it to work. surely there is a logical workaround for this in some way?
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
May 21, 2020
I needed to do a mail merge with personalized attachments for each recipient. Drive Explorer let me list and sort the attachments in a way that I could incorporate them into the merge list efficiently.
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
May 18, 2020
Really helpful for various applications. We use it to check if Google Drive sharing and naming conventions have been respected in our company. It works fast and offers all the options for what we need.
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
May 11, 2020
Vignesh added the description field just minutes after I sent him a request. Now we can add keywords in the files descriptions, and retrieve them with Drive Explorer meanwhile Google decides to add the labels feature to Google Drive or Google Photos. This add-on is a must for those who work on document (and knowledge) management every day. Highest recommendation!
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
March 30, 2020
Incredibly useful tool. I tested it because I needed to create a link to send a series of reports to the correct person. I was able to use this to adjust permissions and pull all of the links. Then I used YAMM to send the correct reports to all of the people who needed it. I will be using this on a routine basis with much of my work flow.
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
March 14, 2020
Just bought the license for Drive Explorer because I needed data down through recursive folders. I ran into an immediate problem because I wanted the file list from a prior computer's backup, under Computers, not just My Drive. A couple of emails and screenshots back and forth and within 20 minutes Ganapathy had researched the issue and showed me how to paste the computer name into the file search and up popped my computer's backup. Excellent service. Simple but powerful product. Highest recommendation.
Is this review helpful?
Yes
No
A user of Drive Explorer - Google Drive on Sheet
March 15, 2020
its a spy app
A User of Drive Explorer - Google Drive on Sheet
January 21, 2020
Useful and great
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
January 15, 2020
Im phat
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
January 6, 2020
Great
Is this review helpful?
Yes
No
A User of Drive Explorer - Google Drive on Sheet
December 9, 2019
Love it! I put a copy in Evernote so I always have all files ready with a click! Great Add on.
Is this review helpful?
Yes
No
1-10 of 22
Additional information
Ganapathy S
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu