tankchintan

function main() {
  const folderName = "Out"; // Name of the root folder, assume unique folder name for digging
  const maxDepth = 3; // How deep you want to go

  const folder = DriveApp.getFoldersByName(folderName).next();
  const spreadsheetName = folder + ": Folder Contents : " + new Date(); // Creates NEW spreadsheet with format: "SomePics: Folder Contents : 2020 May 5 4:53 PM"
  const spreadsheetFile = SpreadsheetApp.create(spreadsheetName);
  const sheet = spreadsheetFile.getActiveSheet();
  sheet.appendRow(["File Name", "Folder Name", "Link"]);