如何在Google Apps Script中向API发送两个payload变量

我需要通过API从Google Sheet发送数据，要求在请求的payload字段（即payload: JSON.stringify(payload)行）中同时发送payload和payload1两个变量。现有代码如下：

function sendDataToRoistatAPI() {
  var url = "https:/XXX";
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName("Users"); 

  var data = sheet.getDataRange().getValues();

  for (var i = 1; i < data.length; i++) {
    var rowData = data[i];
    var payload = {
      manual_custom_metric_id: 2,
      source: rowData[1],
      value: rowData[2],
      period: JSON.parse(rowData[4]),
    };
    var payload1 = {
      manual_custom_metric_id: 3,
      source: rowData[1],
      value: rowData[3],
      period: JSON.parse(rowData[4]),
    };
    //Logger.log(payload);
    //Logger.log(payload1);
    var options = {
      method: "post",
      contentType: "application/json",
      payload: JSON.stringify(payload)
    };

    var response = UrlFetchApp.fetch(url, options);

    Logger.log(response.getContentText()); }

其中payload和payload1存储不同数据，但source和period字段对应Google Sheet的B列和D列数据，内容一致。

我已尝试以下两种方法，但均未解决问题：

• 方法1：将两个变量转为数组字符串

payload: JSON.stringify([payload, payload1])

• 方法2：创建第二个请求发送payload1

var options1 = {
      method: "post",
      contentType: "application/json",
      payload: JSON.stringify(payload1)
    };

    var response1 = UrlFetchApp.fetch(url, options1);

    Logger.log(response1.getContentText());

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