从gsheet脚本批量设置文件权限到驱动器(我无法设置文件夹权限)

function setFilePermissions() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  
  for (var i = 1; i < data.length; i++) {
    var fileId = data[i][0];
    var permissionType = data[i][1];
    var email = data[i][2];
    var role = data[i][3];
    
    var file = DriveApp.getFileById(fileId);
    var permission = file.addEditor(email);
    
    switch (permissionType) {
      case "读取":
        permission.setCanView(true);
        break;
      case "编辑":
        permission.setCanEdit(true);
        break;
      // 其他权限类型的处理
    }
    
    switch (role) {
      case "所有者":
        permission.setOwner(true);
        break;
      case "编辑者":
        permission.setWriter(true);
        break;
      case "查看者":
        permission.setReader(true);
        break;
      // 其他角色的处理
    }
  }
}