用javascript从html表单推送Google表格数据的最好方法

// 表单提交按钮的点击事件处理程序
document.getElementById("submitBtn").addEventListener("click", function(event) {
  event.preventDefault(); // 阻止表单默认提交行为

  // 获取表单字段的值
  var name = document.getElementById("nameInput").value;
  var email = document.getElementById("emailInput").value;
  // ...

  // 构建表单数据对象
  var formData = {
    "name": name,
    "email": email,
    // ...
  };

  // 发送POST请求到Google Sheets API
  fetch("https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append?valueInputOption=USER_ENTERED", {
    method: "POST",
    headers: {
      "Authorization": "Bearer {API_KEY}",
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      "values": [Object.values(formData)]
    })
  })
  .then(response => {
    if (response.ok) {
      console.log("数据已成功推送到Google表格。");
    } else {
      console.error("推送数据到Google表格时出现错误。");
    }
  })
  .catch(error => {
    console.error("发生网络错误：", error);
  });
});