Using Drive Explorer from a Google Sheet provides you with a lot of features. You can,
If you are a video person, you may want to have a look at this walkthrough. If you find the playback speed too much, please use the YouTube player settings to slow down the playback speed.
In a Google Sheet, select Extensions → Drive Explorer and click on Start Export if this is your first time using the add-on or Select files/folders. Now, you will see something like below.
Let us assume that you click on Selected items instead of All files as it will try to list all the files in your Google Drive. If this is the first time you are running Drive Explorer, you will see a dialog with the Add items button to add files/folders to list. Click on Add items button to pick files/folders.
You will see Google Drive Picker to pick items from your personal My Drive, Shared Drives (Team Drives) or the files shared with you by others. Your files are categorized into three different tabs like below according to its type for you to quickly pick the files you want.
Before picking the files/folders there are 3 important things you need to know,
After selecting the items you are interested in, click on Select to see the dialog like the one below.
In the file list dialog, there are some buttons.
Click on Export Details to list the file details in the sheet. Different options available while exporting your file details are explained in the files/folders list section.
If you want to list more details like, File size, Docx link, image preview link check custom columns section.