Drive Explorer lets you pick folders/files from My Drive, Shared Drive or the files shared with you to export to the Google Sheet. Sheet columns contain metadata of the files like name, folder name, download link etc. Check the maker's comment to know more.