如何通过google sheets脚本在sheet2(“销售”)中销售产品的基础上减少sheet1(“库存”)中的库存？

function updateInventory() {
  var salesSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("销售");
  var inventorySheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("库存");
  
  var salesData = salesSheet.getDataRange().getValues();
  var inventoryData = inventorySheet.getDataRange().getValues();
  
  for (var i = 1; i < salesData.length; i++) {
    var productName = salesData[i][0];
    var quantitySold = salesData[i][1];
    
    for (var j = 1; j < inventoryData.length; j++) {
      if (inventoryData[j][0] == productName) {
        inventoryData[j][1] -= quantitySold;
        break;
      }
    }
  }
  
  inventorySheet.getRange(2, 1, inventoryData.length - 1, inventoryData[0].length).setValues(inventoryData);
}