I want to use Google Spreadsheet as database-like. Normally, this is isn’t posibble at all. But not impossible. I coded a simple CRUD script for spreadsheet. You can use it for developing row-by-row logging apps.
Enjoy !

var belge=SpreadsheetApp.getActiveSpreadsheet();
var sayfa=belge.getSheets()[0];

function save(data1) {
  
  var lr=sayfa.getLastRow();
  var new_record_row=lr+1;
  //generate id
  var id=uid();
  
  sayfa.getRange(new_record_row, 1).setValue(id)
  
  sayfa.getRange(new_record_row, 2).setValue(data1)
  return “Saved”;
  
}

function update(uid,new_value){

  var lr=sayfa.getLastRow();
  
  for(i=1;i
    var okunan=sayfa.getRange(i,1);
    var okunan_deger=okunan.getValue();
    var snc=okunan_deger.indexOf(uid);
    
    if(snc != -1){
      var secili_satir=sayfa.getRange(i,2).setValue(new_value);
    
    } 
  }
  return “Updated”;
}

function remove_row(uid){

var lr=sayfa.getLastRow();
  
  for(i=1;i
    var okunan=sayfa.getRange(i,1);
    var okunan_deger=okunan.getValue();
    var snc=okunan_deger.indexOf(uid);
    
    if(snc != -1){
     sayfa.deleteRow(i);
    
    } 
  }
  return “Removed”;
}

function test(){
  remove_row(“20125171339918788818”);
  

}

function uid(){

var dateObject = new Date();
     var uniqueId = 
          dateObject.getFullYear() + “ + 
          dateObject.getMonth() + ” + 
          dateObject.getDate() + “ + 
          dateObject.getTime();

     var uid=uniqueId.toString();
     return uid;

}

function delete_record(uid){
var lr=sayfa.getLastRow();
  
  for(i=1;i
    var okunan=sayfa.getRange(i,1);
    var okunan_deger=okunan.getValue();
    var snc=okunan_deger.indexOf(uid);
    
    if(snc != -1){
      var secili_satir=sayfa.getRange(i,2).setValue(“deleted”);
    
    } 
  }
}