{"id":5894,"date":"2026-01-14T15:20:59","date_gmt":"2026-01-14T06:20:59","guid":{"rendered":"https:\/\/autosns.co.jp\/manual\/?p=5894"},"modified":"2026-01-14T15:20:59","modified_gmt":"2026-01-14T06:20:59","slug":"spreadsheets","status":"publish","type":"post","link":"https:\/\/autosns.co.jp\/manual\/start\/external\/spreadsheets","title":{"rendered":"\u30d7\u30ed\u30e9\u30a4\u30f3\u306e\u30d5\u30a9\u30fc\u30e0\u56de\u7b54\u3092Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u81ea\u52d5\u53cd\u6620\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s20-1024x572.png\" alt=\"\" width=\"850\" height=\"475\" class=\"aligncenter size-large wp-image-5978\" srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s20-1024x572.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s20-300x168.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s20-768x429.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s20.png 1324w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<div class=\"voice clearfix left n_bottom\">\n<div class=\"icon\">\n<p><img decoding=\"async\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2022\/03\/icon_robot02.png\" class=\"lazyload\" \/><\/p>\n<div class=\"name\"><\/div>\n<\/div>\n<div class=\"text sc_balloon left white\">\u30d7\u30ed\u30e9\u30a4\u30f3\u30d5\u30ea\u30fc\u3067\u306e\u56de\u7b54\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u53cd\u6620\u3057\u3066<br \/>\n\u30b9\u30bf\u30c3\u30d5\u9593\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u5171\u6709\u3057\u305f\u3044\u3093\u3060\u3051\u3069\u2026<\/div>\n<\/div>\n<div class=\"voice clearfix right n_bottom\">\n<div class=\"icon\">\n<p><img decoding=\"async\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2022\/03\/icon_symbol_color.png\" class=\"lazyload\" \/><\/p>\n<div class=\"name\"><\/div>\n<\/div>\n<div class=\"text sc_balloon right custom\" style=\"background: #c1ffa0; color: #000;\"><span class=\"custom_voice right normal\" style=\"border-color: transparent transparent transparent #c1ffa0;\"><\/span>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eApps Script\u3067\u8a2d\u5b9a\u3059\u308c\u3070\u3067\u304d\u308b\u3088\uff01<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u30d7\u30ed\u30e9\u30a4\u30f3\u306e\u30d5\u30a9\u30fc\u30e0\u9001\u4fe1\u6642\u306b\u5916\u90e8\u30b7\u30b9\u30c6\u30e0\u306b\u4fe1\u53f7\uff08\u30c7\u30fc\u30bf\uff09\u3092\u9001\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u306e\u3067\u3001<\/p>\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff0bApps Script\u3067\u3001\u305d\u306e\u4fe1\u53f7\uff08\u30c7\u30fc\u30bf\uff09\u3092\u53d7\u3051\u53d6\u3063\u3066\u3001\u6307\u5b9a\u306e\u30b7\u30fc\u30c8\u3078\u81ea\u52d5\u3067\u8ffd\u8a18\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets02-1024x439.png\" alt=\"\" width=\"719\" height=\"308\" class=\"aligncenter wp-image-5898 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets02-1024x439.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets02-300x129.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets02-768x329.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets02.png 1204w\" data-sizes=\"(max-width: 719px) 100vw, 719px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u8a2d\u5b9a\u65b9\u6cd5\u306b\u3064\u3044\u3066\u6848\u5185\u3057\u307e\u3059\u306d\u3002<\/p>\n<h2>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5074\u306e\u8a2d\u5b9a<\/h2>\n<p>&nbsp;<\/p>\n<p>\u307e\u305a\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5074\u3067\u4e0b\u8a18\u306e\u6d41\u308c\u3067\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<h3>\u624b\u98061\uff1aGoogle\u30c9\u30e9\u30a4\u30d6\u3067\u65b0\u898f\u306b\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/h3>\n<p>\u307e\u305a\u3001<a href=\"https:\/\/drive.google.com\/drive\/u\/0\/home\" target=\"_blank\" rel=\"noopener\">Google\u30c9\u30e9\u30a4\u30d6<\/a>\u3067\u65b0\u898f\u306b\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets03.png\" alt=\"\" width=\"324\" height=\"398\" class=\"aligncenter size-full wp-image-5899 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets03.png 324w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets03-244x300.png 244w\" data-sizes=\"(max-width: 324px) 100vw, 324px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u3053\u3061\u3089\u304c\u8a18\u9332\u5148\u306b\u306a\u308a\u307e\u3059\u3002\u30b7\u30fc\u30c8\u540d\u306f\u4efb\u610f\u3067\u69cb\u3044\u307e\u305b\u3093\u3002\uff08\u3053\u3053\u3067\u306f\u3001\u3053\u306e\u30de\u30cb\u30e5\u30a2\u30eb\u7528\u306b\u9023\u643a\u30c6\u30b9\u30c8\u3068\u3057\u307e\u3059\u3002\uff09<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets04-1024x482.png\" alt=\"\" width=\"763\" height=\"359\" class=\"aligncenter wp-image-5900 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets04-1024x482.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets04-300x141.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets04-768x362.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets04-1536x723.png 1536w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets04.png 1542w\" data-sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>\u624b\u98062\uff1a\u4f5c\u6210\u3057\u305f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eApps Script\u3092\u958b\u304d\u307e\u3059<\/h3>\n<p>&nbsp;<\/p>\n<p>\u4f5c\u6210\u3057\u305f\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u300c\u62e1\u5f35\u6a5f\u80fd\u300d\u2192\u300cApps Script\u300d \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets05-1024x343.png\" alt=\"\" width=\"850\" height=\"285\" class=\"aligncenter size-large wp-image-5901 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets05-1024x343.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets05-300x100.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets05-768x257.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets05-1536x514.png 1536w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets05.png 1674w\" data-sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Apps Script\u753b\u9762\u3092\u958b\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1024x297.png\" alt=\"\" width=\"850\" height=\"247\" class=\"aligncenter size-large wp-image-5902 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1024x297.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-300x87.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-768x222.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1536x445.png 1536w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-2048x593.png 2048w\" data-sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>\u624b\u98063\uff1a\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u306e\u5185\u5bb9\u3092\u8cbc\u308a\u4ed8\u3051\u307e\u3059<\/h3>\n<p>&nbsp;<\/p>\n<p>\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u65e2\u5b58\u306e\u30b3\u30fc\u30c9\u304c\u5165\u529b\u3055\u308c\u3066\u304a\u308a\u307e\u3059\u306e\u3067\u3001\u3053\u3061\u3089\u3092\u5168\u3066\u6d88\u3057\u3066\u304b\u3089<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1-1024x297.png\" alt=\"\" width=\"850\" height=\"247\" class=\"aligncenter size-large wp-image-5903 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1-1024x297.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1-300x87.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1-768x222.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1-1536x445.png 1536w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets06-1-2048x593.png 2048w\" data-sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>\u4ee5\u4e0b\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u306e\u5185\u5bb9\u3092\u8cbc\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div class=\"sc_toggle_box\" style=\"margin-bottom: 2em;\">\n<div class=\"sc_toggle_title\">\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u306e\u4e2d\u8eab\u3000\u203b\u30af\u30ea\u30c3\u30af\u3067\u958b\u304d\u307e\u3059<\/div>\n<div class=\"sc_toggle_content\">\n<pre><code class=\"language-php copyable\">function doGet() {\r\n  return ContentService.createTextOutput(\"OK\");\r\n}\r\n\r\nfunction doPost(e) {\r\n  var ss = SpreadsheetApp.getActiveSpreadsheet();\r\n  var debug = ss.getSheetByName('_debug') || ss.insertSheet('_debug');\r\n\r\n  try {\r\n    var p = (e && e.parameter) ? e.parameter : {};\r\n    var raw = (e && e.postData && e.postData.contents) ? e.postData.contents : \"\";\r\n\r\n    \/\/ \u56fa\u5b9a\u5217\uff08\u5148\u982d3\u5217\uff09\r\n    var sentAt = p.date\r\n      ? p.date\r\n      : (p.unixtime ? fmt_(new Date(Number(p.unixtime) * 1000)) : fmt_(new Date()));\r\n    var uid = p.uid || \"\";\r\n    var snsname = p[\"user_data[snsname]\"] || \"\";\r\n\r\n    \/\/ \u30b7\u30fc\u30c8\uff08form_name\u30d9\u30fc\u30b9\uff09\r\n    var sheet = getOrCreateSheet_(ss, sheetNameFromFormName_(p.form_name || \"unknown\"));\r\n\r\n    \/\/ form_data\uff08\u9001\u4fe1\u9806\uff09\r\n    var parsed = parseOrderedFormData_(raw);\r\n    var keysOrder = parsed.keysOrder;   \/\/ \u9001\u4fe1\u9806\u306e\u30ad\u30fc\u914d\u5217\r\n    var valuesMap = parsed.valuesMap;   \/\/ { key: [v1,v2...] }\r\n\r\n    \/\/ \u30d8\u30c3\u30c0\u30fc\u6e96\u5099\uff08\u521d\u56de\u306e\u307f\u4f5c\u6210\u3002\u4ee5\u5f8c\u306f\u4e0a\u66f8\u304d\u3057\u306a\u3044\uff09\r\n    ensureHeaderOnceAndExpand_(sheet, keysOrder);\r\n\r\n    \/\/ \u30c7\u30fc\u30bf\u884c\u3092\u300c\u5217\u306e\u4f4d\u7f6e\u300d\u3067\u4f5c\u308b\r\n    var baseLen = 3; \/\/ date, uid, snsname\r\n    var lastCol = sheet.getLastColumn();\r\n    var row = [];\r\n    for (var i = 0; i < lastCol; i++) row.push(\"\");\r\n\r\n    row[0] = sentAt;\r\n    row[1] = uid;\r\n    row[2] = snsname;\r\n\r\n    \/\/ form_data \u306f\u300c\u9001\u4fe1\u9806\u306b\u300d3\u5217\u76ee\u4ee5\u964d\u3078\u5165\u308c\u308b\uff08\u30d8\u30c3\u30c0\u30fc\u540d\u304c\u30ea\u30cd\u30fc\u30e0\u3055\u308c\u3066\u3066\u3082OK\uff09\r\n    \/\/ \u65e2\u5b58\u5217\u6570\u3092\u8d85\u3048\u308b\u5206\u306f ensureHeaderOnceAndExpand_ \u304c\u8ffd\u52a0\u6e08\u307f\r\n    for (var j = 0; j < keysOrder.length; j++) {\r\n      var k = keysOrder[j];\r\n      var arr = valuesMap[k] || [];\r\n      var col = baseLen + j; \/\/ 0-based\r\n      if (col >= row.length) break;\r\n      row[col] = arr.join(\"\\n\"); \/\/ \u30d5\u30a1\u30a4\u30eb\u8907\u6570\u306f\u6539\u884c\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306f\u5143\u304c\u30ab\u30f3\u30de\u6587\u5b57\u5217\u306a\u3089\u305d\u306e\u307e\u307e\r\n    }\r\n\r\n    sheet.appendRow(row);\r\n    return ContentService.createTextOutput(\"OK\");\r\n\r\n  } catch (err) {\r\n    debug.appendRow([new Date(), \"ERROR\", String(err), raw]);\r\n    return ContentService.createTextOutput(\"NG\");\r\n  }\r\n}\r\n\r\n\/**\r\n * 1\u884c\u76ee\uff08\u30d8\u30c3\u30c0\u30fc\uff09\u306b\u4f55\u304b\u5165\u3063\u3066\u3044\u308b\u304b\u3060\u3051\u898b\u3066\u3001\r\n * - \u7a7a\u306a\u3089\u4f5c\u308b\uff08date, uid, snsname, + form_data\u30ad\u30fc\uff09\r\n * - \u65e2\u306b\u3042\u308b\u306a\u3089\u4e0a\u66f8\u304d\u3057\u306a\u3044\r\n * - form_data\u306e\u6570\u304c\u5897\u3048\u305f\u3068\u304d\u3060\u3051\u53f3\u306b\u5217\u8ffd\u52a0\uff08\u30d8\u30c3\u30c0\u30fc\u540d\u306f\u6765\u305f\u30ad\u30fc\u540d\uff09\r\n *\/\r\nfunction ensureHeaderOnceAndExpand_(sheet, keysOrder) {\r\n  var base = [\"date\", \"uid\", \"snsname\"];\r\n  var baseLen = base.length;\r\n\r\n  var lastCol = sheet.getLastColumn();\r\n  var header = [];\r\n\r\n  if (lastCol > 0) {\r\n    header = sheet.getRange(1, 1, 1, lastCol).getValues()[0];\r\n  }\r\n\r\n  \/\/ \u30d8\u30c3\u30c0\u30fc\u884c\u306b\u4f55\u304b\u5165\u3063\u3066\u3044\u308b\u304b\uff1f\r\n  var hasHeader = false;\r\n  for (var i = 0; i < header.length; i++) {\r\n    if (header[i] !== \"\") { hasHeader = true; break; }\r\n  }\r\n\r\n  \/\/ \u521d\u56de\uff1a\u30d8\u30c3\u30c0\u30fc\u3092\u4f5c\u308b\uff08\u30ad\u30fc\u540d\u306e\u307e\u307e\u3002\u3042\u3068\u3067\u81ea\u7531\u306b\u30ea\u30cd\u30fc\u30e0OK\uff09\r\n  if (!hasHeader) {\r\n    var newHeader = base.concat(keysOrder);\r\n    sheet.getRange(1, 1, 1, newHeader.length).setValues([newHeader]);\r\n    return;\r\n  }\r\n\r\n  \/\/ \u65e2\u5b58\u30d8\u30c3\u30c0\u30fc\u3042\u308a\uff1a\u8db3\u308a\u306a\u3044\u5217\u3060\u3051\u8ffd\u52a0\r\n  \/\/ \u65e2\u5b58\u30d5\u30a9\u30fc\u30e0\u5217\u6570 = \u5168\u5217 - \u56fa\u5b9a3\u5217\r\n  var currentFormCols = Math.max(0, lastCol - baseLen);\r\n  if (keysOrder.length <= currentFormCols) return;\r\n\r\n  \/\/ \u8ffd\u52a0\u304c\u5fc5\u8981\u306a\u5206\u3060\u3051\u3001\u53f3\u306b\u30ad\u30fc\u540d\u3092\u5165\u308c\u3066\u5217\u8ffd\u52a0\r\n  for (var j = currentFormCols; j < keysOrder.length; j++) {\r\n    var keyName = keysOrder[j] || (\"form_add_\" + (j + 1));\r\n    sheet.getRange(1, baseLen + j + 1).setValue(keyName); \/\/ 1-based\r\n  }\r\n}\r\n\r\nfunction parseOrderedFormData_(raw) {\r\n  var keysOrder = [];\r\n  var valuesMap = {};\r\n  if (!raw) return { keysOrder: keysOrder, valuesMap: valuesMap };\r\n\r\n  var parts = raw.split(\"&\");\r\n  for (var i = 0; i < parts.length; i++) {\r\n    var part = parts[i];\r\n    if (!part) continue;\r\n\r\n    var eq = part.indexOf(\"=\");\r\n    var kEnc = (eq >= 0) ? part.slice(0, eq) : part;\r\n    var vEnc = (eq >= 0) ? part.slice(eq + 1) : \"\";\r\n\r\n    var key = decodeURIComponent(kEnc.replace(\/\\+\/g, \" \"));\r\n    var val = decodeURIComponent(vEnc.replace(\/\\+\/g, \" \"));\r\n\r\n    var m = key.match(\/^form_data\\[(.+)\\]$\/);\r\n    if (!m) continue;\r\n\r\n    \/\/ \"form34-6][0\" \/ \"form34-6][0]\" \u3092 \"form34-6\" \u306b\u6b63\u898f\u5316\r\n    var innerKey = m[1].replace(\/\\]\\[\\d+\\]?$\/g, \"\");\r\n\r\n    if (!valuesMap[innerKey]) valuesMap[innerKey] = [];\r\n    if (val !== \"\") valuesMap[innerKey].push(val);\r\n\r\n    if (keysOrder.indexOf(innerKey) === -1) keysOrder.push(innerKey);\r\n  }\r\n\r\n  return { keysOrder: keysOrder, valuesMap: valuesMap };\r\n}\r\n\r\nfunction sheetNameFromFormName_(formName) {\r\n  var prefix = \"form_\";\r\n  var maxLen = 100;\r\n\r\n  var name = String(formName)\r\n    .replace(\/:\/g, \"\uff1a\")\r\n    .replace(\/[\\\\\\\/\\?\\*\\[\\]]\/g, \" \")\r\n    .replace(\/\\s+\/g, \" \")\r\n    .trim();\r\n\r\n  if (!name) name = \"unknown\";\r\n\r\n  var allow = maxLen - prefix.length;\r\n  if (name.length > allow) name = name.slice(0, allow).trim();\r\n\r\n  return prefix + name;\r\n}\r\n\r\nfunction getOrCreateSheet_(ss, name) {\r\n  return ss.getSheetByName(name) || ss.insertSheet(name);\r\n}\r\n\r\nfunction fmt_(d) {\r\n  return Utilities.formatDate(d, \"Asia\/Tokyo\", \"yyyy-MM-dd HH:mm:ss\");\r\n}\r\n<\/code><\/pre>\n<\/div>\n<\/div>\n<h3>\u624b\u98064\uff1a\u30c7\u30d7\u30ed\u30a4\u3057\u3066\u5229\u7528\u53ef\u80fd\u306a\u72b6\u614b\u306b\u3057\u307e\u3059<\/h3>\n<p>&nbsp;<\/p>\n<p>\u53f3\u4e0a\u306e \u300c\u30c7\u30d7\u30ed\u30a4\u300d\u2192\u300c\u65b0\u3057\u3044\u30c7\u30d7\u30ed\u30a4\u300d \u3092\u9078\u3093\u3067\u3001<\/p>\n<p><strong><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets07.png\" alt=\"\" width=\"294\" height=\"296\" class=\"aligncenter wp-image-5904 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets07.png 492w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets07-298x300.png 298w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets07-150x150.png 150w\" data-sizes=\"(max-width: 294px) 100vw, 294px\" \/><\/strong><\/p>\n<p>\u6b6f\u8eca\u306e\u30a2\u30a4\u30b3\u30f3\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u5408\u308f\u305b\u3066\u3001\u7a2e\u985e\u3092 \u300c\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u300d \u306b\u3057\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets08.png\" alt=\"\" width=\"513\" height=\"383\" class=\"aligncenter wp-image-5905 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets08.png 766w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets08-300x224.png 300w\" data-sizes=\"(max-width: 513px) 100vw, 513px\" \/><\/p>\n<p>\u305d\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<p>\u5b9f\u884c\u3059\u308b\u30e6\u30fc\u30b6\u30fc\uff1a\u81ea\u5206<br \/>\n\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u30e6\u30fc\u30b6\u30fc\uff1a\u5168\u54e1<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets09-1024x811.png\" alt=\"\" width=\"701\" height=\"555\" class=\"aligncenter wp-image-5906 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets09-1024x811.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets09-300x238.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets09-768x608.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets09-1536x1217.png 1536w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets09.png 1550w\" data-sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u305d\u3057\u3066\u3001\u300c\u30c7\u30d7\u30ed\u30a4\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u521d\u56de\u306f\u6a29\u9650\u8a31\u53ef\u304c\u6c42\u3081\u3089\u308c\u308b\u306e\u3067\u8a31\u53ef\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets11-1024x275.png\" alt=\"\" width=\"850\" height=\"228\" class=\"aligncenter size-large wp-image-5908 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets11-1024x275.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets11-300x81.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets11-768x206.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets11.png 1036w\" data-sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<div class=\"sc_frame_wrap inline green\">\n<div class=\"sc_frame_title\">\u627f\u8a8d\u6642\u306b\u8b66\u544a\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408<\/div>\n<div class=\"sc_frame\">\n<p>\u627f\u8a8d\u6642\u306b\u3001\u300cGoogle\u306f\u3053\u306e\u30a2\u30d7\u30ea\u3092\u691c\u8a3c\u3057\u3066\u3044\u307e\u305b\u3093\u300d \u3068\u3044\u3046\u8b66\u544a\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u306f \u4e0d\u6b63\u306a\u52d5\u4f5c\u304c\u691c\u51fa\u3055\u308c\u305f \u3068\u3044\u3046\u610f\u5473\u3067\u306f\u306a\u304f\u3001\u500b\u4eba\uff08\u307e\u305f\u306f\u81ea\u793e\uff09\u3067\u4f5c\u6210\u3057\u305f Apps Script \u306f\u3001Google \u306e\u201c\u691c\u8a3c\u6e08\u307f\u30a2\u30d7\u30ea\u201d\u3068\u3057\u3066\u767b\u9332\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u591a\u3044\u305f\u3081 \u306b\u51fa\u308b\u3001<strong>\u4e00\u822c\u7684\u306a\u6848\u5185\u3067\u3059\u3002<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>\u672c\u624b\u9806\u306f\u3001\u304a\u5ba2\u69d8\u3054\u81ea\u8eab\u306e Google \u30a2\u30ab\u30a6\u30f3\u30c8\u5185\u3067\u4f5c\u6210\u3057\u305f Apps Script \u306b\u3001\u5f0a\u793e\u304c\u63d0\u4f9b\u3059\u308b\u30b5\u30f3\u30d7\u30eb\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u8cbc\u308a\u4ed8\u3051\u3066\u5229\u7528\u3059\u308b\u305f\u3081\u3001<\/p>\n<p>\u4e0a\u8a18\u306e\u8b66\u544a\u304c\u8868\u793a\u3055\u308c\u3066\u3082\u3001\u5185\u5bb9\u304c\u6b63\u3057\u3051\u308c\u3070\u901a\u5e38\u306f\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u3082\u3057\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u753b\u9762\u306b\u306a\u3063\u305f\u3089\u3001\u5de6\u4e0b\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets12-1024x583.png\" alt=\"\" width=\"629\" height=\"358\" class=\"aligncenter wp-image-5909 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets12-1024x583.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets12-300x171.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets12-768x437.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets12.png 1152w\" data-sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<p>\u3055\u3089\u306b\u3001\u300c\u7121\u984c\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3078\uff08\u5371\u967a\uff09\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets13-1024x788.png\" alt=\"\" width=\"512\" height=\"394\" class=\"aligncenter wp-image-5910 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets13-1024x788.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets13-300x231.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets13-768x591.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets13.png 1128w\" data-sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p>\u300c\u7d9a\u304f\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets14-472x1024.png\" alt=\"\" width=\"472\" height=\"1024\" class=\"aligncenter size-large wp-image-5911 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets14-472x1024.png 472w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets14-138x300.png 138w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets14.png 594w\" data-sizes=\"(max-width: 472px) 100vw, 472px\" \/><\/p>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<h3>\u624b\u98065\uff1a\u30c7\u30d7\u30ed\u30a4\u5f8c\u306b\u8868\u793a\u3055\u308c\u308b \u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u306eURL \u3092\u30b3\u30d4\u30fc\u3057\u3066\u304a\u304d\u307e\u3059<\/h3>\n<p>&nbsp;<\/p>\n<p>\u4ee5\u4e0b\u306e\u7b87\u6240\u306e\u3001\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u306eURL \u3092\u30b3\u30d4\u30fc\u3057\u3066\u304a\u304d\u307e\u3059\uff08URL\u306f ...\/exec \u3067\u7d42\u308f\u308b\u3082\u306e\u3092\u4f7f\u3044\u307e\u3059\uff09<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets15-1024x801.png\" alt=\"\" width=\"683\" height=\"534\" class=\"aligncenter wp-image-5912 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets15-1024x801.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets15-300x235.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets15-768x601.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets15.png 1496w\" data-sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/p>\n<p>&nbsp;<\/p>\n<div class=\"sc_frame_wrap inline green\">\n<div class=\"sc_frame_title\">\u30b3\u30fc\u30c9\u306e\u4fee\u6b63\u3092\u3059\u308b\u6642\u306bURL\u3092\u5909\u3048\u305a\u306b\u6e08\u3080\u65b9\u6cd5<\/div>\n<div class=\"sc_frame\">\n<p>&nbsp;<\/p>\n<p>Apps Script\u5074\u306e\u30b3\u30fc\u30c9\u3092\u4fee\u6b63\u3059\u308b\u969b\u306b<\/p>\n<p>\u518d\u5ea6\u300c\u65b0\u3057\u3044\u30c7\u30d7\u30ed\u30a4\u300d\u3092\u3057\u3066\u3057\u307e\u3046\u3068\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u306eURL\u304c\u5909\u308f\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n<p>URL\u3092\u5909\u3048\u305a\u306b\u30c7\u30d7\u30ed\u30a4\u3059\u308b\u305f\u3081\u306b\u3001\u30b3\u30fc\u30c9\u7de8\u96c6\u5f8c\u306b<\/p>\n<p>\u30c7\u30d7\u30ed\u30a4 &gt; \u300c\u30c7\u30d7\u30ed\u30a4\u3092\u7ba1\u7406\u300d \u304b\u3089<br \/>\n<img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets16.png\" alt=\"\" width=\"294\" height=\"291\" class=\"aligncenter wp-image-5913 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets16.png 438w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets16-300x297.png 300w\" data-sizes=\"(max-width: 294px) 100vw, 294px\" \/><\/p>\n<p>\u925b\u7b46\u30de\u30fc\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets17-1024x353.png\" alt=\"\" width=\"731\" height=\"252\" class=\"aligncenter wp-image-5914 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets17-1024x353.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets17-300x104.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets17-768x265.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets17.png 1478w\" data-sizes=\"(max-width: 731px) 100vw, 731px\" \/><\/p>\n<p>\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u300c\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3 \u300d\u3092\u9078\u629e\u3057\u3066\u3001<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets18-1024x647.png\" alt=\"\" width=\"644\" height=\"407\" class=\"aligncenter wp-image-5915 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets18-1024x647.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets18-300x190.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets18-768x486.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets18.png 1082w\" data-sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u6700\u5f8c\u306b\u300c\u30c7\u30d7\u30ed\u30a4\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3053\u3068\u3067\u3001URL\u3092\u5909\u3048\u305a\u306b\u30c7\u30d7\u30ed\u30a4\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2>\u30d7\u30ed\u30e9\u30a4\u30f3\u5074\u306e\u8a2d\u5b9a<\/h2>\n<p>&nbsp;<\/p>\n<h3>\u624b\u98066\uff1a\u30d7\u30ed\u30e9\u30a4\u30f3\u5074\u306b\u30a6\u30a7\u30d6\u30a2\u30d7\u30ea\u306eURL\u3092\u8cbc\u3063\u3066\u9023\u643a\u3057\u307e\u3059<\/h3>\n<p>&nbsp;<\/p>\n<p>\u30d7\u30ed\u30e9\u30a4\u30f3\u30d5\u30ea\u30fc\u7ba1\u7406\u753b\u9762\u306e<a href=\"https:\/\/autosns.jp\/forms\" target=\"_blank\" rel=\"noopener\">\u30d5\u30a9\u30fc\u30e0\u30da\u30fc\u30b8<\/a>\u3092\u958b\u3044\u3066<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets19.png\" alt=\"\" width=\"178\" height=\"319\" class=\"aligncenter wp-image-5917 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets19.png 262w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets19-167x300.png 167w\" data-sizes=\"(max-width: 178px) 100vw, 178px\" \/><\/p>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u56de\u7b54\u3092\u53cd\u6620\u3055\u305b\u305f\u3044\u5bfe\u8c61\u306e\u30d5\u30a9\u30fc\u30e0\u3092\u9078\u629e\u3057\u3066\u3001<\/p>\n<p>&nbsp;<\/p>\n<p>\u300c\u767b\u9332\u767a\u751f\u6642\u306b\u5916\u90e8\u30b7\u30b9\u30c6\u30e0\u306b\u30c7\u30fc\u30bf\u3092\u9001\u4fe1\u3059\u308b\u300d \u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u3066\u3001<\/p>\n<p>URL\u6b04\u306b \u5148\u307b\u3069\u30b3\u30d4\u30fc\u3057\u305f\u30a6\u30a7\u30d6\u30a2\u30d7\u30eaURL \u3092\u8cbc\u308a\u4ed8\u3051\u3066\u3001\u305d\u306e\u4e0b\u306e\u300c\u4fdd\u5b58\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets21-756x1024.jpg\" alt=\"\" width=\"574\" height=\"777\" class=\"aligncenter wp-image-5920 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets21-756x1024.jpg 756w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets21-222x300.jpg 222w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets21-768x1040.jpg 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets21.jpg 802w\" data-sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/p>\n<h2>\u30d5\u30a9\u30fc\u30e0\u9001\u4fe1\u3057\u3066\u52d5\u4f5c\u3092\u78ba\u8a8d\u304f\u3060\u3055\u3044<\/h2>\n<p>\u6700\u5f8c\u306b\u3001\u5b9f\u969b\u306b\u30d5\u30a9\u30fc\u30e0\u3092\u9001\u4fe1\u3057\u3066\u52d5\u4f5c\u3092\u3054\u78ba\u8a8d\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u65b0\u305f\u306b\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u30d5\u30a9\u30fc\u30e0\u540d\u3068\u5171\u306b\u8a18\u9332\u3055\u308c\u307e\u3059\u306e\u3067\u3001\u8a72\u5f53\u306e\u30b7\u30fc\u30c8\u3092\u9078\u629e\u3057\u3001<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s7.png\" alt=\"\" width=\"491\" height=\"247\" class=\"aligncenter wp-image-5949 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s7.png 736w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2026\/01\/s7-300x151.png 300w\" data-sizes=\"(max-width: 491px) 100vw, 491px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u4ee5\u4e0b\u306e\u5185\u5bb9\u304c\u81ea\u52d5\u3067\u8ffd\u8a18\u3055\u308c\u308b\u3053\u3068\u3092\u3054\u78ba\u8a8d\u304f\u3060\u3055\u3044\u3002<\/p>\n<ul>\n<li>date\uff08\u30d5\u30a9\u30fc\u30e0\u9001\u4fe1\u65e5\u6642\uff09<\/li>\n<li>uid\uff08\u30e6\u30fc\u30b6\u30fcID\uff09<\/li>\n<li>snsname\uff08\u8868\u793a\u540d\uff09<\/li>\n<li>form_data \u306e\u5185\u5bb9<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets22-1024x470.png\" alt=\"\" width=\"684\" height=\"314\" class=\"aligncenter wp-image-5921 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets22-1024x470.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets22-300x138.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets22-768x352.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets22.png 1496w\" data-sizes=\"(max-width: 684px) 100vw, 684px\" \/><\/p>\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u51fa\u529b\u3055\u308c\u305f1\u884c\u76ee\uff08\u30d8\u30c3\u30c0\u30fc\u884c\uff09\u306e\u9805\u76ee\u540d\u306f\u3001\u5909\u66f4\u53ef\u80fd\u3067\u3059\u306e\u3067\u3001\u4f8b\u3048\u3070\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5909\u66f4\u3057\u3066\u3044\u305f\u3060\u3044\u3066\u3082\u69cb\u3044\u307e\u305b\u3093\u3002<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" data-src=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets23-1024x260.png\" alt=\"\" width=\"850\" height=\"216\" class=\"aligncenter size-large wp-image-5922 lazyload\" data-srcset=\"https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets23-1024x260.png 1024w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets23-300x76.png 300w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets23-768x195.png 768w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets23-1536x390.png 1536w, https:\/\/autosns.co.jp\/manual\/wp-content\/uploads\/2025\/12\/spreadsheets23.png 1724w\" data-sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>&nbsp;<\/p>\n<div class=\"sc_frame_wrap inline green\">\n<div class=\"sc_frame_title\">\u6ce8\u610f\u70b9<\/div>\n<div class=\"sc_frame\">\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5074\u3067\u9014\u4e2d\u306b\u884c\u3092\u633f\u5165\u3059\u308b\u306a\u3069\u7de8\u96c6\u3059\u308b\u3068\u3001\u56de\u7b54\u6642\u306b\u53cd\u6620\u3055\u308c\u308b\u969b\u306b\u30ba\u30ec\u308b\u539f\u56e0\u3068\u306a\u308a\u307e\u3059\u306e\u3067\u3001<\/p>\n<p>\u9805\u76ee\u8ffd\u52a0\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3092\u7de8\u96c6\u3057\u3066\u3044\u305f\u3060\u304f\u304b\u3001\u30d5\u30a9\u30fc\u30e0\u8cea\u554f\u3092\u8ffd\u52a0\u3059\u308b\u304b\u3001\u7b49\u3067\u306e\u5bfe\u5fdc\u3092\u3054\u691c\u8a0e\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30d7\u30ed\u30e9\u30a4\u30f3\u30d5\u30ea\u30fc\u3067\u306e\u56de\u7b54\u3092\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u53cd\u6620\u3057\u3066 \u30b9\u30bf\u30c3\u30d5\u9593\u3067\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u5171\u6709\u3057\u305f\u3044\u3093\u3060\u3051\u3069\u2026 Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306eApps Script\u3067\u8a2d\u5b9a\u3059\u308c\u3070\u3067\u304d\u308b\u3088\uff01 &nbsp; &nbsp; \u30d7\u30ed\u30e9\u30a4\u30f3\u306e\u30d5\u30a9\u30fc\u30e0\u9001\u4fe1\u6642\u306b\u5916\u2026<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/posts\/5894"}],"collection":[{"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/comments?post=5894"}],"version-history":[{"count":25,"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/posts\/5894\/revisions"}],"predecessor-version":[{"id":5980,"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/posts\/5894\/revisions\/5980"}],"wp:attachment":[{"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/media?parent=5894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/categories?post=5894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autosns.co.jp\/manual\/wp-json\/wp\/v2\/tags?post=5894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}