{"id":6728,"date":"2021-12-24T10:00:00","date_gmt":"2021-12-24T01:00:00","guid":{"rendered":"https:\/\/blog.synnex.co.jp\/?p=6728"},"modified":"2022-02-10T12:25:47","modified_gmt":"2022-02-10T03:25:47","slug":"gas-google-form-from-spreadsheet","status":"publish","type":"post","link":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/","title":{"rendered":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS"},"content":{"rendered":"\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u6982\u8981\">\u6982\u8981<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#%E6%A6%82%E8%A6%81\"><\/a><\/h2>\n\n\n\n<p>Google\u30d5\u30a9\u30fc\u30e0\u306e\u30c6\u30b9\u30c8\u6a5f\u80fd\u306f\u5404\u8cea\u554f\u306b\u914d\u70b9\u3084\u6b63\u89e3\u3084\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u3092\u8a2d\u5b9a\u3067\u304d\u3001\u81ea\u52d5\u3067\u63a1\u70b9\u3057\u3066\u304f\u308c\u308b\u3068\u3066\u3082\u4fbf\u5229\u306a\u6a5f\u80fd\u3067\u3059\u3002<br>\u3057\u304b\u3057\u3001\u3053\u306e\u30d5\u30a9\u30fc\u30e0\u3092\uff11\u3064\uff11\u3064\u4f5c\u308b\u306e\u306f\u306a\u304b\u306a\u304b\u5927\u5909\u306a\u4f5c\u696d\u3067\u3001\u554f\u984c\u6570\u304c\u591a\u3051\u308c\u3070\u591a\u3044\u307b\u3069\u8ca0\u62c5\u3082\u5897\u3057\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u554f\u984c\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u3066\u304a\u3051\u3070\u3001\u81ea\u52d5\u3067\u30c6\u30b9\u30c8\u7528\u306eGoogle\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3057\u3066\u304f\u308c\u308bGAS\u3092\u7d39\u4ecb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<br>\u203b\u4eca\u56de\u306e\u5185\u5bb9\u3067\u306f\u3001\u554f\u984c\u5f62\u5f0f\u306f\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3\uff08\u9078\u629e\u554f\u984c\uff09\u306e\u307f\u3067\u3059<\/p>\n\n\n\n<p>\u4f7f\u7528\u3059\u308bGAS\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u7b49\u306b\u7d10\u3065\u3044\u305f\u30bf\u30a4\u30d7\u306b\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<br>GAS\u306e\u6e96\u5099\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/jp.tdsynnex.com\/blog\/google\/sending-email-from-spreadsheet\/\">\u4ee5\u524d\u306e\u8a18\u4e8b<\/a>\u306e\u300c\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u7d10\u3065\u3044\u305fGAS\u306e\u4f5c\u6210\u65b9\u6cd5\u300d\u306e\u9805\u76ee\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u3078\u30c7\u30fc\u30bf\u5165\u529b\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u3078\u30c7\u30fc\u30bf\u5165\u529b<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%AE%E3%81%B8%E3%83%87%E3%83%BC%E3%82%BF%E5%85%A5%E5%8A%9B\"><\/a><\/h2>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3057\u3001\u30b7\u30fc\u30c8\u540d\u306f\u305d\u306e\u307e\u307e\u300c\u30b7\u30fc\u30c81\u300d\u3068\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"232\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/001_form-from-sheet-1024x232.png\" alt=\"\" class=\"wp-image-6730\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/001_form-from-sheet-1024x232.png 1024w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/001_form-from-sheet-300x68.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/001_form-from-sheet-768x174.png 768w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/001_form-from-sheet.png 1379w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"table table-striped\"><thead><tr><th>A\u5217<\/th><th>B\u5217<\/th><th>C\u5217<\/th><th>D\u5217<\/th><th>E\u5217<\/th><th>F\u5217<\/th><th>G\u5217<\/th><th>H\u5217<\/th><th>I\u5217<\/th><th>J\u5217<\/th><\/tr><\/thead><tbody><tr><td>\u30d5\u30a9\u30fc\u30e0\u30bf\u30a4\u30c8\u30eb<\/td><td>\u7406\u89e3\u5ea6\u30c6\u30b9\u30c8<\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><\/tr><tr><td>\u30d5\u30a9\u30fc\u30e0\u306e\u8aac\u660e\u6587<\/td><td>\u7c21\u5358\u306a\u7406\u89e3\u5ea6\u30c1\u30a7\u30c3\u30af\u306e\u30c6\u30b9\u30c8\u3067\u3059<\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><\/tr><tr><td>\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306eURL<\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><td><\/td><\/tr><tr><td>\u554f\u984c\u306e\u30bf\u30a4\u30c8\u30eb<\/td><td>\u554f\u984c\u306e\u8aac\u660e<\/td><td>\u914d\u70b9<\/td><td>\u554f\u984c\u5f62\u5f0f<\/td><td>\u6b63\u89e3\u306e\u756a\u53f7<\/td><td>\u9078\u629e\u80a2\u2460<\/td><td>\u9078\u629e\u80a2\u2461<\/td><td>\u9078\u629e\u80a2\u2462<\/td><td>\u9078\u629e\u80a2\u2463<\/td><td>\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\uff08\u7b54\u3048\u306e\u89e3\u8aac\u306a\u3069\uff09<\/td><\/tr><tr><td>\u554f\uff11\uff0eGAS\u306f\u4f55\u306e\u7565\u79f0\u304b<\/td><td>GAS\u306f\u4ee5\u4e0b\u306e\u3046\u3061\u3069\u308c\u306e\u7565\u79f0\u304b\u7b54\u3048\u3088\u3002<\/td><td>60<\/td><td>\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3<\/td><td>2<\/td><td>Google Apple System<\/td><td>Google Apps Script<\/td><td>Good Admin Script<\/td><td>Group Apply System<\/td><td>\u6b63\u89e3\u306fGoogle Apps Script\u3067\u3059\u3002<\/td><\/tr><tr><td>\u554f\uff12\uff0eGAS\u306e\u30d9\u30fc\u30b9\u8a00\u8a9e<\/td><td>GAS\u306e\u30d9\u30fc\u30b9\u306b\u306a\u3063\u3066\u3044\u308b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u306f\u4ee5\u4e0b\u306e\u3046\u3061\u3069\u308c\u304b\u3002<\/td><td>40<\/td><td>\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3<\/td><td>3<\/td><td>Python<\/td><td>Java<\/td><td>JavaScript<\/td><td>Go<\/td><td>\u6b63\u89e3\u306fJavaScript\u3067\u3059\u3002<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"gas\u306e\u4f5c\u6210\">GAS\u306e\u4f5c\u6210<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#gas%E3%81%AE%E4%BD%9C%E6%88%90\"><\/a><\/h2>\n\n\n\n<p>\u30b3\u30d4\u30da\u3067\u3059\u3050\u306b\u4f7f\u3044\u305f\u3044\u4eba\u5411\u3051\u306b\u3001\u4eca\u56de\u306e\u5b8c\u6210\u72b6\u614b\u306eGAS\u3092\u5148\u306b\u7d39\u4ecb\u3057\u3066\u304a\u304d\u307e\u3059\u3002<br>\u3053\u306e\u95a2\u6570<code>createForm()<\/code>\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u4f5c\u6210\u3057\u305f\u30dc\u30bf\u30f3\u306b\u5272\u308a\u5f53\u3066\u308b\u306a\u3069\u3059\u308c\u3070\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function createForm() {\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30b7\u30fc\u30c81&#39;);\n\n  const formTitle = sheet.getRange(&#39;B1&#39;).getDisplayValue();\n  const formDescription = sheet.getRange(&#39;B2&#39;).getDisplayValue();\n\n  const firstRow = 5;\n  const lastRow = sheet.getLastRow();\n\n  const dataRows = lastRow - (firstRow - 1);\n\n  var questionList = sheet.getRange(firstRow, 1, dataRows, 10).getDisplayValues();\n\n  questionList = questionList.map(question =&gt; {\n    return {\n      title: question[0],\n      helpText: question[1],\n      point: question[2],\n      type: question[3],\n      answer: Number(question[4]),\n      choices: [question[5], question[6], question[7], question[8]],\n      feedback: question[9]\n    }\n  });\n\n  const form = FormApp.create(formTitle);\n\n  form.setDescription(formDescription)\n    .setIsQuiz(true);\n\n\n  questionList.forEach(question =&gt; {\n\n    var item = form.addMultipleChoiceItem();\n\n    var choiceList = [];\n\n    question.choices.forEach((choice, index) =&gt; {\n\n      if (choice != &#39;&#39;) {\n\n        let isCorrect = question.answer == (index + 1);\n\n        let choiceObj = item.createChoice(choice, isCorrect);\n\n        choiceList.push(choiceObj);\n      }\n\n    });\n\n    const feedback = FormApp.createFeedback().setText(question.feedback).build()\n\n    item.setTitle(question.title)\n      .setHelpText(question.helpText)\n      .setPoints(question.point)\n      .setChoices(choiceList)\n      .setFeedbackForCorrect(feedback)\n      .setFeedbackForIncorrect(feedback);\n\n  });\n\n  sheet.getRange(&#39;B3&#39;).setValue(form.getEditUrl());\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u4ee5\u4e0b\u3067\u306f\u8a73\u3057\u304f\u7406\u89e3\u3057\u305f\u3044\u4eba\u5411\u3051\u306b\u3001\u30b3\u30fc\u30c9\u306e\u5185\u5bb9\u306b\u3064\u3044\u3066\u306e\u89e3\u8aac\u3092\u6bb5\u968e\u7684\u306b\u3057\u3066\u3044\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\">1. \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u306e\u53d6\u5f97<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#1-%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%8B%E3%82%89%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E5%8F%96%E5%BE%97\"><\/a><\/h3>\n\n\n\n<p>\u307e\u305a\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30d5\u30a9\u30fc\u30e0\u4f5c\u6210\u306b\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<br>\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas_get_and_write_data_of_spreadsheet\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function createForm() {\n  \/\/ \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068\u30b7\u30fc\u30c8\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30b7\u30fc\u30c81&#39;);\n\n  \/\/ \u30d5\u30a9\u30fc\u30e0\u306e\u30bf\u30a4\u30c8\u30eb\u3068\u8aac\u660e\u6587\u3092\u53d6\u5f97\n  const formTitle = sheet.getRange(&#39;B1&#39;).getDisplayValue();\n  const formDescription = sheet.getRange(&#39;B2&#39;).getDisplayValue();\n\n  \/\/ \u554f\u984c\u30ea\u30b9\u30c8\u306e\u6700\u521d\u306e\u884c(=firstRow =5\u884c\u76ee)\u3068\u3001\u6700\u7d42\u884c(=lastRow)\u3092\u53d6\u5f97\n  const firstRow = 5;\n  const lastRow = sheet.getLastRow();\n\n  \/\/ \u554f\u984c\u306e\u6570(\u884c\u6570)\u3092\u53d6\u5f97\n  \/\/ \u4f8b\uff1a9\u884c\u76ee\u307e\u3067\u554f\u984c\u304c\u3042\u3063\u305f\u5834\u5408\u30019 - (5 - 1) = 5\u554f\u5206\u306a\u306e\u3067dataRows = 5\u3068\u306a\u308b\n  const dataRows = lastRow - (firstRow - 1);\n\n  \/\/ \u554f\u984c\u306e\u30c7\u30fc\u30bf\u3092\u53d6\u5f97 getRange(\u6700\u521d\u306e\u884c, \u6700\u521d\u306e\u5217, \u884c\u6570, \u5217\u6570)\n  \/\/ \u6700\u521d\u306e\u884c\u306ffirstRow\u3001\u6700\u521d\u306e\u5217\u306fA\u5217\u306a\u306e\u3067\u300c1\u300d\u3001\u884c\u6570\u306fdataRows\u3001\u5217\u6570\u306fJ\u5217\u307e\u3067\u306a\u306e\u3067\u300c10\u300d\n  var questionList = sheet.getRange(firstRow, 1, dataRows, 10).getDisplayValues();\n\n  \/\/ \u5b9f\u884c\u30ed\u30b0\u306b\u53d6\u5f97\u3057\u305f\u5185\u5bb9\u3092\u8868\u793a\n  console.log(&#39;formTitle : &#39; + formTitle);\n  console.log(&#39;formDescription : &#39; + formDescription);\n  console.log(questionList);\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\uff1a<br>GAS\u306e\u5b9f\u884c\u30ed\u30b0\u306b\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"514\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/002_form-from-sheet.png\" alt=\"\" class=\"wp-image-6732\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/002_form-from-sheet.png 650w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/002_form-from-sheet-300x237.png 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-\u554f\u984c\u306e\u30c7\u30fc\u30bf\u306e\u6574\u5f62\">2. \u554f\u984c\u306e\u30c7\u30fc\u30bf\u306e\u6574\u5f62<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#2-%E5%95%8F%E9%A1%8C%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E6%95%B4%E5%BD%A2\"><\/a><\/h3>\n\n\n\n<p>\u554f\u984c\u306e\u30c7\u30fc\u30bf\u3092map\u51e6\u7406\u3092\u4f7f\u3063\u3066\u6574\u5f62\u3057\u307e\u3059\u3002<br>map\u51e6\u7406\u306b\u3064\u3044\u3066\u306f<a href=\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-invite-classroom-advanced-2\/\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u5185\u3067\u89e3\u8aac\u3057\u3066\u3044\u308b\u306e\u3067\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function createForm() {\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30b7\u30fc\u30c81&#39;);\n\n  const formTitle = sheet.getRange(&#39;B1&#39;).getDisplayValue();\n  const formDescription = sheet.getRange(&#39;B2&#39;).getDisplayValue();\n\n  const firstRow = 5;\n  const lastRow = sheet.getLastRow();\n\n  const dataRows = lastRow - (firstRow - 1);\n\n  var questionList = sheet.getRange(firstRow, 1, dataRows, 10).getDisplayValues();\n\n  \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u304b\u3089\n\n  \/\/ map\u51e6\u7406\u3067\u554f\u984c\u306e\u30c7\u30fc\u30bf\u3092\u6574\u5f62\n  \/\/ \u4eca\u56de\u306e\u30b3\u30fc\u30c9\u3067\u306f\u554f\u984c\u5f62\u5f0f(=type)\u306f\u4f7f\u7528\u3057\u307e\u305b\u3093\u304c\u4eca\u5f8c\u306e\u70ba\u306b\u5165\u308c\u3066\u3044\u307e\u3059\n  \/\/ \u6b63\u89e3\u306e\u756a\u53f7(=answer)\u306f\u6570\u5024\u578b\u30c7\u30fc\u30bf\u306b\u306a\u308b\u3088\u3046\u306b\u8abf\u6574\n  \/\/ \u9078\u629e\u80a2\u306f\u914d\u5217\u306e\u5f62\u306b\u3057\u30661\u3064\u306e\u9805\u76ee\u306b\u3057\u3066\u3044\u307e\u3059 \u203b[ \u9078\u629e\u80a2\u2460, \u9078\u629e\u80a2\u2461, \u9078\u629e\u80a2\u2462, \u9078\u629e\u80a2\u2463 ]\u3068\u3044\u3046\u914d\u5217\n  questionList = questionList.map(question =&gt; {\n    return {\n      title: question[0],\n      helpText: question[1],\n      point: question[2],\n      type: question[3],\n      answer: Number(question[4]),\n      choices: [question[5], question[6], question[7], question[8]],\n      feedback: question[9]\n    }\n  });\n\n  \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u307e\u3067\n\n  console.log(&#39;formTitle : &#39; + formTitle);\n  console.log(&#39;formDescription : &#39; + formDescription);\n  console.log(questionList);\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\uff1a<br>GAS\u306e\u5b9f\u884c\u30ed\u30b0\u306b\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092\u6574\u5f62\u3057\u305f\u3082\u306e\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"725\" height=\"485\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/003_form-from-sheet.png\" alt=\"\" class=\"wp-image-6733\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/003_form-from-sheet.png 725w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/003_form-from-sheet-300x201.png 300w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-\u30d5\u30a9\u30fc\u30e0\u306e\u4f5c\u6210\u3068\u8a2d\u5b9a\">3. \u30d5\u30a9\u30fc\u30e0\u306e\u4f5c\u6210\u3068\u8a2d\u5b9a<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#3-%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A0%E3%81%AE%E4%BD%9C%E6%88%90%E3%81%A8%E8%A8%AD%E5%AE%9A\"><\/a><\/h3>\n\n\n\n<p>\u307e\u305a\u306f\u30d5\u30a9\u30fc\u30e0\u81ea\u4f53\u3092\u4f5c\u6210\u3057\u3066\u3001\u30d5\u30a9\u30fc\u30e0\u306e\u8aac\u660e\u6587\u3068\u30c6\u30b9\u30c8\u306b\u3059\u308b\u3053\u3068\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br>\u3053\u306e\u6642\u70b9\u3067\u306f\u307e\u3060\u554f\u984c\u306f\u4f5c\u6210\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u3001\u7d20\u306e\u307e\u307e\u306e\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305f\u3001\u3053\u306e\u30b3\u30fc\u30c9\u4ee5\u964d\u306f\u5b9f\u884c\u3059\u308b\u305f\u3073\u306b\u65b0\u3057\u304f\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u5185\u5bb9\u3092\u5909\u3048\u3066\u8a66\u3059\u5834\u5408\u306f\u65b0\u3057\u304f\u4f5c\u3089\u308c\u305f\u30d5\u30a9\u30fc\u30e0\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u306b\u6c17\u3092\u4ed8\u3051\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function createForm() {\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30b7\u30fc\u30c81&#39;);\n\n  const formTitle = sheet.getRange(&#39;B1&#39;).getDisplayValue();\n  const formDescription = sheet.getRange(&#39;B2&#39;).getDisplayValue();\n\n  const firstRow = 5;\n  const lastRow = sheet.getLastRow();\n\n  const dataRows = lastRow - (firstRow - 1);\n\n  var questionList = sheet.getRange(firstRow, 1, dataRows, 10).getDisplayValues();\n\n  questionList = questionList.map(question =&gt; {\n    return {\n      title: question[0],\n      helpText: question[1],\n      point: question[2],\n      type: question[3],\n      answer: Number(question[4]),\n      choices: [question[5], question[6], question[7], question[8]],\n      feedback: question[9]\n    }\n  });\n\n  \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u304b\u3089\n\n  \/\/ \u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\n  const form = FormApp.create(formTitle);\n\n  \/\/ \u30d5\u30a9\u30fc\u30e0\u306b\u8aac\u660e\u6587\u3001\u30c6\u30b9\u30c8\u306b\u3059\u308b\u3053\u3068\u3092\u8a2d\u5b9a\n  form.setDescription(formDescription)\n    .setIsQuiz(true);\n\n  \/\/ \u5b9f\u884c\u30ed\u30b0\u306b\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u7528URL\u3092\u8868\u793a\n  console.log(form.getEditUrl())\n\n  \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u307e\u3067\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\uff1a<br>GAS\u306e\u5b9f\u884c\u30ed\u30b0\u306b\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u7528URL\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"831\" height=\"147\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/004_form-from-sheet.png\" alt=\"\" class=\"wp-image-6734\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/004_form-from-sheet.png 831w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/004_form-from-sheet-300x53.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/004_form-from-sheet-768x136.png 768w\" sizes=\"auto, (max-width: 831px) 100vw, 831px\" \/><\/figure>\n\n\n\n<p>\u3053\u306e\u7de8\u96c6\u7528URL\u3092\u958b\u304f\u3068\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br>\u4f5c\u6210\u3055\u308c\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u30bf\u30a4\u30c8\u30eb\u3084\u8aac\u660e\u6587\u304c\u6307\u5b9a\u306e\u3082\u306e\u306b\u306a\u3063\u3066\u3044\u3066\u3001\u8a2d\u5b9a\u30bf\u30d6\u306e\u300c\u30c6\u30b9\u30c8\u306b\u3059\u308b\u300d\u304cON\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"950\" height=\"394\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/005_form-from-sheet.png\" alt=\"\" class=\"wp-image-6735\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/005_form-from-sheet.png 950w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/005_form-from-sheet-300x124.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/005_form-from-sheet-768x319.png 768w\" sizes=\"auto, (max-width: 950px) 100vw, 950px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"300\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/006_form-from-sheet.png\" alt=\"\" class=\"wp-image-6736\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/006_form-from-sheet.png 936w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/006_form-from-sheet-300x96.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/006_form-from-sheet-768x246.png 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4-\u554f\u984c\u306e\u4f5c\u6210\u3068\u9078\u629e\u80a2\u306e\u8ffd\u52a0\">4. \u554f\u984c\u306e\u4f5c\u6210\u3068\u9078\u629e\u80a2\u306e\u8ffd\u52a0<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#4-%E5%95%8F%E9%A1%8C%E3%81%AE%E4%BD%9C%E6%88%90%E3%81%A8%E9%81%B8%E6%8A%9E%E8%82%A2%E3%81%AE%E8%BF%BD%E5%8A%A0\"><\/a><\/h3>\n\n\n\n<p>\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306b\u554f\u984c\u30921\u554f\u305a\u3064\u8ffd\u52a0\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br>\u4eca\u56de\u306f\u9078\u629e\u80a2\u554f\u984c\uff08\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3\uff09\u306e\u307f\u5bfe\u5fdc\u3057\u3066\u3044\u308b\u306e\u3067<code>.addMultipleChoiceItem()<\/code>\u3067\u554f\u984c\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u554f\u984c\u3092\u8ffd\u52a0\u3059\u308b\u3068\u3001\u305d\u306e\u8fd4\u308a\u5024\u3068\u3057\u3066\u300c\u554f\u984c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8(MultipleChoiceItem\u30aa\u30d6\u30b8\u30a7\u30af\u30c8)\u300d\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>\u624b\u9806\u3068\u3057\u3066\u3001\u3053\u306e\u300c\u554f\u984c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u300d\u306b\u9078\u629e\u80a2\u3092\u4f5c\u6210\u3057\u3066\u3001\u30ea\u30b9\u30c8(\u914d\u5217)\u306e\u5f62\u3067\u8a2d\u5b9a\u3057\u3066\u3042\u3052\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br>\u6d41\u308c\u3092\u6574\u7406\u3059\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><code>\u554f\u984c(item)<\/code>\u3092\u4f5c\u6210<\/li><li>\u4f5c\u6210\u3057\u305f<code>\u554f\u984c(item)<\/code>\u306b<code>\u9078\u629e\u80a2(choiceObj)<\/code>\u3092\u4f5c\u6210<\/li><li>\u4f5c\u6210\u3057\u305f<code>\u9078\u629e\u80a2(choiceObj)<\/code>\u3092\u914d\u5217\u306e\u5f62\u306b\u3059\u308b<\/li><li>\u914d\u5217\u306b\u3057\u305f<code>\u9078\u629e\u80a2(choiceObj)<\/code>\u3092<code>\u554f\u984c(item)<\/code>\u306b\u8a2d\u5b9a<\/li><\/ol>\n\n\n\n<p>\u3053\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u524d\u9805\u3068\u306f\u5225\u306b\u65b0\u3057\u304f\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u524d\u9805\u3067\u958b\u3044\u305f\u30d5\u30a9\u30fc\u30e0\u3067\u306f\u306a\u304f\u5b9f\u884c\u30ed\u30b0\u306b\u8868\u793a\u3055\u308c\u305f\u65b0\u3057\u3044URL\u306e\u30d5\u30a9\u30fc\u30e0\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u306b\u6c17\u3092\u4ed8\u3051\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function createForm() {\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30b7\u30fc\u30c81&#39;);\n\n  const formTitle = sheet.getRange(&#39;B1&#39;).getDisplayValue();\n  const formDescription = sheet.getRange(&#39;B2&#39;).getDisplayValue();\n\n  const firstRow = 5;\n  const lastRow = sheet.getLastRow();\n\n  const dataRows = lastRow - (firstRow - 1);\n\n  var questionList = sheet.getRange(firstRow, 1, dataRows, 10).getDisplayValues();\n\n  questionList = questionList.map(question =&gt; {\n    return {\n      title: question[0],\n      helpText: question[1],\n      point: question[2],\n      type: question[3],\n      answer: Number(question[4]),\n      choices: [question[5], question[6], question[7], question[8]],\n      feedback: question[9]\n    }\n  });\n\n  const form = FormApp.create(formTitle);\n\n  form.setDescription(formDescription)\n    .setIsQuiz(true);\n\n  console.log(form.getEditUrl())\n\n  \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u304b\u3089\n\n  \/\/ \u554f\u984c\u30921\u3064\u305a\u3064\u4f5c\u6210\n  questionList.forEach(question =&gt; {\n\n    \/\/ \u9078\u629e\u80a2\u554f\u984c(\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3)\u3092\u4f5c\u6210\n    var item = form.addMultipleChoiceItem();\n\n    \/\/ \u9078\u629e\u80a2\u30ea\u30b9\u30c8\u306e\u67a0\u3092\u4f5c\u6210\n    var choiceList = [];\n\n    \/\/ \u9078\u629e\u80a2\u30c7\u30fc\u30bf\uff08question.choices\uff09\u3092forEach\u30671\u3064\u305a\u3064\u51e6\u7406\n    question.choices.forEach((choice, index) =&gt; {\n\n      \/\/ \u9078\u629e\u80a2\u304c\u7a7a\u767d\u3067\u306f\u306a\u3044\u5834\u5408\u306f\u4ee5\u964d\u3092\u5b9f\u884c\n      \/\/ \u203b\u9078\u629e\u80a2\u304c\u7a7a\u767d = \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u9078\u629e\u80a2\u306e\u30bb\u30eb\u306b\u4f55\u3082\u5165\u529b\u3055\u308c\u3066\u3044\u306a\u3044 = \u9078\u629e\u80a2\u306e\u6570\u304c4\u3064\u672a\u6e80 \u306e\u5834\u5408\u3001\u7a7a\u306e\u9078\u629e\u80a2\u3092\u8ffd\u52a0\u3057\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\n      if (choice != &#39;&#39;) {\n\n        \/\/ \u3053\u306e\u9078\u629e\u80a2\u304c\u6b63\u89e3\u304b\u3069\u3046\u304b\u30c1\u30a7\u30c3\u30af\n        \/\/ index\u306f\u3053\u306e\u9078\u629e\u80a2\u304c\u4f55\u756a\u76ee\u306e\u9078\u629e\u80a2\u304b\u3092\u793a\u3057\u307e\u3059\uff081\u3064\u76ee\u306e\u9078\u629e\u80a2\u306a\u3089\u300c0\u300d\u30012\u3064\u76ee\u306e\u9078\u629e\u80a2\u306a\u3089\u300c1\u300d\u2026\uff09\n        \/\/ (index + 1)\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u3067\u6307\u5b9a\u3057\u305f\u6b63\u89e3\u306e\u756a\u53f7\u3068\u4e00\u81f4\u3059\u308b\u304b\u3092\u30c1\u30a7\u30c3\u30af\n        \/\/ \u6b63\u89e3\u306e\u5834\u5408\uff1aisCorrect = TRUE\u3001\u4e0d\u6b63\u89e3\u306e\u5834\u5408\uff1aisCorrect = FALSE\n        let isCorrect = question.answer == (index + 1);\n\n        \/\/ \u9078\u629e\u80a2\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\n        \/\/ createChoice(\u9078\u629e\u80a2\u306e\u5185\u5bb9, \u6b63\u89e3\u306e\u9078\u629e\u80a2\u306a\u3089TRUE\uff0f\u4e0d\u6b63\u89e3\u306e\u9078\u629e\u80a2\u306a\u3089FALSE)\n        let choiceObj = item.createChoice(choice, isCorrect);\n\n        \/\/ \u9078\u629e\u80a2\u30ea\u30b9\u30c8\u306b\u9078\u629e\u80a2\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8ffd\u52a0\n        choiceList.push(choiceObj);\n      }\n\n    });\n\n    \/\/ \u554f\u984c\u306b\u9078\u629e\u80a2\u30ea\u30b9\u30c8\u3092\u8a2d\u5b9a\n    item.setChoices(choiceList);\n\n  });\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\uff1a<br>GAS\u306e\u5b9f\u884c\u30ed\u30b0\u306b\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u7528URL\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"814\" height=\"147\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/007_form-from-sheet.png\" alt=\"\" class=\"wp-image-6737\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/007_form-from-sheet.png 814w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/007_form-from-sheet-300x54.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/007_form-from-sheet-768x139.png 768w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><\/figure>\n\n\n\n<p>\u3053\u306e\u7de8\u96c6\u7528URL\u3092\u958b\u304f\u3068\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br>\u4f5c\u6210\u3055\u308c\u305f\u30d5\u30a9\u30fc\u30e0\u306b\u554f\u984c\u3068\u9078\u629e\u80a2\u3001\u89e3\u7b54\u96c6\u306b\u6b63\u89e3\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"951\" height=\"844\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/008_form-from-sheet.png\" alt=\"\" class=\"wp-image-6738\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/008_form-from-sheet.png 951w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/008_form-from-sheet-300x266.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/008_form-from-sheet-768x682.png 768w\" sizes=\"auto, (max-width: 951px) 100vw, 951px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"890\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/009_form-from-sheet.png\" alt=\"\" class=\"wp-image-6739\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/009_form-from-sheet.png 796w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/009_form-from-sheet-268x300.png 268w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/009_form-from-sheet-768x859.png 768w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5-\u554f\u984c\u306e\u8a2d\u5b9a\">5. \u554f\u984c\u306e\u8a2d\u5b9a<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#5-%E5%95%8F%E9%A1%8C%E3%81%AE%E8%A8%AD%E5%AE%9A\"><\/a><\/h3>\n\n\n\n<p>\u4f5c\u6210\u3057\u305f\u554f\u984c\u306b\u306f\u307e\u3060\u554f\u984c\u306e\u30bf\u30a4\u30c8\u30eb\u3084\u8aac\u660e\u3001\u914d\u70b9\u3001\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002<br>\u305d\u308c\u305e\u308c\u307e\u3068\u3081\u3066\u8a2d\u5b9a\u3057\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u305d\u306e\u969b\u3001\u524d\u9805\u3067\u8a2d\u5b9a\u3057\u305f\u9078\u629e\u80a2\u30ea\u30b9\u30c8\u3082\u5408\u308f\u305b\u3066\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u306e\u8a2d\u5b9a\u3067\u306f\u3001\u307e\u305a\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u3066\u3001\u305d\u308c\u3092\u6b63\u89e3\u4e0d\u6b63\u89e3\u3054\u3068\u306b\u8a2d\u5b9a\u3057\u3066\u3042\u3052\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br>\u305f\u3060\u3057\u4eca\u56de\u306f\u6b63\u89e3\u306e\u5834\u5408\u3082\u4e0d\u6b63\u89e3\u306e\u5834\u5408\u3082\u540c\u3058\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u524d\u9805\u3068\u306f\u5225\u306b\u65b0\u3057\u304f\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u524d\u9805\u3067\u958b\u3044\u305f\u30d5\u30a9\u30fc\u30e0\u3067\u306f\u306a\u304f\u5b9f\u884c\u30ed\u30b0\u306b\u8868\u793a\u3055\u308c\u305f\u65b0\u3057\u3044URL\u306e\u30d5\u30a9\u30fc\u30e0\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u306b\u6c17\u3092\u4ed8\u3051\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function createForm() {\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30b7\u30fc\u30c81&#39;);\n\n  const formTitle = sheet.getRange(&#39;B1&#39;).getDisplayValue();\n  const formDescription = sheet.getRange(&#39;B2&#39;).getDisplayValue();\n\n  const firstRow = 5;\n  const lastRow = sheet.getLastRow();\n\n  const dataRows = lastRow - (firstRow - 1);\n\n  var questionList = sheet.getRange(firstRow, 1, dataRows, 10).getDisplayValues();\n\n  questionList = questionList.map(question =&gt; {\n    return {\n      title: question[0],\n      helpText: question[1],\n      point: question[2],\n      type: question[3],\n      answer: Number(question[4]),\n      choices: [question[5], question[6], question[7], question[8]],\n      feedback: question[9]\n    }\n  });\n\n  const form = FormApp.create(formTitle);\n\n  form.setDescription(formDescription)\n    .setIsQuiz(true);\n\n  console.log(form.getEditUrl())\n\n  questionList.forEach(question =&gt; {\n\n    var item = form.addMultipleChoiceItem();\n\n    var choiceList = [];\n\n    question.choices.forEach((choice, index) =&gt; {\n\n      if (choice != &#39;&#39;) {\n\n        let isCorrect = question.answer == (index + 1);\n\n        let choiceObj = item.createChoice(choice, isCorrect);\n\n        choiceList.push(choiceObj);\n      }\n\n    });\n\n    \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u304b\u3089\n\n    \/\/ \u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\n    let feedback = FormApp.createFeedback().setText(question.feedback).build()\n\n    \/\/ \u554f\u984c\u306e\u30bf\u30a4\u30c8\u30eb\u3001\u8aac\u660e\u3001\u914d\u70b9\u3001\u9078\u629e\u80a2\u30ea\u30b9\u30c8\u3001\u56de\u7b54\u306b\u5bfe\u3059\u308b\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u3092\u8a2d\u5b9a\n    item.setTitle(question.title)\n      .setHelpText(question.helpText)\n      .setPoints(question.point)\n      .setChoices(choiceList)\n      .setFeedbackForCorrect(feedback)\n      .setFeedbackForIncorrect(feedback);\n\n    \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u307e\u3067\n\n  });\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\uff1a<br>GAS\u306e\u5b9f\u884c\u30ed\u30b0\u306b\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u7528URL\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"146\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/010_form-from-sheet.png\" alt=\"\" class=\"wp-image-6740\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/010_form-from-sheet.png 809w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/010_form-from-sheet-300x54.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/010_form-from-sheet-768x139.png 768w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><\/figure>\n\n\n\n<p>\u3053\u306e\u7de8\u96c6\u7528URL\u3092\u958b\u304f\u3068\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br>\u4f5c\u6210\u3055\u308c\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u554f\u984c\u306b\u30bf\u30a4\u30c8\u30eb\u3068\u8aac\u660e\u3001\u914d\u70b9\u3001\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"900\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/011_form-from-sheet.png\" alt=\"\" class=\"wp-image-6741\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/011_form-from-sheet.png 924w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/011_form-from-sheet-300x292.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/011_form-from-sheet-768x748.png 768w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"626\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/012_form-from-sheet.png\" alt=\"\" class=\"wp-image-6742\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/012_form-from-sheet.png 783w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/012_form-from-sheet-300x240.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/012_form-from-sheet-768x614.png 768w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6-\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30dc\u30bf\u30f3\u8ffd\u52a0\u3068url\u306e\u66f8\u304d\u8fbc\u307f\">6. \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u30dc\u30bf\u30f3\u8ffd\u52a0\u3068URL\u306e\u66f8\u304d\u8fbc\u307f<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#6-%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%AB%E3%83%9C%E3%82%BF%E3%83%B3%E8%BF%BD%E5%8A%A0%E3%81%A8url%E3%81%AE%E6%9B%B8%E3%81%8D%E8%BE%BC%E3%81%BF\"><\/a><\/h3>\n\n\n\n<p>\u30d5\u30a9\u30fc\u30e0\u4f5c\u6210\u81ea\u4f53\u306f\u3053\u3053\u307e\u3067\u3067\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3057\u304b\u3057\u3053\u306e\u307e\u307e\u3060\u3068\u5b9f\u884c\u3059\u308b\u305f\u3081\u306b\u6bce\u5ea6GAS\u3092\u958b\u304f\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u5b9f\u884c\u7528\u306e\u30dc\u30bf\u30f3\u3092\u8a2d\u7f6e\u3057\u307e\u3059\u3002<br>\u3042\u308f\u305b\u3066\u3001\u5b8c\u4e86\u6642\u306b\u30d5\u30a9\u30fc\u30e0\u4f5c\u6210\u304c\u5b8c\u4e86\u3057\u305f\u3053\u3068\u304c\u308f\u304b\u308b\u3088\u3046\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u3092\u8868\u793a\u3057\u3001\u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306eURL\u3092B3\u30bb\u30eb\u306b\u66f8\u304d\u8fbc\u3093\u3067\u304a\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u5b9f\u884c\u7528\u306e\u30dc\u30bf\u30f3\u3092\u8a2d\u7f6e\u3057\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5272\u308a\u5f53\u3066\u307e\u3059\u3002<br>\u30dc\u30bf\u30f3\u4f5c\u6210\u306e\u8a73\u7d30\u624b\u9806\u306f<a href=\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-invite-classroom-advanced\/\">\u3053\u3061\u3089\u306e\u8a18\u4e8b<\/a>\u5185\u306e\u8aac\u660e\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"629\" height=\"159\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/013_form-from-sheet.png\" alt=\"\" class=\"wp-image-6743\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/013_form-from-sheet.png 629w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/013_form-from-sheet-300x76.png 300w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"402\" height=\"254\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/014_form-from-sheet.png\" alt=\"\" class=\"wp-image-6744\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/014_form-from-sheet.png 402w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/014_form-from-sheet-300x190.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/figure>\n\n\n\n<p>\u307e\u305f\u3001\u3053\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u524d\u9805\u3068\u306f\u5225\u306b\u65b0\u3057\u304f\u30d5\u30a9\u30fc\u30e0\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u524d\u9805\u3067\u958b\u3044\u305f\u30d5\u30a9\u30fc\u30e0\u3067\u306f\u306a\u304f\u5b9f\u884c\u30ed\u30b0\u307e\u305f\u306fB3\u30bb\u30eb\u306b\u8868\u793a\u3055\u308c\u305f\u65b0\u3057\u3044URL\u306e\u30d5\u30a9\u30fc\u30e0\u3092\u78ba\u8a8d\u3059\u308b\u3088\u3046\u306b\u6c17\u3092\u4ed8\u3051\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism undefined-numbers lang-js\" data-lang=\"JavaScript\"><code>function createForm() {\n  const ss = SpreadsheetApp.getActiveSpreadsheet();\n  const sheet = ss.getSheetByName(&#39;\u30b7\u30fc\u30c81&#39;);\n\n  const formTitle = sheet.getRange(&#39;B1&#39;).getDisplayValue();\n  const formDescription = sheet.getRange(&#39;B2&#39;).getDisplayValue();\n\n  const firstRow = 5;\n  const lastRow = sheet.getLastRow();\n\n  const dataRows = lastRow - (firstRow - 1);\n\n  var questionList = sheet.getRange(firstRow, 1, dataRows, 10).getDisplayValues();\n\n  questionList = questionList.map(question =&gt; {\n    return {\n      title: question[0],\n      helpText: question[1],\n      point: question[2],\n      type: question[3],\n      answer: Number(question[4]),\n      choices: [question[5], question[6], question[7], question[8]],\n      feedback: question[9]\n    }\n  });\n\n  const form = FormApp.create(formTitle);\n\n  form.setDescription(formDescription)\n    .setIsQuiz(true);\n\n  console.log(form.getEditUrl())\n\n  questionList.forEach(question =&gt; {\n\n    var item = form.addMultipleChoiceItem();\n\n    var choiceList = [];\n\n    question.choices.forEach((choice, index) =&gt; {\n\n      if (choice != &#39;&#39;) {\n\n        let isCorrect = question.answer == (index + 1);\n\n        let choiceObj = item.createChoice(choice, isCorrect);\n\n        choiceList.push(choiceObj);\n      }\n\n    });\n\n    let feedback = FormApp.createFeedback().setText(question.feedback).build()\n\n    item.setTitle(question.title)\n      .setHelpText(question.helpText)\n      .setPoints(question.point)\n      .setChoices(choiceList)\n      .setFeedbackForCorrect(feedback)\n      .setFeedbackForIncorrect(feedback);\n\n  });\n\n  \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u304b\u3089\n\n  \/\/ \u4f5c\u6210\u3057\u305f\u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u7528URL\u3092B3\u30bb\u30eb\u306b\u66f8\u304d\u8fbc\u307f\n  sheet.getRange(&#39;B3&#39;).setValue(form.getEditUrl());\n\n  \/\/ \u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u306e\u8868\u793a\n  Browser.msgBox(&#39;\u300c&#39; + formTitle + &#39;\u300d\u306e\u4f5c\u6210\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f&#39;);\n\n  \/\/ \u8ffd\u52a0\u90e8\u3053\u3053\u307e\u3067\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u7d50\u679c\uff1a<br>\u5b9f\u884c\u7528\u30dc\u30bf\u30f3\u304b\u3089\u5b9f\u884c\u3059\u308b\u3068\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u304c\u8868\u793a\u3055\u308c\u3001B3\u30bb\u30eb\u306b\u30d5\u30a9\u30fc\u30e0\u306e\u7de8\u96c6\u7528URL\u304c\u66f8\u304d\u8fbc\u307e\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"203\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/015_form-from-sheet.png\" alt=\"\" class=\"wp-image-6745\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/015_form-from-sheet.png 397w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/015_form-from-sheet-300x153.png 300w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"815\" height=\"188\" src=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/016_form-from-sheet.png\" alt=\"\" class=\"wp-image-6746\" srcset=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/016_form-from-sheet.png 815w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/016_form-from-sheet-300x69.png 300w, https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/016_form-from-sheet-768x177.png 768w\" sizes=\"auto, (max-width: 815px) 100vw, 815px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u307e\u3068\u3081\">\u307e\u3068\u3081<a href=\"https:\/\/fg-syn-blog.appspot.com\/development\/1_gas\/form-from-sheet.html#%E3%81%BE%E3%81%A8%E3%82%81\"><\/a><\/h2>\n\n\n\n<p>\u4eca\u56de\u306f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u5185\u5bb9\u3067\u306f\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3\u306e\u9078\u629e\u554f\u984c\u306e\u307f\u306e\u30c6\u30b9\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u304c\u3001Google\u30d5\u30a9\u30fc\u30e0\u3067\u306f\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3084\u8a18\u8ff0\u5f0f\u306e\u554f\u984c\u3082\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<br>\u4ed6\u306e\u554f\u984c\u5f62\u5f0f\u306b\u3082\u5bfe\u5fdc\u3059\u308b\u65b9\u6cd5\u3082\u4eca\u5f8c\u3054\u7d39\u4ecb\u3059\u308b\u4e88\u5b9a\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u306f\u6559\u80b2\u30b5\u30fc\u30d3\u30b9\u306eGoogle Classroom\u306a\u3069\u306b\u3046\u3063\u3066\u3064\u3051\u306e\u3068\u3066\u3082\u4fbf\u5229\u306a\u6a5f\u80fd\u3067\u3059\u3002<br>Google Classroom\u3067\u6d3b\u7528\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u306e\u81ea\u52d5\u751f\u6210\u306b\u3064\u3044\u3066\u3082\u3044\u305a\u308c\u306f\u7d39\u4ecb\u3057\u3066\u3044\u3051\u305f\u3089\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"p-3 mb-4 bg-light rounded-3\">    <div class=\"container-fluid\">\n      <h4 class=\"display-6 fw-bold\"><span id=\"Google_workspace\">Google Cloud\u306e\u5c0e\u5165\u306f\u5f53\u793e\u306b\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044<\/span><\/h4>\n      <p class=\"col-md-12\">IT\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30bf\u30fc\u3067\u3042\u308bTD SYNNEX\u306fGoogle Cloud\u2122 Partner Award \u3092\u53d7\u8cde\u3059\u308b\u306a\u3069\u3001\u9577\u5e74\u306b\u308f\u305f\u308aGoogle\u2122\u306e\u30b0\u30ed\u30fc\u30d0\u30eb\u8a8d\u5b9a\u30c7\u30a3\u30b9\u30c8\u30ea\u30d3\u30e5\u30fc\u30bf\u30fc\u3068\u3057\u3066\u3001\u7dcf\u5408\u7684\u306a Google\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u304a\u5ba2\u69d8\u306b\u3068\u3063\u3066\u6700\u9069\u306a\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u306e\u63d0\u6848\u3084\u5c0e\u5165\u3001\u6d3b\u7528\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/p>\n      <a href=\"https:\/\/www.synnex.co.jp\/vender\/google\/inquiry\/\"><button class=\"btn btn-primary btn-lg\" type=\"button\">\u304a\u554f\u3044\u5408\u308f\u305b<\/button><\/a>\n    <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u6982\u8981 Google\u30d5\u30a9\u30fc\u30e0\u306e\u30c6\u30b9\u30c8\u6a5f\u80fd\u306f\u5404\u8cea\u554f\u306b\u914d\u70b9\u3084\u6b63\u89e3\u3084\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af\u3092\u8a2d\u5b9a\u3067\u304d\u3001\u81ea\u52d5\u3067\u63a1\u70b9\u3057\u3066\u304f\u308c\u308b\u3068\u3066\u3082\u4fbf&#8230;<\/p>\n","protected":false},"author":1,"featured_media":6748,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[169],"tags":[161],"class_list":["post-6728","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google","tag-gas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS &#8211; TD SYNNEX BLOG<\/title>\n<meta name=\"description\" content=\"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001GoogleAppsScript\uff08GAS\uff09\u3092\u7528\u3044\u3066\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u306a\u304c\u3089\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS &#8211; TD SYNNEX BLOG\" \/>\n<meta property=\"og:description\" content=\"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001GoogleAppsScript\uff08GAS\uff09\u3092\u7528\u3044\u3066\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u306a\u304c\u3089\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"TD SYNNEX BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-24T01:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-10T03:25:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"973\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"TD SYNNEX K.K.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"TD SYNNEX K.K.\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/\",\"url\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/\",\"name\":\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS &#8211; TD SYNNEX BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg\",\"datePublished\":\"2021-12-24T01:00:00+00:00\",\"dateModified\":\"2022-02-10T03:25:47+00:00\",\"author\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/001c8dcd84e98df520975ae4cfe82053\"},\"description\":\"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001GoogleAppsScript\uff08GAS\uff09\u3092\u7528\u3044\u3066\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u306a\u304c\u3089\u8aac\u660e\u3057\u307e\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#primaryimage\",\"url\":\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg\",\"contentUrl\":\"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg\",\"width\":2000,\"height\":973},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/jp.tdsynnex.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google\",\"item\":\"https:\/\/jp.tdsynnex.com\/blog\/category\/google\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#website\",\"url\":\"https:\/\/jp.tdsynnex.com\/blog\/\",\"name\":\"TD SYNNEX BLOG\",\"description\":\"IT\u5c02\u9580\u5546\u793e\u304c\u5c4a\u3051\u308b\u60c5\u5831\u30e1\u30c7\u30a3\u30a2\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jp.tdsynnex.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/001c8dcd84e98df520975ae4cfe82053\",\"name\":\"TD SYNNEX K.K.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a8f5827738602e2a74ad1b31e261ecc21785df535840a4363d1eb974fc63b3a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a8f5827738602e2a74ad1b31e261ecc21785df535840a4363d1eb974fc63b3a6?s=96&d=mm&r=g\",\"caption\":\"TD SYNNEX K.K.\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS &#8211; TD SYNNEX BLOG","description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001GoogleAppsScript\uff08GAS\uff09\u3092\u7528\u3044\u3066\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u306a\u304c\u3089\u8aac\u660e\u3057\u307e\u3059\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/","og_locale":"ja_JP","og_type":"article","og_title":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS &#8211; TD SYNNEX BLOG","og_description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001GoogleAppsScript\uff08GAS\uff09\u3092\u7528\u3044\u3066\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u306a\u304c\u3089\u8aac\u660e\u3057\u307e\u3059\u3002","og_url":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/","og_site_name":"TD SYNNEX BLOG","article_published_time":"2021-12-24T01:00:00+00:00","article_modified_time":"2022-02-10T03:25:47+00:00","og_image":[{"width":2000,"height":973,"url":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg","type":"image\/jpeg"}],"author":"TD SYNNEX K.K.","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"TD SYNNEX K.K.","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"8\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/","url":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/","name":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS &#8211; TD SYNNEX BLOG","isPartOf":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#primaryimage"},"image":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#primaryimage"},"thumbnailUrl":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg","datePublished":"2021-12-24T01:00:00+00:00","dateModified":"2022-02-10T03:25:47+00:00","author":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/001c8dcd84e98df520975ae4cfe82053"},"description":"\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001GoogleAppsScript\uff08GAS\uff09\u3092\u7528\u3044\u3066\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u63a1\u70b9\u7b49\u304c\u3067\u304d\u308b\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3057\u306a\u304c\u3089\u8aac\u660e\u3057\u307e\u3059\u3002","breadcrumb":{"@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#primaryimage","url":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg","contentUrl":"https:\/\/jp.tdsynnex.com\/blog\/wp-content\/uploads\/2021\/12\/AdobeStock_93839373-1.jpg","width":2000,"height":973},{"@type":"BreadcrumbList","@id":"https:\/\/jp.tdsynnex.com\/blog\/google\/gas-google-form-from-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/jp.tdsynnex.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Google","item":"https:\/\/jp.tdsynnex.com\/blog\/category\/google\/"},{"@type":"ListItem","position":3,"name":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u30c6\u30b9\u30c8\u7528Google\u30d5\u30a9\u30fc\u30e0\u3092\u4f5c\u6210\u3059\u308bGAS"}]},{"@type":"WebSite","@id":"https:\/\/jp.tdsynnex.com\/blog\/#website","url":"https:\/\/jp.tdsynnex.com\/blog\/","name":"TD SYNNEX BLOG","description":"IT\u5c02\u9580\u5546\u793e\u304c\u5c4a\u3051\u308b\u60c5\u5831\u30e1\u30c7\u30a3\u30a2","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jp.tdsynnex.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/001c8dcd84e98df520975ae4cfe82053","name":"TD SYNNEX K.K.","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/jp.tdsynnex.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a8f5827738602e2a74ad1b31e261ecc21785df535840a4363d1eb974fc63b3a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a8f5827738602e2a74ad1b31e261ecc21785df535840a4363d1eb974fc63b3a6?s=96&d=mm&r=g","caption":"TD SYNNEX K.K."}}]}},"_links":{"self":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts\/6728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/comments?post=6728"}],"version-history":[{"count":5,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts\/6728\/revisions"}],"predecessor-version":[{"id":7000,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/posts\/6728\/revisions\/7000"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/media\/6748"}],"wp:attachment":[{"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/media?parent=6728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/categories?post=6728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jp.tdsynnex.com\/blog\/wp-json\/wp\/v2\/tags?post=6728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}