将google文档中的表格信息推送回链接的google sheet

function pushTableDataToSheet() {
  var doc = DocumentApp.getActiveDocument();
  var sheetUrl = "链接的Google Sheet的URL";
  var sheet = SpreadsheetApp.openByUrl(sheetUrl).getActiveSheet();
  var table = doc.getTables()[0]; // 假设表格是文档中的第一个表格

  var data = [];
  var numRows = table.getNumRows();
  var numCols = table.getRow(0).getNumCells();

  for (var i = 0; i < numRows; i++) {
    var rowData = [];
    for (var j = 0; j < numCols; j++) {
      rowData.push(table.getCell(i, j).getText());
    }
    data.push(rowData);
  }

  sheet.getRange(1, 1, numRows, numCols).setValues(data);
}