根据单元格值将整行从Google form responses表单移到另一个表单的脚本

function moveRowBasedOnCellValue() {
  var sourceSheetName = "Form Responses"; // 源表单名称
  var targetSheetName = "Processed Responses"; // 目标表单名称
  var targetValue = "Yes"; // 目标单元格的值

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sourceSheet = ss.getSheetByName(sourceSheetName);
  var targetSheet = ss.getSheetByName(targetSheetName);

  var sourceData = sourceSheet.getDataRange().getValues();
  var targetData = targetSheet.getDataRange().getValues();

  for (var i = 1; i < sourceData.length; i++) {
    var row = sourceData[i];
    var cellValue = row[row.length - 1]; // 假设目标单元格在每行的最后一列

    if (cellValue == targetValue) {
      targetSheet.appendRow(row);
      sourceSheet.deleteRow(i + 1);
      i--; // 删除行后需要将索引减1
    }
  }
}