File List Exporter

function exportDriveFilesRecursively() {
  var folderId = "YOUR_FOLDER_ID_HERE"; // Replace with your Google Drive Folder ID
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  sheet.appendRow(["File Name", "File ID", "Folder Path", "Size (Bytes)", "URL"]);

  var rootFolder = DriveApp.getFolderById(folderId);
  traverseFolder(rootFolder, rootFolder.getName(), sheet);
}

function traverseFolder(folder, currentPath, sheet) {
  var files = folder.getFiles();
  var rows = [];

  while (files.hasNext()) {
    var file = files.next();
    rows.push([
      file.getName(),
      file.getId(),
      currentPath,
      file.getSize(),
      file.getUrl()
    ]);
  }

  if (rows.length > 0) {
    sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, rows[0].length).setValues(rows);
  }

  var subfolders = folder.getFolders();
  while (subfolders.hasNext()) {
    var subfolder = subfolders.next();
    traverseFolder(subfolder, currentPath + "/" + subfolder.getName(), sheet);
  }
}