Append a row of data to the end of the current sheet
Append a row of data to the end of the current sheet Instructions: Explanation: This script appends a new row to the bottom of the active sheet with the data provided in the rowData array. function appendMyRow(){ const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Sheet1’); const rowData = [‘New’,’Laurence’,’Svekis’]; sheet.appendRow(rowData); //Logger.log(sheet.getName()); } Google Apps Script code snippet appends a … Read more