javascript – What am I doing wrong, that my program is not working? Do not save or search for information?

// ******************************** HTML Call ************** ****************
doGet (e) {function
Logger.log (Utilities.jsonStringify (e))
if (! e.parameter.page) {
return HtmlService.createTemplateFromFile (& # 39; Index & # 39;). Assess ()
}
var template = HtmlService.createTemplateFromFile (e.parameter.page)
template.action = ScriptApp.getService (). getUrl ();
returns template.evaluate ();
}
// *************************** Look in the sheet ************* **** ***************************
searchReturnRow (sid) {function

var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
var numColumns = sheetData.getLastColumn ();
var ultimaFila = hojaDatos.getLastRow ();
var sw = 0;
var row = sheetDats.getRange (1, 1, lastFile, numColumns) .getValues ​​();

for (var i = 1; i <row.length; i ++) {
for (var col = 0; col <row[i]length; col ++) {
var id = row[i][2].toString ();
if (id == id) {
var index = i + 1;
sw = 1;
}
}
}
if (sw == 1) {
return index;
}
}
// ****************** Search for information and return to a specific column ****************** ****** ****
searchEnSheet function (sid, column) {

var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
var numColumns = sheetData.getLastColumn ();
var ultimaFila = hojaDatos.getLastRow ();
var sw = 0;
var row = sheetDats.getRange (1, 1, lastFile, numColumns) .getValues ​​();

for (var i = 1; i <row.length; i ++) {
for (var col = 0; col <row[i]length; col ++) {
var id = row[i][2].toString ();
if (id == id) {
var index = i + 1;
sw = 1;
}
}
}
if (sw == 1) {
var info = leafData.getRange (index, column) .getValue ();
return information;
}
}

// ********************** save the sheet data ***************** *** *********
function procesaFormClientes (e) {

var sEmpresa = e.empresa;
var sContato1 = e.contato1;
var sContato2 = e.contato2;
var sDepto = e.depto;
var sDepto2 = e.depto2;
var sEmail1 = e.email1;
var sEmail2 = e.email2;
var sTelefone1 = e.telefone1;
var sTelefone2 = e.telefone2;
var sEndereco = e.endereço;
var sContrato = e.contrato;
var sBairro = e.bairro;
var sIniciodoContrato = e.iniciodocontrato;
var sFimdoContrato = e.fimdocontrato;
var sCidade = e.cidade;
var sCEP = e.cep;
var sState = e.estado;
var sSegment = e.segment
var sSpress = e.spress
sPasta var = e.pasta

var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
var ultimaFila = hojaDatos.getLastRow ();


Datasheet.getRange (lastFile + 1, 1) .setValue (sEmpresa);
Datasheet.getRange (lastFile + 1, 2) .setValue (sContato1);
Datasheet.getRange (lastFile + 1, 3) .setValue (sContato2);
leafData.getRange (lastFile + 1, 4) .setValue (sDepto);
datasheet.getRange (lastFile + 1, 5) .setValue (sDepto2);
datasheet.getRange (lastFile + 1, 6) .setValue (sEmail1);
datasheet.getRange (lastFile + 1, 7) .setValue (sEmail2);
leafDats.getRange (lastFile + 1, 8) .setValue (sTelefone1);
leafData.getRange (lastFile + 1, 9) .setValue (sTelefone2);
Datasheet.getRange (lastFile + 1, 10) .setValue (sEndereco);
Datasheet.getRange (lastFile + 1, 11) .setValue (sContract);
leafData.getRange (lastFile + 1, 12) .setValue (sBairro);
datasheet.getRange (ultimaFila + 1, 13) .setValue (sIniciodoContrato);
datasheet.getRange (ultimaFila + 1, 14) .setValue (sFimdoContrato);
datasheet.getRange (lastFile + 1, 15) .setValue (sCidade);
datasheet.getRange (lastFile + 1, 16) .setValue (sCEP);
datasheet.getRange (lastFile + 1, 17) .setValue (sState);
Data sheet.getRange (lastFile + 1, 18) .setValue (sSegment);
Data sheet.getRange (lastFile + 1, 19) .setValue (sSpress);
datasheet.getRange (lastFile + 1, 20) .setValue (sPasta);
}

// *************************** The function returns data ************** ** *******************

// Find and return the value of the company

getEmpresaSS (e) {function
var sID = e.id;
returns searchEnSheet (sid, 1);
}

// Find and return the value of Contato1

function getContato1SS (e) {
var sID = e.id;
return searchEnSheet (sid, 2);
}

// Find and return the value of Contato2

function getContato2SS (e) {
var sID = e.id;
return searchEnSheet (sid, 3);
}

// Find and return the Depto value

getDeptoSS (e) function
var sID = e.id;
return searchEnSheet (sid, 4);
}

// Find and return the value of Depto2

getDepto2SS (e) {function
var sID = e.id;
return searchEnSheet (sid, 5);
}

