// version 1.3 function doGet(request) { if(request != null) { var ss = SpreadsheetApp.openById("REPLACE ME WITH SPREADSHEET ID"); var sheet = ss.getSheetByName("Sheet1"); var firstRowRange = sheet.getRange(1, 1, 1, sheet.getLastColumn()); var sheetHeaders=firstRowRange.getValues(); // columns start at one, but arrays start at 0, so this is the right number for inserting into an array that will be placed into the columns var newColumnArrayCount=sheet.getLastColumn(); // initialize new row to be inserted before it gets filled with data var newRow = new Array(sheetHeaders[0].length); for(var x=0;x