google script for sheets

function doPost(e){
try{
   
  var ss = SpreadsheetApp.openById("1nz74OwKGK7nGxaDrQatgNxDVEJZmN5NfY-_l6Y4TIRs");
   var sheets = ss.getSheetByName('Sheet1')
   //var header = sheets.getRange(row, column, numRows, numColumns)
   var header = sheets.getRange(1, 1, 1, sheets.getLastColumn()).getValues()[0];
   var holderArray = [];
    
    
    for(var x=0; x<header.length; x++){
   var tempValues = !e.parameter[header[x]]? '' : e.parameter[header[x]];
   holderArray.push(tempValues);
   }
   
   sheets.appendRow(holderArray);
   
   var result = {"data":e.parameter, "holder":holderArray} 
   var jSonData = JSON.stringify(result)
   return ContentService.createTextOutput(jSonData).setMimeType(ContentService.MimeType.JSON) 
   
  
  }
  catch(e){
    var error = {"error":e }
    var jSonError = JSON.stringify(error)
    return ContentService.createTextOutput(jSonError).setMimeType(ContentService.MimeType.JSON)
  }

}



function doGet(e){
  //return ContentService.createTextOutput('Dul Ros');
  
  try{
   
  var ss = SpreadsheetApp.openById("1nz74OwKGK7nGxaDrQatgNxDVEJZmN5NfY-_l6Y4TIRs");
   var sheets = ss.getSheetByName('Sheet1')
   var data = sheets.getRange(2, 1, sheets.getLastRow()-1, 4).getValues();
   
    
    
   var jSonData = JSON.stringify(data)
   return ContentService.createTextOutput(jSonData).setMimeType(ContentService.MimeType.JSON) 
  }
  catch(e){
    var error = {"error":e }
    var jSonError = JSON.stringify(error)
    return ContentService.createTextOutput(jSonError).setMimeType(ContentService.MimeType.JSON)
  }
  
  
}

For Web application

<div id="postData">
<!--  Show Data  -->
</div>

<script>
let url = 'https://script.google.com/macros/s/AKfycbx4QZiNkHnjBHEIG2bsLTONCDnYA8b6dCPxIoNu2oA5SFlcVhk/exec'


$(document).ready(function(){
let viewPost = ""    
 $.getJSON(url,function(data){
     for(let d of data){
        viewPost += ` <div class="col-sm-12">
                            <div class="card">
                              <div class="card-body">
                                <h5 class="card-title">${d[0]}</h5>
                                <p class="card-text">${d[1]}</p>
                              </div>
                            </div>
                          </div>    
                    `                   
     }
      
     $('#postData').html(viewPost)
}) 
        
})

</script>