This is the fastest among the two methods available. You can select one or more files/folders in your Google Drive dashboard, right-click, select Open with and click on Drive Explorer to list the file details on your browser (Refer to the image below).
To multi-select files/folders, you can press Ctrl (Cmd on Mac) or Shift and select. Drive Explorer lists all the sub-folders and their files when you list files from a parent folder. It goes on till there are files to list.
Though you can fetch files directly inside a Google Sheet, there are some limitations (check issue #6). This method eliminates those limitations and lists every file it is supposed to. Also, you might not want to go to the Google Sheets to fetch one-off links of files. You can also export the listing as CSV simply by clicking a button.
You can see how many files you can list how fast in the below email screenshot. (Steve is okay with me sharing the screenshot here 😉)
You might want to list all the files from a particular Shared Drive or My Drive. It is possible. But, only do it when it's necessary. Because it can take a considerable amount of time, based on the number of files you have on the drive. From the root level of the Drive, select New (top left corner) → More → Drive Explorer.