By default, Drive Explorer fetches 8 different metadata to your sheet from the total of 34 available metadata. You can bring the metadata you need to the Google Sheet. Select Add-ons → Drive Explorer → Choose display fields and check all the data you want and click on Save
.
Name of the folder.
Path of the file on the Drive. Eg: My Drive > Design Folder > Final Design.xcf.
Name of the file.
Description of the file/folder.
Thumbnail of the file if available. Useful for image files. Initially, thumbnails look small inside the sheet cells. Please use the Customize fields
menu option to increase the height and width of the cells. Learn more.
Url of the thumbnail. It is the raw link of the image of thumbnail field.
Link to acess the folder in the Google Drive Dashboard.
Link to acess the file in the Google Drive Dashboard.
Preview link of the file, usually for images. Files will be loaded in the browser from this link. You can use this link in the src
attribute of img
element to display images on a webpage.
Keep in mind that for the link to work for anyone on the internet, the file must have been shared with anyone with the link.
Direct download link of the file. Defaults to PDF if applicable.
General information about how the file has been shared with others.
Size of the file in readable format rounded off to two decimal places. Ex: 5.23 MB, 1.2 GB.
E-mail address of the owner of the file.
Comma separated e-mail addresses of people who have view access to the file.
Comma separated e-mail addresses of people who have comment access to the file.
Comma separated e-mail addresses of people who have edit access to the file.
The time at which the file was created.
No of days since December 30, 1899. You will see numbers in this column. Please custom format this column using Google Sheet's Format → Number
feature.
The time at which the file was last modified.
No of days since December 30, 1899. You will see numbers in this column. Please custom format this column using Google Sheet's Format → Number
feature.
Direct link to download the file in PDF format.
Direct link to download the file in ePub format.
Direct link to download the file in CSV format.
Direct link to download the file in ZIP format.
Direct link to download the file in DOCX format.
Direct link to download the file in XLSX format.
Type of the file. For eg: Google Docs.
Populated for image & video files width in pixels.
Populated for image & video files height in pixels.
Populated for video files duration in seconds.
Extension of the file.
You can add your own custom data in this field. Refer to custom metadata section.
Similar to custom metadata 1 mentioned above.
Similar to custom metadata 1 mentioned above.