Lead Hook to Google Sheets

leadshook_webhook.json

{"first_name":"John","last_name":"Doe","email":"[email protected]","phone_number":"5552341245","i_currently_live_in_the_following_state":"California","date_of_birth":"5/21/1993","webhook_answer_height":"6 foot","my_weight_slider":"100","are_you_raising_at_least_1_child_in_your_home":"Yes","do_you_receive_financial_assistance_2":"No","do_you_receive_financial_aid":"Yes","please_list_any_criminal_history_including_dui_minor_etc":"None","tobacco_use":"No","pregnancy_complication":"No","please_select_any_sexually_transmitted_infections_you_have_had_if_any":"None","please_check_if_you_experience_any_of_the_following":"Check experience","have_you_taken_any_medications_in_the_last_12_months":"No","please_list_any_supplements_or_medications_you_are_currently_taking":"No Medicines","pregnancy_1":"Pregnancy 1 result","pregnancy_2":"Pregnancy 2 result","pregnancy_3":"Pregnancy 3 result","pregnancy_4":"Pregnancy 4 result","pregnancy_5":"Pregnancy 5 result","pregnancy_6":"Pregnancy 6 result","pregnancy_7":"Pregnancy 7 result","pregnancy_8":"Pregnancy 8 result","pregnancy_9":"Pregnancy 9 result","pregnancy_10":"Pregnancy 10 result","delivery_1_babys_date_of_birth":"4/20/1981","delivery_2_babys_date_of_birth":"4/20/1982","delivery_3_babys_date_of_birth":"4/20/1983","delivery_4_babys_date_of_birth":"4/20/1984","delivery_5_babys_date_of_birth":"4/20/1985","delivery_6_babys_date_of_birth":"4/20/1986","affirm":"affirm result"}

main.js

//this is a function that fires when the webapp receives a GET request
function doGet(e) {
return HtmlService.createHtmlOutput("request received");
}

