限制Google Apps脚本中的数据是否与Google Sheets连接

function protectSheet() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var protection = sheet.protect().setDescription('Protected Sheet');
  
  // 允许特定用户编辑
  var me = Session.getEffectiveUser();
  protection.addEditor(me);
  
  // 禁止其他用户编辑
  protection.removeEditors(protection.getEditors());
  
  if (protection.canDomainEdit()) {
    protection.setDomainEdit(false);
  }
}

function checkUserAccess() {
  var userEmail = Session.getActiveUser().getEmail();
  var allowedUsers = ['user1@example.com', 'user2@example.com'];
  
  if (allowedUsers.indexOf(userEmail) === -1) {
    throw new Error('You do not have permission to access this data.');
  }
  
  // 继续执行脚本
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  Logger.log(data);
}

function getSheetData() {
  var sheetId = 'your-sheet-id';
  var range = 'Sheet1!A1:D10';
  var apiKey = 'your-api-key';
  
  var url = `https://sheets.googleapis.com/v4/spreadsheets/${sheetId}/values/${range}?key=${apiKey}`;
  
  var response = UrlFetchApp.fetch(url);
  var data = JSON.parse(response.getContentText());
  
  Logger.log(data);
}

function onEdit(e) {
  var userEmail = Session.getActiveUser().getEmail();
  var allowedUsers = ['user1@example.com', 'user2@example.com'];
  
  if (allowedUsers.indexOf(userEmail) === -1) {
    // 撤销编辑
    e.range.setValue(e.oldValue);
    SpreadsheetApp.getUi().alert('You do not have permission to edit this range.');
  }
}

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  var menu = ui.createMenu('Custom Menu');
  
  var userEmail = Session.getActiveUser().getEmail();
  var allowedUsers = ['user1@example.com', 'user2@example.com'];
  
  if (allowedUsers.indexOf(userEmail) !== -1) {
    menu.addItem('Protected Action', 'protectedAction');
  }
  
  menu.addToUi();
}

function protectedAction() {
  SpreadsheetApp.getUi().alert('You have access to this action.');
}