Google Sheets脚本-查找匹配的元组并在工作表之间复制数据

function copyMatchingData() {
  var sourceSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("源工作表名称");
  var targetSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("目标工作表名称");
  
  var sourceData = sourceSheet.getDataRange().getValues();
  var targetData = targetSheet.getDataRange().getValues();
  
  var matchingData = [];
  
  for (var i = 0; i < sourceData.length; i++) {
    var sourceRow = sourceData[i];
    
    for (var j = 0; j < targetData.length; j++) {
      var targetRow = targetData[j];
      
      if (sourceRow[0] === targetRow[0]) { // 根据需要匹配的列进行修改
        matchingData.push(sourceRow);
        break;
      }
    }
  }
  
  if (matchingData.length > 0) {
    targetSheet.getRange(targetSheet.getLastRow() + 1, 1, matchingData.length, matchingData[0].length).setValues(matchingData);
  }
}