GASでスプレッドシートからGoogleフォームを手軽に作成

function フォーム作成() {

  var sheet = SpreadsheetApp.getActiveSheet();

  const AValues = sheet.getRange('A:A').getValues();　 //A列の値を全て取得
  //const LastRow = AValues.filter(String).length + 2;　　//空白の要素を除いた長さを取得
  var LastRow = 1000;

  var data = sheet.getRange(1,1,LastRow,100).getValues();
  var displayData = sheet.getRange(1,1,LastRow,100).getDisplayValues();

  const formTitle = data[0][1];
  const formDescription = data[1][1];

  var form = FormApp.create(formTitle);
  form.setDescription(formDescription);

  const lastRow = sheet.getLastRow();
  for(var i = 5; i <= lastRow; i++) {
    var questiontype = data[i][0];
    var question = data[i][1];
    var questiondescription = data[i][2];

    if (questiontype == "") {
      break;
    }
    if (questiontype == "短文記述") {
      var shortText = form.addTextItem().setTitle(question).setRequired(true);
      shortText.setHelpText(questiondescription);

      //入力規則を入力
      //正規表現
      if (data[i][4] != "") {
        var a = FormApp.createTextValidation().requireTextMatchesPattern(data[i][4]).build();
        //規則の反映
        shortText.setValidation(a);
        //違反時のアラート　うまくいかない
        //shortText.setValidation(a).setHelpText(data[i][5]);
      }
    } else if (questiontype == "段落記述") {
      form.addParagraphTextItem().setTitle(question).setRequired(true);

    } else if (questiontype == "セクション区切り") {
      form.addPageBreakItem().setTitle(question).setHelpText(questiondescription);

    } else if (questiontype == "説明テキスト") {
      form.addSectionHeaderItem().setTitle(question).setHelpText(questiondescription);

    } else if (questiontype == "ラジオボタン") {
      var choice = [];
      for(var k = 10; k <= 99; k++) {
        if (data[i][k] == "") {
          break;
        } else if (data[i][k] != "") {
          choice.push(data[i][k])
        }
      }
      var radiobutton = form.addMultipleChoiceItem()
        .setTitle(question)
        .setChoiceValues(choice)
        .setRequired(true);

      var choice = [];
      
    } else if (questiontype == "チェックボックス") {
      var choice = [];
      for(var k = 10; k <= 99; k++) {
        if (data[i][k] == "") {
          break;
        } else if (data[i][k] != "") {
          choice.push(data[i][k])
        }
      }
      var checkbox = form.addCheckboxItem()
        .setTitle(question)
        .setChoiceValues(choice)
        .setRequired(true);

      var choice = [];
    }
  }

  sheet.getRange(3,2,1,3).setValues(Array([form.getId(),form.getPublishedUrl(),form.shortenFormUrl(form.getPublishedUrl())]));

};