使用post将数据追加到工作表自定义google应用程序脚本方法

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  
  // 追加数据到工作表
  sheet.appendRow([data.field1, data.field2, data.field3]);
  
  return ContentService.createTextOutput("Data appended successfully");
}

import requests

url = "https://script.google.com/macros/s/xxxxxxxxxxxxxx/exec"  # 替换为你的Web应用程序URL
data = {
  "field1": "value1",
  "field2": "value2",
  "field3": "value3"
}

response = requests.post(url, json=data)
print(response.text)