Google Drive Permissions Auditor

/**
 * Google Apps Script: Audit Google Drive File Permissions
 * Logs file owners, viewers, editors, and public sharing status to the active sheet.
 */
function auditFolderPermissions() {
  const folderId = "YOUR_FOLDER_ID_HERE"; // Replace with your target folder ID
  const folder = DriveApp.getFolderById(folderId);
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  // Append audit header row
  sheet.appendRow([
    "File Name",
    "File ID",
    "Owner",
    "Sharing Access",
    "Sharing Permission",
    "Editors",
    "Viewers",
    "File URL"
  ]);
  
  auditFolderRecursive(folder, sheet);
}

function auditFolderRecursive(folder, sheet) {
  const files = folder.getFiles();
  
  while (files.hasNext()) {
    const file = files.next();
    try {
      const owner = file.getOwner() ? file.getOwner().getEmail() : "Shared Drive Item";
      const access = file.getSharingAccess();
      const permission = file.getSharingPermission();
      
      const editors = file.getEditors().map(u => u.getEmail()).join(", ");
      const viewers = file.getViewers().map(u => u.getEmail()).join(", ");
      
      sheet.appendRow([
        file.getName(),
        file.getId(),
        owner,
        access.toString(),
        permission.toString(),
        editors || "None",
        viewers || "None",
        file.getUrl()
      ]);
    } catch (err) {
      Logger.log("Error reading file: " + file.getName() + " - " + err.message);
    }
  }
  
  // Recursively audit subfolders
  const subfolders = folder.getFolders();
  while (subfolders.hasNext()) {
    auditFolderRecursive(subfolders.next(), sheet);
  }
}