Kodlama ile Google Form oluşturmak

[farisakboga]

Google'nin spreadsheet'i ile excel'in kodlama dilleri birbirinden ne kadar farklı bilmiyorum ancak aşağıda verdiğim kodlarla otomatik kısa cevaplı ve çoktan seçmeli google form oluşturulabiliyor. Yalnız verdiğim kodlar sorulara kaç puan verdiğimizi ve doğru cevabı forma eklemiyor. Bu kodları belirttiğim değişiklikleri yapacak kabiliyete getirmek mümkün mü?

KOD:

function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1');
var range = ss.getDataRange();
var data = range.getValues();
var numberRows = range.getNumRows();
var numberColumns = range.getNumColumns();
var firstRow = 1;
var form = FormApp.openById('10ql_Cuk4xRF5-rQGHXWL6WwPQZmHQJ3oU9ckS_P8I8s');

for(var i=0;i<numberRows;i++){
var questionType = data[0];
if (questionType==''){
continue;
}
else if(questionType=='TEXT'){
form.addTextItem()
.setTitle(data[1])
.setHelpText(data[2])
.setRequired(true);
}
else if(questionType=='PARAGRAPH'){
form.addParagraphTextItem()
.setTitle(data[1])
.setHelpText(data[2])
.setRequired(true);
}
else if(questionType=='CHOICE'){
var rowLength = data.length;
var currentRow = firstRow+i;
var currentRangeValues = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(currentRow,1,1,rowLength).getValues();
var getSheetRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getDataRange();
var numberOfColumnsSheet = getSheetRange.getNumColumns();
var numberOfOptionsInCurrentRow = numberOfColumnsSheet;
var lastColumnInRange = String.fromCharCode(64 + (numberOfOptionsInCurrentRow));
var range_string = 'E' + currentRow + ":" + lastColumnInRange + currentRow;
var optionsArray = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(range_string).getValues();
var choicesForQuestion =[];
for (var j=0;j<optionsArray[0].length;j++){
choicesForQuestion.push(optionsArray[0][j]);
}
form.addMultipleChoiceItem()
.setTitle(data[1])
.setHelpText(data[2])
.setChoiceValues(choicesForQuestion)
.setRequired(true);
}
else if(questionType=='CHECKBOX'){
var rowLength = data.length;
var currentRow = firstRow+i;
var currentRangeValues = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(currentRow,1,1,rowLength).getValues();
var getSheetRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getDataRange();
var numberOfColumnsSheet = getSheetRange.getNumColumns();
var numberOfOptionsInCurrentRow = numberOfColumnsSheet;
var lastColumnInRange = String.fromCharCode(64 + (numberOfOptionsInCurrentRow));
var range_string = 'E' + currentRow + ":" + lastColumnInRange + currentRow;
var optionsArray = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(range_string).getValues();
var choicesForQuestion =[];
for (var j=0;j<optionsArray[0].length;j++){
choicesForQuestion.push(optionsArray[0][j]);
}
form.addCheckboxItem()
.setTitle(data[1])
.setHelpText(data[2])
.setChoiceValues(choicesForQuestion)
.setRequired(true);
}
else if(questionType=='LIST'){
var rowLength = data.length;
var currentRow = firstRow+i;
var currentRangeValues = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(currentRow,1,1,rowLength).getValues();
var getSheetRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getDataRange();
var numberOfColumnsSheet = getSheetRange.getNumColumns();
var numberOfOptionsInCurrentRow = numberOfColumnsSheet;
var lastColumnInRange = String.fromCharCode(64 + (numberOfOptionsInCurrentRow));
var range_string = 'E' + currentRow + ":" + lastColumnInRange + currentRow;
var optionsArray = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(range_string).getValues();
var choicesForQuestion =[];
for (var j=0;j<optionsArray[0].length;j++){
choicesForQuestion.push(optionsArray[0][j]);
}
form.addListItem()
.setTitle(data[1])
.setHelpText(data[2])
.setChoiceValues(choicesForQuestion)
.setRequired(true);
}
else if(questionType=='GRID'){
var rowLength = data.length;
var currentRow = firstRow+i;
var currentRangeValues = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(currentRow,1,1,rowLength).getValues();
var getSheetRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getDataRange();
var numberOfColumnsSheet = getSheetRange.getNumColumns();
var numberOfOptionsInCurrentRow = numberOfColumnsSheet;
var lastColumnInRange = String.fromCharCode(64 + (numberOfOptionsInCurrentRow));
var range_string = 'E' + currentRow + ":" + lastColumnInRange + currentRow;
var optionsArray = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(range_string).getValues();
var rowTitles =[];
for (var j=0;j<optionsArray[0].length;j++){
rowTitles.push(optionsArray[0][j]);
}
var rowLength = data[i+1].length;
var currentRow = firstRow+i+1;
var currentRangeValues = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(currentRow,1,1,rowLength).getValues();
var getSheetRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getDataRange();
var numberOfColumnsSheet = getSheetRange.getNumColumns();
var numberOfOptionsInCurrentRow = numberOfColumnsSheet;
var lastColumnInRange = String.fromCharCode(64 + (numberOfOptionsInCurrentRow));
var range_string = 'E' + currentRow + ":" + lastColumnInRange + currentRow;
var optionsArray = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sayfa1').getRange(range_string).getValues();
var columnTitles =[];
for (var j=0;j<optionsArray[0].length;j++){
columnTitles.push(optionsArray[0][j]);
}
form.addGridItem()
.setTitle(data[1])
.setHelpText(data[2])
.setRows(rowTitles)
.setColumns(columnTitles)
.setRequired(true);
}
else if(questionType=='IMAGE'){
var img = UrlFetchApp.fetch(data[3]);
form.addImageItem()
.setTitle(data[1])
.setHelpText(data[2])
.setImage(img);
}
else if(questionType=='PAGE'){
form.addPageBreakItem()
.setTitle(data[1])
.setHelpText(data[2]);
}
else if(questionType=='SECTION'){
form.addSectionHeaderItem()
.setTitle(data[1])
.setHelpText(data[2]);
}
else if(questionType=='TIME'){
form.addTimeItem()
.setTitle(data[1])
.setHelpText(data[2]);
}
else{
continue;
}
}
}