Google Script to Process Webhook JSON and add Row in Google Sheets

code.js

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);
}

Step 1: Add Apps Script

Step 2: Paste script into Code.gs

Step 3: Deploy as Web App

• Deploy as a webapp
• Set the "Execute as" as yourself
• Set the "Who has access" to Anyone -- this ensures the source of your webhook can access the script
  

Step 4: Copy Webapp URL

Step 5: Confirm/Debug with Postman

• Paste the URL into Postman
• Set it to "POST"
• Put in a JSON array in the "Body" in "raw" format
• Set the response to "Preview" to see results and/or error messages for troubleshooting
  

Step 6: Confirm the rows are created in your spreadsheet