google sheets script add new row with content code example
Example 1: getranges google script
let SS = APP.getActiveSpreadsheet();
let sheetIndex0 = SS.getSheets()[0];
sheetIndex0.getRangeList(['A1', 'B1:C7']).setHorizontalAlignment("center");
Example 2: .setColumnWidths() google script
let SS = SpreadsheetApp.getActiveSpreadsheet();
SS.getActiveSheet().setColumnWidths(1, 3, 180)
Example 3: .setRowHeights google script
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
sheet.setRowHeights(1, 3, 20);