Open the Google Apps Script editor in your Google Sheet.
Change the folderId to the ID of your Drive folder.
Change the sheetTabName, if needed.
Run the script – you may need to authorize the first time around!
You can add a scheduled trigger to keep this running regularly – or add onOpen() to run it every time you open the file.
/**@OnlyCurrentDoc*/
function listFolderContents() {
//***edit the lines below to change your data import***//
var folderId = 'DRIVE_FOLDER_ID';
var sheetTabName = 'Drive File List'
//***do not edit below!!***//
var folder = DriveApp.getFolderById(folderId)
var contents = folder.getFiles();
var ss = SpreadsheetApp.getActive();
var sheet = ss.getSheetByName(sheetTabName);
var fileListArray = [];
fileListArray.push(['Name', 'Link']);
var file;
var name;
var link;
var row;
while(contents.hasNext()) {
file = contents.next();
name = file.getName();
link = file.getUrl();
fileListArray.push([name, link]);
}
sheet.getRange('A:B').clearContent();
sheet.getRange(1,1,fileListArray.length,fileListArray[0].length).setValues(fileListArray);
};