Google Apps Script无法自动请求SpreadsheetApp及ScriptApp所需OAuth权限咨询

开发者阿泽

2026-6-12

Google Apps Script无法自动请求权限，需手动编辑appsscript.json的问题

问题描述

我多次构建过同类脚本，但最近遇到异常：用于读取Google Sheet数据并发送邮件的脚本，无法自动请求访问电子表格和管理触发器所需的权限，运行时反复报错。

报错详情

电子表格访问错误：

Exception: You do not have permission to call SpreadsheetApp.getActiveSpreadsheet. Required permissions: https://www.googleapis.com/auth/spreadsheets

触发器管理错误：

Exception: Specified permissions are not sufficient to call ScriptApp.getProjectTriggers. Required permissions: https://www.googleapis.com/auth/script.scriptapp

临时解决方案

目前仅能通过手动编辑appsscript.json清单文件，显式声明所需权限解决问题，可正常运行的清单文件如下：

{
  "timeZone": "America/Toronto",
  "dependencies": {
    "enabledAdvancedServices": [
      {
        "userSymbol": "Drive",
        "version": "v3",
        "serviceId": "drive"
      }
    ]
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/script.external_request",
    "https://www.googleapis.com/auth/drive.file",
    "https://www.googleapis.com/auth/drive.readonly",
    "https://www.googleapis.com/auth/gmail.send",
    "https://www.googleapis.com/auth/script.scriptapp"
  ],
  "sheets": {
    "macros": [
      {
        "menuName": "Untitled Macro",
        "functionName": "UntitledMacro"
      }
    ]
  }
}