Bulk Link Generator

function listFilesWithViewLinks() {
  const folderId = '1uYwFRCngsbdj2T7GKtFR8b5YHw_71IEY'; // Replace with your actual folder ID
  const folder = DriveApp.getFolderById(folderId);
  const files = folder.getFiles();
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  sheet.getRange("A1:B").clearContent(); // Clear only content, keep formatting if any
  sheet.getRange("A1").setValue("File Name");
  sheet.getRange("B1").setValue("View Link");

  let row = 2;
  while (files.hasNext()) {
    const file = files.next();
    const name = file.getName();
    const id = file.getId();
    const viewLink = `https://drive.google.com/file/d/${id}/view?usp=sharing`;

    sheet.getRange(row, 1).setValue(name);
    sheet.getRange(row, 2).setValue(viewLink);
    row++;
  }
}