如何自动替换一个Google表的列的值并导入另一个列的值？

function replaceAndImportValues() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastRow = sheet.getLastRow();
  var replaceColumn = 1; // 替换值的列
  var importColumn = 2; // 导入值的列
  
  // 获取替换值和导入值的范围
  var replaceRange = sheet.getRange(2, replaceColumn, lastRow - 1);
  var importRange = sheet.getRange(2, importColumn, lastRow - 1);
  
  // 获取替换值和导入值的数组
  var replaceValues = replaceRange.getValues();
  var importValues = importRange.getValues();
  
  // 替换值并导入新值
  for (var i = 0; i < replaceValues.length; i++) {
    if (replaceValues[i][0] !== "") {
      sheet.getRange(i + 2, importColumn).setValue(replaceValues[i][0]);
    }
  }
}