google-apps-script - 如何无法使用 AppScript 从 Google 表格订阅 Firestore

Question

我有一个带有 5 条记录的 Google 工作表页面，此页面通过 gogoole appscript 转到 google firestore。我还有一个触发器 onEdit。我需要对数据进行循环，因为当我编辑工作表时，数据在 Firestore 上是重复的。这里是 App Script 的代码。

`var ss = SpreadsheetApp.getActiveSpreadsheet();
   var sheetname = "Sheet1";
   var sheet = ss.getSheetByName(sheetname); 
   // get the last row and column in order to define range
   var sheetLR = sheet.getLastRow(); // get the last row
   var sheetLC = sheet.getLastColumn(); // get the last column

   var dataSR = 2; // the first row of data
   // define the data range
   var sourceRange = sheet.getRange(2,1,sheetLR-dataSR+1,sheetLC);

   // get the data
   var sourceData = sourceRange.getValues();
   // get the number of length of the object in order to establish a loop value
   var sourceLen = sourceData.length;



   // Loop through the rows
   for (var i=0;i<sourceLen;i++){
     var data = {}

     data.nomeProdotto= sourceData[i][0],
     data.foto= sourceData[i][1],
     data.costo= sourceData[i][2],
     data.quantità= sourceData[i][3],
     data.id=sourceData[i][4]
      firestore.createDocument("shopping-cart",data);

     }

   }


function onEdit(e) {
  // Set a comment on the edited cell to indicate when it was changed.
  var range = e.range;
  range.setNote('Last modified: ' + new Date());
  Browser.msgBox("la riga modificata è la " + e.range.getRow());
}
`

标签： google-apps-scriptgoogle-sheetsgoogle-cloud-firestore