You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

5个配置相同的Google Sheets仅1个触发401请求失败异常

问题:单个Google Sheets脚本触发401授权错误

我拥有5个配置完全相同的Google Sheets,均使用以下代码,但其中1个触发了错误:

Exception: Request failed for https://docs.google.com returned code 401. Truncated server

使用的代码

//Get active sheets
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

// Base URL this is used to send to the API 
var url = "https://docs.google.com/spreadsheets/d/SS_ID/export?".replace("SS_ID", ss.getId());

//Format PDF settig up styling
var url_ext = 'exportFormat=pdf&format=pdf' // export as pdf / csv / xls / xlsx
    + '&size=A4' // paper size legal / letter / A4
    + '&portrait=true' // orientation, false for landscape
    + '&fitw=true&source=labnol' // fit to page width, false for actual size
    + '&sheetnames=false&printtitle=false' // hide optional headers and footers
    + '&pagenumbers=false&gridlines=false' // hide page numbers and gridlines
    + '&fzr=false' // do not repeat row headers (frozen rows) on each page
    + '&gid='; // the sheet's Id

//API to fetch PFD of google sheet
var token = ScriptApp.getOAuthToken();
var response = UrlFetchApp.fetch(url + url_ext + sheet.getSheetId(), {                                  
        headers : {
            'Authorization' : 'Bearer ' + token
        }
    }).getBlob().setName(sheet.getName() + ".pdf");
sheet_as_pdf_blob_document=response;

// Define your variables here
var beerOrderrecipient="test@test.com";
var beerOrdersubject=SpreadsheetApp.getActiveSpreadsheet().getName();
var beerOrderbody="Hello,\n\nNew items have been added to your Ordered Beer List. Attached is a printable copy of the most up to date list. \n- Have a great day!";
var nameOfSender="Operations";


function sendOrderedSheet() {
  var message = {
   to: beerOrderrecipient,
   subject:beerOrdersubject,
   body: beerOrderbody,
   name: nameOfSender,
   attachments: [sheet_as_pdf_blob_document]
  }  
  MailApp.sendEmail(message);
  SpreadsheetApp.getUi().alert("The email has been sent thank you!");  
}

我不清楚该表格与其他表格的差异所在,若需要补充其他信息请告知!

更新:我已解决该问题。原因是存在一个很久以前创建的触发器,它调用另一个函数但从未执行成功,每日自动触发并失败,删除该触发器及其关联函数后,所有功能恢复正常!

内容的提问来源于stack exchange,提问作者dachil1pil1

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.08.25 06:54:07