由于您写道该操作执行了两次，而第二次使用空数据执行，因此听起来像onFormSubmit()触发器运行两次的问题。这似乎是一个Apps脚本错误，但是Stack Overflow用户J.G.和Cooper提供了一个有用的workaround：检查所需问题的值。因此，只需在开始时添加if (e.values && !e.values[1]) { return; }，它就可以防止执行额外的操作。

function onFormSubmit(e) {

  // Reject spurious triggers by checking the value of a required question.
  // In this case,we assume  e.value[1] is required.
  if (e.values && !e.values[1]) { return; }

  var sheet = e.range.getSheet(); // Assuming this is how you defined sheet

  // This is your original code
  for (var i = 0; i < sheet.getMaxColumns(); i++) {
    var params[i] = e.values[i]; 
  }

  console.log(params);

  for (var z = 0; z < paramsInfo.length; z++) {
    var paramsInfoCheck = paramsInfo[z];
    var template = HtmlService.createTemplateFromFile(paramsInfoCheck.name);
    template[paramsInfoCheck.name] = params[paramsInfoCheck.number];
    template.recorded = params[51];
    template.remarks = params[52];

    if ((params[paramsInfoCheck.number] < paramsInfoCheck.min) || (params[paramsInfoCheck.number] > paramsInfoCheck.max)) {
      MailApp.sendEmail(recipients,"Parameter Out of Range Notification","",{htmlBody: template.evaluate().getContent() + spreadsheetlink});
    }
  }
}