Create and update multiple questions in a Google Form from Google Sheet data

12 Make multiple questions in a Google Form

function createFormFromData() {
  var sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
  
  //Get data, number of questions and options info
  var data = sh.getDataRange().getValues();
  var numOfOptions = data.length-3;
  var numOfQs = data[0].length;

  //Get questions
  var questions = sh.getRange(2, 2, 1, numOfQs).getValues();

  //Get options and store in an array
  var allOptions = [];
  for (q=2;q<=numOfQs;q++){
    var options = sh.getRange(3, q, numOfOptions, 1).getValues();
    allOptions.push(options);
  }

  //Create the form
  var form = FormApp.create("New form");
  
  //Add questions and options to form  
  for (qq=0;qq<numOfQs-1;qq++){
    var formQ = form.addMultipleChoiceItem();
    formQ.setTitle(questions[0][qq]);
    formQ.setChoiceValues(allOptions[qq]);
  }
}

function updateFormFromData() {
  var sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");
  
  //Get data, number of questions and options info
  var data = sh.getDataRange().getValues();
  var numOfOptions = data.length-3;
  var numOfQs = data[0].length;

  //Get questions
  var questions = sh.getRange(2, 2, 1, numOfQs).getValues();
  
  //Get options and store in an array
  var allOptions = [];
  for (q=2;q<=numOfQs;q++){
    var options = sh.getRange(3, q, numOfOptions, 1).getValues();
    allOptions.push(options);
  }
  
  //Get existing form
  var form = FormApp.openById('1sqVgGMdXIXPMLBtsR6zucsfKNRMD8HLYB3S9kn7On5s');
  var allItems = form.getItems();
  
  //Add questions and options to form  
  for (qq=0;qq<numOfQs-1;qq++){
    var formQ = allItems[qq].asMultipleChoiceItem();
    formQ.setTitle(questions[0][qq]);
    formQ.setChoiceValues(allOptions[qq]);
  }
}