如何通过脚本在Google Sheets中限制编辑者的复制/下载权限？

Got it, let's solve this problem. Google Sheets' native permission settings only let you restrict viewers and commenters from downloading/copying, but we can extend this to editors using Apps Script combined with the Drive Advanced Service. Here's a complete, actionable solution:

We'll use the Drive API to set two key restrictions on your spreadsheet:

• Prevent non-owners from copying the entire file: Only the owner will be able to make a copy of the document.
• Block downloads/printing for non-owners: This includes editors—they can still edit the sheet, but won't have access to download, print, or copy the full document.

Note: Editors will still be able to copy individual cell content with this setup. If you need to block that too, it's far more complex (and hard to fully enforce without breaking usability), but this solution covers the core request of restricting full file downloads/copies.

1. Open your Google Sheet, click Extensions > Apps Script to open the script editor.
2. First, enable the Drive Advanced Service:
   • Click the Services icon (the + sign) on the left sidebar.
   • Search for "Drive API", select it, then click Add.
3. Replace the default code with this:

// Add a custom menu for easy owner access
function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu('Owner Permissions')
    .addItem('Enable Download/Copy Restrictions', 'applyRestrictions')
    .addItem('Disable Download/Copy Restrictions', 'removeRestrictions')
    .addToUi();
}

// Apply restrictions to block editors from downloading/copying
function applyRestrictions() {
  const fileId = SpreadsheetApp.getActiveSpreadsheet().getId();
  
  const restrictions = {
    copyRequiresOwnerPermission: true, // Only owner can copy the full file
    disableDownloads: true // Block downloads/print for non-owners (including editors)
  };
  
  // Update the file via Drive API
  Drive.Files.update({ restrictions: restrictions }, fileId);
  
  SpreadsheetApp.getUi().alert("Restrictions active! Only you (the owner) can download or copy this spreadsheet.");
}

// Remove restrictions if you need to revert later
function removeRestrictions() {
  const fileId = SpreadsheetApp.getActiveSpreadsheet().getId();
  
  const restrictions = {
    copyRequiresOwnerPermission: false,
    disableDownloads: false
  };
  
  Drive.Files.update({ restrictions: restrictions }, fileId);
  
  SpreadsheetApp.getUi().alert("Restrictions removed! Editors can now download or copy the spreadsheet.");
}

• Click the Run button (▶️) next to the onOpen function first. You'll need to authorize the script with your Google account—follow the prompts (you may need to click "Advanced" > "Go to [Script Name]" to bypass the security warning, since this is a custom script).
• Refresh your Google Sheet, and you'll see a new Owner Permissions menu at the top.
• Click Enable Download/Copy Restrictions to activate the limits.

• Only the file owner can run these functions—editors won't see the custom menu (or if they do, they won't have permission to execute the scripts).
• When restrictions are active:
  • Editors can still edit cells, add/remove sheets, and perform regular editing tasks.
  • The "Download", "Print", and "Make a copy" options in the File menu will be grayed out for editors.
  • Editors can still copy individual cell content (this is a limitation of Google Workspace—fully blocking cell-level copying would require extreme measures that hurt usability).

内容的提问来源于stack exchange，提问作者user9617829