Gsheet: V2.1

// Write new data - batch operation const newData = rows.slice(1); // remove CSV headers if (newData.length > 0) targetRange.offset(1, 0, newData.length, newData[0].length).setValues(newData);

: If you see #NAME? errors, ensure you haven't accidentally deleted the hidden calculation tabs or named ranges the sheet relies on . gsheet v2.1

POST https://sheets.googleapis.com/v4/spreadsheets/id/values/range:append?valueInputOption=USER_ENTERED // Write new data - batch operation const newData = rows