Gsheet V2.1 — Fix
// New V2.1 style: Append without loading full sheet function appendRows(sheetId, sheetName, rows) const sheet = SpreadsheetApp.openById(sheetId).getSheetByName(sheetName); sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, rows[0].length).setValues(rows);
Performance gain: for large datasets (10,000+ cells). gsheet v2.1