// Find and return the value of Email1

getEmail1SS (e) {function
var sID = e.id;
return searchEnSheet (sId, 6);
}

// Find and return the value of Email2

getEmail2SS (e) {function
var sID = e.id;
return searchEnSheet (sId, 7);
}

// Find and return the value of Telefone1

getTelefone1SS (e) {function
var sID = e.id;
return searchEnSheet (sId, 8);
}

// Find and return the value of Telefone2

getTelefone2SS (e) {function
var sID = e.id;
return searchEnSheet (sId, 9);
}

// Find and return the value of Endereco

getEnderecoSS (e) {function
var sID = e.id;
return searchEnSheet (sId, 10);
}

// Search and return the value of the contract

function getContratoSS (e) {
var sID = e.id;
return searchEnSheet (sId, 11);
}

// Find and return the value of Bairro

function getBairroSS (e) {
var sID = e.id;
return searchEnSheet (sId, 12);
}

// Find and return the contract start value

function getIniciodoContratoSS (e) {
var sID = e.id;
return searchEnSheet (sId, 13);
}

// Find and return the value of Contract Fim

function getFimdoContratoSS (e) {
var sID = e.id;
return searchEnSheet (sid, 14);
}

// Find and return the value of Cidade

function getCidadeSS (e) {
var sID = e.id;
return searchEnSheet (sid, 15);
}

// Find and return the value of CEP

getCEPSS (e) {function
var sID = e.id;
return searchEnSheet (sid, 16);
}

// Find and return the value of the state

getEstadoSS (e) {function
var sID = e.id;
return searchEnSheet (sid, 17);
}

// Find and return the value of the segment

getSegmentoSS (e) {function
var sID = e.id;
return searchEnSheet (sid, 18);
}

// Find and return the value of Spress

getSepressSS (e) {function
var sID = e.id;
return searchEnSheet (sId, 19);
}
// Find and return the value of Pasta

getPastaSS (e) {function
var sID = e.id;
return searchEnSheet (sID, 20);
}



// change the informacao society
function SetEmpresaSS (e) {
var sEmpresa = e.empresa;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Datasheet.getRange (row, 1) .setValue (sBusiness);
}

function SetContato1SS (e) {
var sContato1 = e.contato1;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Datasheet.getRange (row, 2) .setValue (sContato1);
}

function SetContato2SS (e) {
var sContato2 = e.contato2;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Datasheet.getRange (row, 3) .setValue (sContato2);
}

SetDeptoSS (e) {function
var sDepto = e.depto;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 4) .setValue (sDepto);
}

function SetDepto2SS (e) {
var sDepto2 = e.depto2;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 5) .setValue (sDepto2);
}

function SetEmail1SS (e) {
var sEmail1 = e.email1;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Data sheet.getRange (row, 6) .setValue (sEmail1);
}

function SetEmail2SS (e) {
var sEmail2 = e.email2;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 7) .setValue (sEmail2);
}

function SetTelefone1SS (e) {
var sTelefone1 = e.telefone1;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Datasheet.getRange (row, 8) .setValue (sTelefone1);
}

function SetTelefone2SS (e) {
var sTelefone2 = e.telefone2;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Data sheet.getRange (line, 9) .setValue (sTelefone2);
}

SetEnderecoSS (e) {function
var sEndereco = e.endereco;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Datasheet.getRange (row, 10) .setValue (sEndereco);
}

SetContratoSS function (e) {
var sContrato = e.contrato;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 11) .setValue (sContract);
}

function SetBairroSS (e) {
var sBairro = e.bairro;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 12) .setValue (sBairro);
}

function SetIniciodoContratoSS (e) {
var sIniciodoContrato = e.iniciodoContract;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 13) .setValue (sConicioContrato);
}

SetFimdoContratoSS (e) {function
var sFimdoContrato = e.fimdoContrato;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Datasheet.getRange (row, 14) .setValue (sFrimContract);
}
SetCidadeSS (e) {function
var sCidade = e.cidade;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 15) .setValue (sCidade);
}

function SetCEPSS (e) {
var sCEP = e.cep;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 16) .setValue (sCEP);
}

SetEstadoSS function (e) {
var sState = e.estado;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
Datasheet.getRange (row, 17) .setValue (sState);
}

SetSegmentoSS (e) {function
var sSegment = e.segment;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 18) .setValue (sSegment);
}

SetSpressSS (e) {function
var sSpress = e.spress;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 19) .setValue (sSpress);
}
function SetPastaSS (e) {
var sSpress = e.spress;
var row = searchReturnRow (sId);
var sheetCalculus = SpreadsheetApp.openById ("12vFlDaG9ZGGa90EeyOLGyzO4xaxYs8lucgS-CdgJJsA");
var sheetData = sheetCalculated.getSheetByName (& # 39; Clients & # 39;);
datasheet.getRange (row, 20) .setValue (sPasta);
}


The