function doPost(e) { var body = e.postData.contents; var bodyJSON = JSON.parse(body); var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName("Submissions"); var timeStamp = new Date(); var time = Utilities.formatDate(timeStamp, "GMT-08:00", "MM/dd/yy, h:mm a"); var lastRow = sheet.getLastRow(); //Insert the data into the sheet sheet.getRange(lastRow + 1, 1).setValue(bodyJSON["firstName"]); sheet.getRange(lastRow + 1, 2).setValue(bodyJSON["lastName"]); sheet.getRange(lastRow + 1, 3).setValue(bodyJSON["email"]); sheet.getRange(lastRow + 1, 4).setValue(bodyJSON["pluginURL"]); sheet.getRange(lastRow + 1, 5).setValue(bodyJSON["freeFreemium"]); sheet.getRange(lastRow + 1, 6).setValue(bodyJSON["addonURL"]); sheet.getRange(lastRow + 1, 7).setValue(bodyJSON["proURL"]); sheet.getRange(lastRow + 1, 8).setValue(bodyJSON["marketingInfo"]); sheet.getRange(lastRow + 1, 9).setValue(bodyJSON["background"]); return HtmlService.createHtmlOutput(200); }