我正在嘗試觸發已綁定到 Google 表格的 Google App 腳本。來自 firebase 的數據被拉入應觸發腳本的工作表中。我目前正在使用 onEdit(e)，它在我手動添加數據時起作用，但在從 firebase 更新數據時不起作用。有什么方法可以設置觸發器以在每次更改特定范圍內的單元格值時運行該函數。謝謝！腳本function onEdit(e) {  var ss = SpreadsheetApp.getActive()  var dumpingGround = ss.getSheetByName("Dumping Ground")  var dataDump = ss.getSheetByName("Data Dump")  var ddLastRow = dataDump.getLastRow() + 1  var editCol = e.range.getColumn();  var editRow = e.range.getRow();  Logger.log("edit")  /*Copy from dumping ground to data dump*/  if ((editRow == 1 && editCol == 2) || (editRow == 1 && editCol == 3)){    /*Set required range for data dump and dumping ground*/    var ddRange = '\'Data Dump\'!A' +ddLastRow+ ':BF' + ddLastRow    var dgCopyRange = '\'Dumping Ground\'!B1:BF1'        /*Copy action*/    ss.getRange('\'Dumping Ground\'!B1:BF1').copyTo(ss.getRange(ddRange), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);    /*Check data dump row count and delete 1000 rows if necessary*/    if(ddLastRow = 9999){      dataDump.deleteRows(1, 1000);    }  }};