Google sheets脚本>将行添加到3个工作表之一时，将新行复制到不同的工作表

function onEdit(e) {
  var sheet = e.source.getActiveSheet();
  var row = e.range.getRow();
  
  if (sheet.getName() == "Sheet1" && row > 1) {
    var value = sheet.getRange(row, 1).getValue();
    
    if (value == "条件1") {
      var targetSheet = e.source.getSheetByName("目标工作表1");
      sheet.getRange(row, 1, 1, sheet.getLastColumn()).copyTo(targetSheet.getRange(targetSheet.getLastRow() + 1, 1));
    } else if (value == "条件2") {
      var targetSheet = e.source.getSheetByName("目标工作表2");
      sheet.getRange(row, 1, 1, sheet.getLastColumn()).copyTo(targetSheet.getRange(targetSheet.getLastRow() + 1, 1));
    } else if (value == "条件3") {
      var targetSheet = e.source.getSheetByName("目标工作表3");
      sheet.getRange(row, 1, 1, sheet.getLastColumn()).copyTo(targetSheet.getRange(targetSheet.getLastRow() + 1, 1));
    }
  }
}