//this is a function that fires when the webapp receives a POST request
function doPost(e) {

//Return if null
if( e == undefined ) {
Logger.log("no data");
return HtmlService.createHtmlOutput("need data");
}  

var params = JSON.stringify(e.postData.contents);
params = JSON.parse(params);

//Parse the JSON data
var myData = JSON.parse(e.postData.contents);
    var date_time = new Date();
    var first_name = myData.first_name;
    var last_name = myData.last_name;
    var email = myData.email;
    var phone_number = myData.phone_number;
    var i_currently_live_in_the_following_state = myData.i_currently_live_in_the_following_state;
    var date_of_birth = myData.date_of_birth;
    var webhook_answer_height = myData.webhook_answer_height;
    var my_weight_slider = myData.my_weight_slider;
    var are_you_raising_at_least_1_child_in_your_home = myData.are_you_raising_at_least_1_child_in_your_home;
    var do_you_receive_financial_assistance_2 = myData.do_you_receive_financial_assistance_2;
    var do_you_receive_financial_aid = myData.do_you_receive_financial_aid;
    var please_list_any_criminal_history_including_dui_minor_etc = myData.please_list_any_criminal_history_including_dui_minor_etc;
    var tobacco_use = myData.tobacco_use;
    var pregnancy_complication = myData.pregnancy_complication;
    var please_select_any_sexually_transmitted_infections_you_have_had_if_any = myData.please_select_any_sexually_transmitted_infections_you_have_had_if_any;
    var please_check_if_you_experience_any_of_the_following = myData.please_check_if_you_experience_any_of_the_following;
    var have_you_taken_any_medications_in_the_last_12_months = myData.have_you_taken_any_medications_in_the_last_12_months;
    var please_list_any_supplements_or_medications_you_are_currently_taking = myData.please_list_any_supplements_or_medications_you_are_currently_taking;
    var pregnancy_1 = myData.pregnancy_1;
    var pregnancy_2 = myData.pregnancy_2;
    var pregnancy_3 = myData.pregnancy_3;
    var pregnancy_4 = myData.pregnancy_4;
    var pregnancy_5 = myData.pregnancy_5;
    var pregnancy_6 = myData.pregnancy_6;
    var pregnancy_7 = myData.pregnancy_7;
    var pregnancy_8 = myData.pregnancy_8;  
    var pregnancy_9 = myData.pregnancy_9;
    var pregnancy_10 = myData.pregnancy_10;	
    var delivery_1_babys_date_of_birth = myData.delivery_1_babys_date_of_birth;
    var delivery_2_babys_date_of_birth = myData.delivery_2_babys_date_of_birth;
    var delivery_3_babys_date_of_birth = myData.delivery_3_babys_date_of_birth;
    var delivery_4_babys_date_of_birth = myData.delivery_4_babys_date_of_birth;
    var delivery_5_babys_date_of_birth = myData.delivery_5_babys_date_of_birth;
    var delivery_6_babys_date_of_birth = myData.delivery_6_babys_date_of_birth;
    var affirm = myData.affirm;
    
//Get the last row without data
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("LEADS");
var lastRow = Math.max(sheet.getLastRow(),1);
sheet.insertRowAfter(lastRow);
    
//Get current timestamp
var timestamp = new Date();
    
//Insert the data into the sheet
        sheet.getRange(lastRow + 1, 1).setValue(date_time);
        sheet.getRange(lastRow + 1, 2).setValue(first_name);
        sheet.getRange(lastRow + 1, 3).setValue(last_name);
        sheet.getRange(lastRow + 1, 4).setValue(email);
        sheet.getRange(lastRow + 1, 5).setValue(phone_number);
        sheet.getRange(lastRow + 1, 6).setValue(i_currently_live_in_the_following_state);
        sheet.getRange(lastRow + 1, 7).setValue(date_of_birth);
        sheet.getRange(lastRow + 1, 8).setValue(webhook_answer_height);
        sheet.getRange(lastRow + 1, 9).setValue(my_weight_slider);
        sheet.getRange(lastRow + 1, 10).setValue(are_you_raising_at_least_1_child_in_your_home);
        sheet.getRange(lastRow + 1, 11).setValue(do_you_receive_financial_assistance_2);
        sheet.getRange(lastRow + 1, 12).setValue(do_you_receive_financial_aid);
        sheet.getRange(lastRow + 1, 13).setValue(please_list_any_criminal_history_including_dui_minor_etc);
        sheet.getRange(lastRow + 1, 14).setValue(tobacco_use);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_complication);
        sheet.getRange(lastRow + 1, 16).setValue(please_select_any_sexually_transmitted_infections_you_have_had_if_any);
        sheet.getRange(lastRow + 1, 17).setValue(please_check_if_you_experience_any_of_the_following);
        sheet.getRange(lastRow + 1, 18).setValue(have_you_taken_any_medications_in_the_last_12_months);
        sheet.getRange(lastRow + 1, 14).setValue(please_list_any_supplements_or_medications_you_are_currently_taking);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_1);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_2);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_3);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_4);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_5);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_6);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_7);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_8);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_9);
        sheet.getRange(lastRow + 1, 15).setValue(pregnancy_10);
        sheet.getRange(lastRow + 1, 15).setValue(delivery_1_babys_date_of_birth);
        sheet.getRange(lastRow + 1, 15).setValue(delivery_2_babys_date_of_birth);
        sheet.getRange(lastRow + 1, 15).setValue(delivery_3_babys_date_of_birth);
        sheet.getRange(lastRow + 1, 15).setValue(delivery_4_babys_date_of_birth);
        sheet.getRange(lastRow + 1, 15).setValue(delivery_5_babys_date_of_birth);
        sheet.getRange(lastRow + 1, 15).setValue(delivery_6_babys_date_of_birth);
        sheet.getRange(lastRow + 1, 16).setValue(affirm);
    
SpreadsheetApp.flush();
return HtmlService.createHtmlOutput("post request received");
}