Register and Login using Google sheets

Discuss
, , ,
11

I have reworked my example to hopefully make it easier. Try this:

function doGet(e) {
 
  var ss = SpreadsheetApp.openById('<sheetID>');
  var sheet = ss.getSheetByName("Logins"); 
  
  if ( e.parameter.func == "register" ) {
    var user = e.parameter.user ; 
    var passwd = e.parameter.passwd ;
    sheet.appendRow([user,passwd]);
    msg = "New User Added";
  } 
  
  else if ( e.parameter.func == "login" ) {
    var msg = "Incorrect Login";
    var user = e.parameter.user;
    var passwd = e.parameter.passwd;
    var loginData = sheet.getDataRange().getValues();
    for ( var i = 0; i < loginData.length; ++i ) {
      if ( user === loginData[i][0]  && passwd === loginData[i][1] ) {
        msg = "Logged In";
    }
  }
  }
  return ContentService.createTextOutput(msg);
}