{"id":21128,"date":"2025-12-02T10:51:59","date_gmt":"2025-12-02T01:51:59","guid":{"rendered":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/?p=21128"},"modified":"2025-12-02T11:04:28","modified_gmt":"2025-12-02T02:04:28","slug":"%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%a7%e3%83%a1%e3%83%a2%e3%82%92%e5%b8%b8%e3%81%ab%e8%a1%a8%e7%a4%ba%e3%81%95%e3%81%9b%e3%82%8b%e3%81%ab%e3%81%af%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/21128\/","title":{"rendered":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30e1\u30e2\u3092\u5e38\u306b\u8868\u793a\u3059\u308b\u306b\u306f\uff1f\u30e1\u30e2\u6a5f\u80fd\u306e\u4f7f\u3044\u65b9\u3084\u81ea\u52d5\u5316\uff08GAS\uff09\u307e\u3067"},"content":{"rendered":"

Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google Sheets\uff09\u306e\u30e1\u30e2\u6a5f\u80fd\u306f\u3001\u30bb\u30eb\u306b\u88dc\u8db3\u60c5\u5831\u3092\u8ffd\u52a0\u3067\u304d\u308b\u4fbf\u5229\u306a\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001\u901a\u5e38\u306f\u30de\u30a6\u30b9\u30aa\u30fc\u30d0\u30fc\u6642\u306e\u307f\u8868\u793a\u3055\u308c\u308b\u305f\u3081\u3001\u91cd\u8981\u306a\u60c5\u5831\u3092\u898b\u9003\u3057\u304c\u3061\u3067\u3059\u3002<\/p>\n

\u672c\u8a18\u4e8b\u3067\u306f\u3001\u30e1\u30e2\u3092\u5e38\u6642\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5\u3084\u3001Google Apps Script\uff08GAS\uff09\u3092\u4f7f\u3063\u305f\u9ad8\u5ea6\u306a\u8868\u793a\u5236\u5fa1\u307e\u3067\u3001\u521d\u5fc3\u8005\u3067\u3082\u5b9f\u88c5\u3067\u304d\u308b\u3088\u3046\u8a73\u3057\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002\u30b3\u30e1\u30f3\u30c8\u6a5f\u80fd\u3068\u306e\u9055\u3044\u3084\u3001\u696d\u52d9\u3067\u306e\u52b9\u679c\u7684\u306a\u6d3b\u7528\u65b9\u6cd5\u3082\u542b\u3081\u3066\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30e1\u30e2\u6a5f\u80fd\u3092\u6700\u5927\u9650\u306b\u6d3b\u7528\u3059\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n

<\/div>

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30e1\u30e2\u6a5f\u80fd\u3068\u306f\uff1f<\/h2>\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30e1\u30e2\u6a5f\u80fd\u3068\u306f\u3001\u30bb\u30eb\u306b\u88dc\u8db3\u60c5\u5831\u3092\u4ed8\u52a0\u3067\u304d\u308b\u6a5f\u80fd\u3067\u3001\u30bb\u30eb\u306b\u30de\u30a6\u30b9\u30ab\u30fc\u30bd\u30eb\u3092\u5408\u308f\u305b\u308b\u3068\u9ec4\u8272\u3044\u5439\u304d\u51fa\u3057\u3067\u5185\u5bb9\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/b><\/span>\u30c7\u30fc\u30bf\u306e\u80cc\u666f\u60c5\u5831\u3084\u8a08\u7b97\u6839\u62e0\u3001\u6ce8\u610f\u4e8b\u9805\u306a\u3069\u3092\u8a18\u9332\u3067\u304d\u3001\u30b7\u30fc\u30c8\u306e\u53ef\u8aad\u6027\u3092\u4fdd\u3061\u306a\u304c\u3089\u8a73\u7d30\u60c5\u5831\u3092\u7ba1\u7406\u3067\u304d\u308b\u91cd\u8981\u306a\u6a5f\u80fd\u3067\u3059\u3002<\/p>\n

\u30e1\u30e2\u6a5f\u80fd\u306e\u4e3b\u306a\u7279\u5fb4\u3068\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u70b9\u304c\u6319\u3052\u3089\u308c\u307e\u3059\u3002\u30e1\u30e2\u306f\u30bb\u30eb\u3068\u4e00\u4f53\u5316\u3057\u3066\u7ba1\u7406\u3055\u308c\u3001\u30bb\u30eb\u306e\u30b3\u30d4\u30fc\u30fb\u79fb\u52d5\u6642\u3082\u4e00\u7dd2\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/p>\n

\u5370\u5237\u6642<\/strong>\uff1a\u65e2\u5b9a\u3067\u306f\u975e\u8868\u793a\u3060\u304c\u3001\u5370\u5237\u8a2d\u5b9a\u3067\u30e1\u30e2\uff0f\u30b3\u30e1\u30f3\u30c8\u3092\u542b\u3081\u3066\u51fa\u529b\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3002<\/p>\n

\u8907\u6570\u30e6\u30fc\u30b6\u30fc\u3067\u306e\u5171\u540c\u7de8\u96c6\u6642\u3082\u3001\u5404\u81ea\u304c\u30e1\u30e2\u3092\u8ffd\u52a0\u30fb\u7de8\u96c6\u3067\u304d\u3001\u60c5\u5831\u5171\u6709\u306e\u52b9\u7387\u304c\u5411\u4e0a\u3057\u307e\u3059\u3002<\/p>\n

\u30e1\u30e2\u3068\u30b3\u30e1\u30f3\u30c8\u306e\u9055\u3044\u306f\uff1f<\/h3>\n

\u30e1\u30e2\u306f\u5358\u7d14\u306a\u6ce8\u91c8\u6a5f\u80fd\u3067\u3042\u308b\u306e\u306b\u5bfe\u3057\u3001\u30b3\u30e1\u30f3\u30c8\u306f\u4ed6\u306e\u30e6\u30fc\u30b6\u30fc\u3068\u306e\u3084\u308a\u53d6\u308a\u304c\u53ef\u80fd\u306a\u5bfe\u8a71\u578b\u306e\u6a5f\u80fd\u3067\u3059\u3002<\/b><\/span>\u3053\u306e\u9055\u3044\u3092\u7406\u89e3\u3059\u308b\u3053\u3068\u3067\u3001\u7528\u9014\u306b\u5fdc\u3058\u305f\u9069\u5207\u306a\u6a5f\u80fd\u9078\u629e\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u6a5f\u80fd\u306e\u6bd4\u8f03<\/h4>\n\n\n\n\n\n\n\n\n\n
\u9805\u76ee<\/th>\n\u30e1\u30e2<\/th>\n\u30b3\u30e1\u30f3\u30c8<\/th>\n<\/tr>\n<\/thead>\n
\u8868\u793a\u65b9\u6cd5<\/td>\n\u30de\u30a6\u30b9\u30aa\u30fc\u30d0\u30fc\u6642<\/td>\n\u30a4\u30f3\u30b8\u30b1\u30fc\u30bf\u8868\u793a\uff08\u30b9\u30ec\u30c3\u30c9\u3092\u958b\u3044\u305f\u6642\uff0f\u30b5\u30a4\u30c9\u30d1\u30cd\u30eb\u8868\u793a\u4e2d\u306b\u5185\u5bb9\u304c\u898b\u3048\u308b\uff09<\/td>\n<\/tr>\n
\u8fd4\u4fe1\u6a5f\u80fd<\/td>\n\u306a\u3057<\/td>\n\u3042\u308a<\/td>\n<\/tr>\n
\u901a\u77e5\u6a5f\u80fd<\/td>\n\u306a\u3057<\/td>\n\u30e1\u30f3\u30b7\u30e7\u30f3\u53ef\u80fd<\/td>\n<\/tr>\n
\u89e3\u6c7a\u30de\u30fc\u30af<\/td>\n\u306a\u3057<\/td>\n\u3042\u308a<\/td>\n<\/tr>\n
\u4e3b\u306a\u7528\u9014<\/td>\n\u9759\u7684\u306a\u60c5\u5831\u8a18\u9332<\/td>\n\u52d5\u7684\u306a\u3084\u308a\u53d6\u308a<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u30e1\u30e2\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h3>\n

\u30e1\u30e2\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\u3001\u30bb\u30eb\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30e1\u30e2\u3092\u633f\u5165\u300d\u3092\u9078\u629e\u3059\u308b\u304b\u3001\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fcShift+F2\uff08Windows\uff09\u307e\u305f\u306fShift+Fn+F2\uff08Mac\uff09\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/b><\/span>\u3053\u306e\u7c21\u5358\u306a\u64cd\u4f5c\u3067\u3001\u4efb\u610f\u306e\u30bb\u30eb\u306b\u88dc\u8db3\u8aac\u660e\u3092\u8ffd\u52a0\u3067\u304d\u307e\u3059\u3002<\/p>\n

\n
\u30e1\u30e2\u8ffd\u52a0\u306e\u8a73\u7d30\u624b\u9806<\/strong><\/span><\/div>\n
    \n
  1. \u30e1\u30e2\u3092\u8ffd\u52a0\u3057\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e<\/li>\n
  2. \u53f3\u30af\u30ea\u30c3\u30af\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u300c\u30e1\u30e2\u3092\u633f\u5165\u300d\u3092\u30af\u30ea\u30c3\u30af<\/li>\n
  3. \u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\u5185\u5bb9\u3092\u5165\u529b<\/li>\n
  4. \u30bb\u30eb\u5916\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u78ba\u5b9a<\/li>\n<\/ol>\n<\/div>\n

    \u30e1\u30e2\u304c\u8ffd\u52a0\u3055\u308c\u305f\u30bb\u30eb\u306b\u306f\u3001\u53f3\u4e0a\u306b\u5c0f\u3055\u306a\u9ed2\u3044\u4e09\u89d2\u30de\u30fc\u30af\u304c\u8868\u793a\u3055\u308c\u3001\u30e1\u30e2\u306e\u5b58\u5728\u3092\u8996\u899a\u7684\u306b\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n

    \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u30e1\u30e2\u3092\u5e38\u306b\u8868\u793a\u3055\u305b\u308b\u6a19\u6e96\u7684\u306a\u65b9\u6cd5\u306f\uff1f<\/h2>\n

    \u6b8b\u5ff5\u306a\u304c\u3089\u3001Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u6a19\u6e96\u6a5f\u80fd\u3067\u306f\u3001\u30e1\u30e2\u3092\u5e38\u6642\u8868\u793a\u3055\u305b\u308b\u76f4\u63a5\u7684\u306a\u8a2d\u5b9a\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/b><\/span>\u3057\u304b\u3057\u3001\u3044\u304f\u3064\u304b\u306e\u4ee3\u66ff\u65b9\u6cd5\u3084\u56de\u907f\u7b56\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u985e\u4f3c\u306e\u52b9\u679c\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n

    \u6a19\u6e96\u6a5f\u80fd\u3067\u306e\u4ee3\u66ff\u6848\u3068\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u65b9\u6cd5\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002<\/p>\n

    \n
      \n
    1. \u30b3\u30e1\u30f3\u30c8\u6a5f\u80fd\u3078\u306e\u5207\u308a\u66ff\u3048\n
        \n
      • \u30e1\u30e2\u306e\u4ee3\u308f\u308a\u306b\u30b3\u30e1\u30f3\u30c8\u3092\u4f7f\u7528<\/li>\n
      • \u30b3\u30e1\u30f3\u30c8\u306f\u753b\u9762\u53f3\u5074\u306b\u4e00\u89a7\u8868\u793a\u53ef\u80fd<\/li>\n
      • \u300c\u30b3\u30e1\u30f3\u30c8\u5c65\u6b74\u3092\u958b\u304f\u300d\u3067\u5e38\u6642\u78ba\u8a8d<\/li>\n<\/ul>\n<\/li>\n
      • \u5c02\u7528\u5217\u306e\u4f5c\u6210\n
          \n
        • \u30e1\u30e2\u5185\u5bb9\u3092\u5225\u5217\u306b\u8a18\u8f09<\/li>\n
        • \u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3067\u8996\u8a8d\u6027\u3092\u5411\u4e0a<\/li>\n
        • \u30d5\u30a3\u30eb\u30bf\u30fc\u6a5f\u80fd\u3067\u8868\u793a\/\u975e\u8868\u793a\u3092\u5207\u308a\u66ff\u3048<\/li>\n<\/ul>\n<\/li>\n
        • \u56f3\u5f62\u63cf\u753b\u3067\u306e\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u6d3b\u7528\n
            \n
          • \u300c\u633f\u5165\u300d\u2192\u300c\u63cf\u753b\u300d\u3067\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3092\u4f5c\u6210<\/li>\n
          • \u30bb\u30eb\u306e\u4e0a\u306b\u914d\u7f6e\u3057\u3066\u64ec\u4f3c\u7684\u306a\u30e1\u30e2\u3068\u3057\u3066\u4f7f\u7528<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/div>\n

            Google Apps Script\uff08GAS\uff09\u3067\u30e1\u30e2\u3092\u5e38\u306b\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5\u306f\uff1f<\/h2>\n

            GAS\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30e1\u30e2\u306e\u5185\u5bb9\u3092\u81ea\u52d5\u7684\u306b\u5225\u306e\u30bb\u30eb\u3084\u30b5\u30a4\u30c9\u30d0\u30fc\u306b\u8868\u793a\u3055\u305b\u3001\u5b9f\u8cea\u7684\u306b\u5e38\u6642\u8868\u793a\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/b><\/span>\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u306b\u3088\u308b\u67d4\u8edf\u306a\u5236\u5fa1\u306b\u3088\u308a\u3001\u6a19\u6e96\u6a5f\u80fd\u3067\u306f\u4e0d\u53ef\u80fd\u306a\u8868\u793a\u65b9\u6cd5\u3092\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002<\/p>\n

            \u57fa\u672c\u7684\u306aGAS\u30b3\u30fc\u30c9\u3067\u30e1\u30e2\u5185\u5bb9\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5<\/h3>\n

            \u30e1\u30e2\u306e\u5185\u5bb9\u3092\u53d6\u5f97\u3059\u308b\u306b\u306f\u3001getNote()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3001\u53d6\u5f97\u3057\u305f\u5185\u5bb9\u3092\u5225\u306e\u5834\u6240\u306b\u8868\u793a\u3057\u307e\u3059\u3002<\/b><\/span>\u4ee5\u4e0b\u306f\u3001\u9078\u629e\u3057\u305f\u30bb\u30eb\u306e\u30e1\u30e2\u3092\u96a3\u306e\u5217\u306b\u8868\u793a\u3059\u308b\u57fa\u672c\u7684\u306a\u30b3\u30fc\u30c9\u3067\u3059\u3002<\/p>\n

            javascript<\/p>\n

            function displayNoteInNextColumn() {<\/p>\n

            \/\/ \u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u53d6\u5f97<\/p>\n

            const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n

            const activeCell = sheet.getActiveCell();<\/p>\n

            \/\/ \u30e1\u30e2\u306e\u5185\u5bb9\u3092\u53d6\u5f97<\/p>\n

            const noteContent = activeCell.getNote();<\/p>\n

            \/\/ \u30e1\u30e2\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u3001\u96a3\u306e\u5217\u306b\u8868\u793a<\/p>\n

            if (noteContent) {<\/p>\n

            const row = activeCell.getRow();<\/p>\n

            const col = activeCell.getColumn();<\/p>\n

            sheet.getRange(row, col + 1).setValue(noteContent);}}<\/p>\n

            \u30b5\u30a4\u30c9\u30d0\u30fc\u3067\u30e1\u30e2\u3092\u5e38\u6642\u8868\u793a\u3059\u308bGAS\u306e\u5b9f\u88c5<\/h3>\n

            \u300c\u5e38\u6642\u8868\u793a\uff08\u81ea\u52d5\u66f4\u65b0\uff09\u300d\u3092\u5b9f\u73fe\u3059\u308b\u306b\u306f\u3001\u30b5\u30a4\u30c9\u30d0\u30fc\uff08HTML\uff09\u304b\u3089\u5b9a\u671f\u7684\u306b getSelectedCellNote() \u3092\u547c\u3073\u51fa\u3059\u65b9\u5f0f\u304c\u7c21\u5358\u3067\u78ba\u5b9f\u3067\u3059\u3002<\/b><\/span>\u4ee5\u4e0b\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

            Code.gs\uff08\u8ffd\u52a0\uff0f\u4fee\u6b63\uff09<\/strong><\/p>\n

            function onOpen() {<\/p>\n

            SpreadsheetApp.getUi()<\/p>\n

            .createMenu(‘\u30e1\u30e2\u8868\u793a’)<\/p>\n

            .addItem(‘\u30b5\u30a4\u30c9\u30d0\u30fc\u3092\u8868\u793a’, ‘showSidebar’)<\/p>\n

            .addToUi();}<\/p>\n

            function showSidebar() {<\/p>\n

            const html = HtmlService.createHtmlOutputFromFile(‘sidebar’)<\/p>\n

            .setTitle(‘\u30e1\u30e2\u8868\u793a\u30d1\u30cd\u30eb’)<\/p>\n

            .setWidth(300);<\/p>\n

            SpreadsheetApp.getUi().showSidebar(html);}<\/p>\n

            \/\/ \u9078\u629e\u30bb\u30eb\u306e\u30e1\u30e2\u3092\u8fd4\u3059\uff08\u7a7a\u306a\u3089\u7a7a\u6587\u5b57\uff09<\/p>\n

            function getSelectedCellNote() {<\/p>\n

            const range = SpreadsheetApp.getActive().getActiveRange();<\/p>\n

            const note = range ? range.getNote() : ”;<\/p>\n

            return {<\/p>\n

            address: range ? range.getA1Notation() : ”,<\/p>\n

            note: note || ”\u00a0\u00a0};}<\/p>\n

            sidebar.html\uff08\u65b0\u898f\u4f5c\u6210\uff09<\/strong><\/p>\n

            <!doctype html><\/p>\n

            <html><\/p>\n

            <head><\/p>\n

            <meta charset=”utf-8″><\/p>\n

            <style><\/p>\n

            body { font: 14px\/1.6 system-ui, -apple-system, “Segoe UI”, Roboto, sans-serif; margin: 12px; }<\/p>\n

            .addr { color:#666; font-size:12px; margin-bottom:6px; }<\/p>\n

            pre { white-space:pre-wrap; word-wrap:break-word; border:1px solid #ddd; padding:8px; border-radius:8px; }<\/p>\n

            .empty { color:#999; font-style:italic; }<\/p>\n

            <\/style><\/p>\n

            <\/head><\/p>\n

            <body><\/p>\n

            <div class=”addr” id=”addr”><\/div><\/p>\n

            <pre id=”note” class=”empty”>\uff08\u30e1\u30e2\u306f\u3042\u308a\u307e\u305b\u3093\uff09<\/pre><\/p>\n

            <script><\/p>\n

            const addrEl = document.getElementById(‘addr’);<\/p>\n

            const noteEl = document.getElementById(‘note’);<\/p>\n

            function refresh() {<\/p>\n

            google.script.run.withSuccessHandler(({address, note}) => {<\/p>\n

            addrEl.textContent = address ? `\u9078\u629e\u4e2d: ${address}` : ”;<\/p>\n

            if (note && note.trim()) {<\/p>\n

            noteEl.textContent = note;<\/p>\n

            noteEl.classList.remove(‘empty’);<\/p>\n

            } else {<\/p>\n

            noteEl.textContent = ‘\uff08\u30e1\u30e2\u306f\u3042\u308a\u307e\u305b\u3093\uff09’;<\/p>\n

            noteEl.classList.add(‘empty’);}<\/p>\n

            }).getSelectedCellNote();}<\/p>\n

            \/\/ \u8d77\u52d5\u6642\uff06\u5b9a\u671f\u66f4\u65b0\uff08500ms\u301c1000ms \u7a0b\u5ea6\u304c\u76ee\u5b89\uff09<\/p>\n

            refresh();<\/p>\n

            setInterval(refresh, 800);<\/p>\n

            <\/script><\/p>\n

            <\/body><\/p>\n

            <\/html><\/p>\n

            \u88dc\u8db3<\/strong>\uff1a\u30dd\u30fc\u30ea\u30f3\u30b0\u304c\u6c17\u306b\u306a\u308b\u5834\u5408\u306f\u3001\u5358\u7d14\u30c8\u30ea\u30ac\u30fc onSelectionChange(e) <\/strong>\u3092\u4f7f\u3063\u3066\u9078\u629e\u30a2\u30c9\u30ec\u30b9\u3092 PropertiesService \u306b\u4fdd\u5b58\u3057\u3001\u30b5\u30a4\u30c9\u30d0\u30fc\u306f\u305d\u306e\u5024\u3092\u53d6\u5f97\u3059\u308b\u65b9\u5f0f\u3067\u3082\u5b9f\u73fe\u3067\u304d\u307e\u3059\uff08\u305f\u3060\u3057\u30b5\u30a4\u30c9\u30d0\u30fc\u3078\u306e\u76f4\u63a5\u66f4\u65b0\u306f\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u6700\u7d42\u7684\u306b\u306f\u30b5\u30a4\u30c9\u30d0\u30fc\u5074\u306e\u53d6\u5f97\u51e6\u7406\u304c\u5fc5\u8981\u3067\u3059\uff09\u3002<\/p>\n

            HTML\u30d5\u30a1\u30a4\u30eb\uff08sidebar.html\uff09\uff1a<\/p>\n

            html<\/p>\n

            <!DOCTYPE html><\/p>\n

            <html><\/p>\n

            <head><\/p>\n

            <base target=”_top”><\/p>\n

            <style><\/p>\n

            body {<\/p>\n

            font-family: Arial, sans-serif;<\/p>\n

            padding: 10px;}<\/p>\n

            #note-content {<\/p>\n

            background-color: #fffacd;<\/p>\n

            padding: 10px;<\/p>\n

            border-radius: 5px;<\/p>\n

            margin-top: 10px;<\/p>\n

            min-height: 100px;}<\/p>\n

            button {<\/p>\n

            background-color: #4CAF50;<\/p>\n

            color: white;<\/p>\n

            padding: 10px;<\/p>\n

            border: none;<\/p>\n

            border-radius: 5px;<\/p>\n

            cursor: pointer;<\/p>\n

            width: 100%;}<\/p>\n

            <\/style><\/p>\n

            <\/head><\/p>\n

            <body><\/p>\n

            <h3>\u30bb\u30eb\u306e\u30e1\u30e2\u8868\u793a<\/h3><\/p>\n

            <button onclick=”updateNote()”>\u30e1\u30e2\u3092\u66f4\u65b0<\/button><\/p>\n

            <div id=”cell-info”><\/div><\/p>\n

            <pre id=”note-content”><\/pre><\/p>\n

            <script><\/p>\n

            function updateNote() {<\/p>\n

            google.script.run<\/p>\n

            .withSuccessHandler(displayNote)<\/p>\n

            .withFailureHandler(() => displayNote({address:”, note:”}))<\/p>\n

            .getSelectedCellNote();}<\/p>\n

            function displayNote(data) {<\/p>\n

            <div id=”cell-info”><strong>\u30bb\u30eb\uff1a<\/strong><span id=”cell-addr”><\/span><\/div><\/p>\n

            <pre id=”note-content”><\/pre><\/p>\n

            <script><\/p>\n

            function updateNote() {<\/p>\n

            google.script.run<\/p>\n

            .withSuccessHandler(displayNote)<\/p>\n

            .withFailureHandler(() => displayNote({address:”, note:”}))<\/p>\n

            .getSelectedCellNote();}<\/p>\n

            function displayNote(data) {<\/p>\n

            const addrEl = document.getElementById(‘cell-addr’);<\/p>\n

            const noteEl = document.getElementById(‘note-content’);<\/p>\n

            const addr = (data && data.address) ? data.address : ”;<\/p>\n

            const note = (data && typeof data.note === ‘string’) ? data.note : ”;<\/p>\n

            addrEl.textContent = addr || ‘\uff08\u672a\u9078\u629e\uff09’;<\/p>\n

            noteEl.textContent = note.trim() ? note : ‘\uff08\u30e1\u30e2\u306f\u3042\u308a\u307e\u305b\u3093\uff09’;}<\/p>\n

            updateNote();<\/p>\n

            setInterval(updateNote, 5000);<\/p>\n

            <\/script>}<\/p>\n

            \/\/ \u521d\u671f\u8868\u793a<\/p>\n

            updateNote();<\/p>\n

            \/\/ \u5b9a\u671f\u7684\u306b\u66f4\u65b0\uff085\u79d2\u3054\u3068\uff09<\/p>\n

            setInterval(updateNote, 5000);<\/p>\n

            <\/script><\/p>\n

            <\/body><\/p>\n

            <\/html><\/p>\n

            \u30e1\u30e2\u3092\u4e00\u89a7\u8868\u793a\u3059\u308bGAS\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u4f5c\u6210\u65b9\u6cd5\u306f\uff1f<\/h2>\n

            \u30b7\u30fc\u30c8\u5185\u306e\u3059\u3079\u3066\u306e\u30e1\u30e2\u3092\u4e00\u89a7\u8868\u793a\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3067\u3001\u30e1\u30e2\u306e\u5168\u4f53\u50cf\u3092\u628a\u63e1\u3057\u3001\u7ba1\u7406\u3092\u52b9\u7387\u5316\u3067\u304d\u307e\u3059\u3002<\/b><\/span>\u7279\u5b9a\u306e\u30b7\u30fc\u30c8\u3084\u7bc4\u56f2\u306b\u542b\u307e\u308c\u308b\u30e1\u30e2\u3092\u62bd\u51fa\u3057\u3001\u5225\u30b7\u30fc\u30c8\u306b\u307e\u3068\u3081\u3066\u8868\u793a\u3059\u308b\u6a5f\u80fd\u3092\u5b9f\u88c5\u3057\u307e\u3059\u3002<\/p>\n

            \u3059\u3079\u3066\u306e\u30e1\u30e2\u3092\u5225\u30b7\u30fc\u30c8\u306b\u51fa\u529b\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8<\/h3>\n

            \u300c\u3059\u3079\u3066\u306e\u30e1\u30e2\u300d\u3092\u6b63\u78ba\u306b\u62bd\u51fa\u3059\u308b\u306b\u306f\u3001\u30b7\u30fc\u30c8\u306e\u5168\u30b0\u30ea\u30c3\u30c9\uff08getMaxRows()\u00d7getMaxColumns()\uff09\u3092\u5bfe\u8c61\u306b getNotes() \u3092\u7528\u3044\u3066\u8d70\u67fb\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/b><\/span>\u5927\u898f\u6a21\u30b7\u30fc\u30c8\u3067\u306f\u51e6\u7406\u8ca0\u8377\u304c\u9ad8\u304f\u306a\u308b\u305f\u3081\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u5bfe\u8c61\u30b7\u30fc\u30c8\u306e\u884c\u30fb\u5217\u6570\u3092\u7e2e\u5c0f\u3057\u3066\u304b\u3089\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n

            \u30bb\u30eb\u306e\u30a2\u30c9\u30ec\u30b9\u3001\u30e1\u30e2\u5185\u5bb9\u3001\u62bd\u51fa\u65e5\u6642\uff08\u5b9f\u884c\u6642\u523b\uff09 \u306a\u3069\u306e\u60c5\u5831\u3092\u542b\u3081\u308b\u3053\u3068\u3067\u3001\u30e1\u30e2\u306e\u7ba1\u7406\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002\u203b\u30e1\u30e2\u306e\u66f4\u65b0\u65e5\u6642\u306f Apps Script \u304b\u3089\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n

            \u300c\u3059\u3079\u3066\u306e\u30e1\u30e2\u300d\u3092\u6b63\u78ba\u306b\u62bd\u51fa\u3059\u308b\u306b\u306f\u3001\u30b7\u30fc\u30c8\u306e\u5168\u30b0\u30ea\u30c3\u30c9\uff08getMaxRows()\u00d7getMaxColumns()\uff09\u3092\u5bfe\u8c61\u306b getNotes() \u3092\u7528\u3044\u3066\u8d70\u67fb\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u5927\u898f\u6a21\u30b7\u30fc\u30c8\u3067\u306f\u51e6\u7406\u8ca0\u8377\u304c\u9ad8\u304f\u306a\u308b\u305f\u3081\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u5bfe\u8c61\u30b7\u30fc\u30c8\u306e\u884c\u30fb\u5217\u6570\u3092\u7e2e\u5c0f\u3057\u3066\u304b\u3089\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n

            [\u4fee\u6b63\u304c\u5fc5\u8981\u306a\u6587\u7ae0]<\/strong><\/p>\n

            \u4e8c\u91cd\u30eb\u30fc\u30d7\u5185\u3067 getRange().getNote() \u30921\u30bb\u30eb\u305a\u3064\u547c\u3073\u51fa\u3059\u5b9f\u88c5<\/p>\n

            [\u4fee\u6b63\u304c\u5fc5\u8981\u306a\u7406\u7531]<\/strong><\/p>\n

            \u30bb\u30eb\u5358\u4f4d\u306e\u53d6\u5f97\u306f\u8457\u3057\u304f\u975e\u52b9\u7387<\/strong>\u3067\u3001\u5b9f\u884c\u6642\u9593\u8d85\u904e\u306e\u8981\u56e0\u306b\u306a\u308a\u307e\u3059\u3002Range.getNotes()\uff0fRange.getDisplayValues() \u306a\u3069\u306e\u4e00\u62ec\u53d6\u5f97<\/strong>\u306b\u7f6e\u304d\u63db\u3048\u308b\u3079\u304d\u3067\u3059\u3002<\/p>\n

            [\u4fee\u6b63\u5f8c\u306e\u6587\u7ae0]\uff08\u7f6e\u304d\u63db\u3048\u30b3\u30fc\u30c9\uff09<\/strong><\/p>\n

            function exportAllNotesToNewSheet() {<\/p>\n

            const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n

            const ss = sheet.getParent();<\/p>\n

            \/\/ \u51fa\u529b\u5148\u30b7\u30fc\u30c8\u306e\u7528\u610f<\/p>\n

            const outName = ‘\u30e1\u30e2\u4e00\u89a7_’ + sheet.getName();<\/p>\n

            const existing = ss.getSheetByName(outName);<\/p>\n

            if (existing) ss.deleteSheet(existing);<\/p>\n

            const out = ss.insertSheet(outName);<\/p>\n

            const headers = [‘\u30bb\u30eb\u756a\u5730’, ‘\u30bb\u30eb\u306e\u5024’, ‘\u30e1\u30e2\u5185\u5bb9’, ‘\u62bd\u51fa\u65e5\u6642’];<\/p>\n

            out.getRange(1, 1, 1, headers.length).setValues([headers]).setFontWeight(‘bold’);<\/p>\n

            \/\/ \u2605\u30dd\u30a4\u30f3\u30c8\uff1a\u30b7\u30fc\u30c8\u5168\u4f53\u3092\u5bfe\u8c61\u306b\u30e1\u30e2\u3092\u4e00\u62ec\u53d6\u5f97\uff08\u672c\u5f53\u306b\u300c\u5168\u90e8\u300d\u62fe\u3046\u5834\u5408\uff09<\/p>\n

            const rows = sheet.getMaxRows();<\/p>\n

            const cols = sheet.getMaxColumns();<\/p>\n

            const rng\u00a0 = sheet.getRange(1, 1, rows, cols);<\/p>\n

            const notes = rng.getNotes();\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ 2\u6b21\u5143\u914d\u5217\uff08\u5404\u30bb\u30eb\u306e\u30e1\u30e2\uff09<\/p>\n

            const values = rng.getDisplayValues(); \u00a0 \u00a0 \/\/ \u8868\u793a\u5024\u3092\u307e\u3068\u3081\u3066\u53d6\u5f97<\/p>\n

            const now = new Date();<\/p>\n

            const data = [];<\/p>\n

            for (let r = 0; r < rows; r++) {<\/p>\n

            for (let c = 0; c < cols; c++) {<\/p>\n

            const note = notes[r][c];<\/p>\n

            if (note) {<\/p>\n

            data.push([toA1(r + 1, c + 1), values[r][c], note, now]);}}}<\/p>\n

            if (data.length) {<\/p>\n

            out.getRange(2, 1, data.length, headers.length).setValues(data);<\/p>\n

            out.autoResizeColumns(1, headers.length);<\/p>\n

            out.setFrozenRows(1);<\/p>\n

            out.getRange(2, 3, data.length, 1).setBackground(‘#FFFACD’); \/\/ \u30e1\u30e2\u5217\u3092\u5f37\u8abf}<\/p>\n

            SpreadsheetApp.getUi().alert(<\/p>\n

            `\u30e1\u30e2\u306e\u62bd\u51fa\u5b8c\u4e86nn\u62bd\u51fa\u3055\u308c\u305f\u30e1\u30e2\u6570: ${data.length}\u4ef6n\u51fa\u529b\u5148\u30b7\u30fc\u30c8: ${outName}`);}<\/p>\n

            \/\/ \u5217\u756a\u53f7\u2192A1\u306e\u5217\u8a18\u6cd5\uff081\u2192A, 27\u2192AA\uff09<\/p>\n

            function toA1(row, col) {<\/p>\n

            let s = ”;<\/p>\n

            while (col > 0) {<\/p>\n

            const m = (col – 1) % 26;<\/p>\n

            s = String.fromCharCode(65 + m) + s;<\/p>\n

            col = (col – 1 – m) \/ 26;}<\/p>\n

            return s + row;}<\/p>\n

            \n
            \u904b\u7528\u30e1\u30e2<\/strong><\/span><\/div>\n
              \n
            • \u30b7\u30fc\u30c8\u304c\u975e\u5e38\u306b\u5927\u304d\u3044\u5834\u5408\u306f\u3001\u9ad8\u8ca0\u8377\u56de\u907f\u306e\u305f\u3081\u300c\u5bfe\u8c61\u5217\u30fb\u5bfe\u8c61\u884c\u3092\u4e8b\u524d\u306b\u7e2e\u5c0f\u300d\u3059\u308b\u304b\u3001\u300c\u5024\u306e\u3042\u308b\u9818\u57df\uff08getLastRow()\/getLastColumn()\uff09\u3068\u5fc5\u8981\u9818\u57df\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u300d\u306a\u3069\u3067\u8abf\u6574\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n
            • \u4e0a\u8a18\u30b3\u30fc\u30c9\u306f\u300c\u66f4\u65b0\u65e5\u6642\u300d\u3067\u306f\u306a\u304f\u62bd\u51fa\u65e5\u6642<\/strong>\u3092\u51fa\u529b\u3057\u307e\u3059\u3002\u30e1\u30e2\u306e\u66f4\u65b0\u6642\u523b\u306f\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002<\/li>\n<\/ul>\n<\/div>\n

              \u7279\u5b9a\u6761\u4ef6\u306e\u30e1\u30e2\u306e\u307f\u3092\u62bd\u51fa\u3059\u308b\u9ad8\u5ea6\u306a\u30b9\u30af\u30ea\u30d7\u30c8<\/h3>\n

              \u30ad\u30fc\u30ef\u30fc\u30c9\u691c\u7d22\u3084\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u306a\u3069\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u306b\u5408\u81f4\u3059\u308b\u30e1\u30e2\u3060\u3051\u3092\u62bd\u51fa\u3059\u308b\u6a5f\u80fd\u3092\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3067\u3001\u5927\u91cf\u306e\u30e1\u30e2\u304b\u3089\u5fc5\u8981\u306a\u60c5\u5831\u3092\u52b9\u7387\u7684\u306b\u898b\u3064\u3051\u3089\u308c\u307e\u3059\u3002<\/b><\/span><\/p>\n

              javascript<\/p>\n

              function searchNotesWithKeyword() {<\/p>\n

              const ui = SpreadsheetApp.getUi();<\/p>\n

              const res = ui.prompt(‘\u30e1\u30e2\u691c\u7d22’, ‘\u30e1\u30e2\u306b\u542b\u307e\u308c\u308b\u30ad\u30fc\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044:’, ui.ButtonSet.OK_CANCEL);<\/p>\n

              if (res.getSelectedButton() !== ui.Button.OK) return;<\/p>\n

              const keyword = (res.getResponseText() || ”).trim().toLowerCase();<\/p>\n

              if (!keyword) {<\/p>\n

              ui.alert(‘\u691c\u7d22\u30ad\u30fc\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002’);<\/p>\n

              return;}<\/p>\n

              const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n

              \/\/ \u2605\u30dd\u30a4\u30f3\u30c8\uff1a\u30b7\u30fc\u30c8\u5168\u4f53\u3092\u5bfe\u8c61\u306b\u4e00\u62ec\u53d6\u5f97\uff08\u7a7a\u30bb\u30eb\u306b\u4ed8\u3044\u305f\u30e1\u30e2\u3082\u62fe\u3046\uff09<\/p>\n

              const rows = sheet.getMaxRows();<\/p>\n

              const cols = sheet.getMaxColumns();<\/p>\n

              if (rows === 0 || cols === 0) {<\/p>\n

              ui.alert(‘\u5bfe\u8c61\u30b7\u30fc\u30c8\u306b\u30bb\u30eb\u304c\u3042\u308a\u307e\u305b\u3093\u3002’);<\/p>\n

              return;}<\/p>\n

              const rng\u00a0 \u00a0 = sheet.getRange(1, 1, rows, cols);<\/p>\n

              const notes\u00a0 = rng.getNotes();\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/\/ 2\u6b21\u5143\u914d\u5217<\/p>\n

              const values = rng.getDisplayValues();\u00a0 \u00a0 \/\/ 2\u6b21\u5143\u914d\u5217\uff08\u8868\u793a\u5024\uff09<\/p>\n

              const results = [];<\/p>\n

              for (let r = 0; r < rows; r++) {<\/p>\n

              for (let c = 0; c < cols; c++) {<\/p>\n

              const note = notes[r][c];<\/p>\n

              if (note && note.toLowerCase().includes(keyword)) {<\/p>\n

              results.push({<\/p>\n

              address: toA1(r + 1, c + 1),<\/p>\n

              value: values[r][c],<\/p>\n

              note: note,<\/p>\n

              row: r + 1,<\/p>\n

              col: c + 1<\/p>\n

              });}}}<\/p>\n

              if (results.length) {<\/p>\n

              highlightCellsWithMatchingNotes(results);<\/p>\n

              showSearchResultsSidebar(results, keyword);<\/p>\n

              } else {<\/p>\n

              ui.alert(‘\u691c\u7d22\u7d50\u679c’, `\u300c${keyword}\u300d\u3092\u542b\u3080\u30e1\u30e2\u306f\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002`, ui.ButtonSet.OK);<\/p>\n

              }}<\/p>\n

              \/\/ \u76f4\u524d\u306e\u30cf\u30a4\u30e9\u30a4\u30c8\u306e\u307f\u89e3\u9664\u3057\u3066\u304b\u3089\u4eca\u56de\u5206\u3092\u5857\u308b<\/p>\n

              function highlightCellsWithMatchingNotes(results) {<\/p>\n

              const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n

              const props = PropertiesService.getDocumentProperties();<\/p>\n

              \/\/ \u76f4\u524d\u306e\u30cf\u30a4\u30e9\u30a4\u30c8\u3092\u89e3\u9664<\/p>\n

              const prev = JSON.parse(props.getProperty(‘prevHighlighted’) || ‘[]’);<\/p>\n

              if (prev.length) {<\/p>\n

              sheet.getRangeList(prev).setBackground(null); \/\/ \u76f4\u63a5\u6307\u5b9a\u306e\u80cc\u666f\u306e\u307f\u89e3\u9664\uff08\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306f\u7dad\u6301\uff09}<\/p>\n

              \/\/ \u4eca\u56de\u306e\u30cf\u30a4\u30e9\u30a4\u30c8<\/p>\n

              const a1s = results.map(r => r.address);<\/p>\n

              if (a1s.length) sheet.getRangeList(a1s).setBackground(‘#FFD700’);<\/p>\n

              \/\/ \u8a18\u9332\u66f4\u65b0<\/p>\n

              props.setProperty(‘prevHighlighted’, JSON.stringify(a1s));}<\/p>\n

              \/\/ \u691c\u7d22\u7d50\u679c\u3092\u30b5\u30a4\u30c9\u30d0\u30fc\u306b\u5b89\u5168\u8868\u793a\uff08HTML\u30a8\u30b9\u30b1\u30fc\u30d7\uff09<\/p>\n

              function showSearchResultsSidebar(results, keyword) {<\/p>\n

              const esc = s => String(s ?? ”).replace(\/[&<>”‘]\/g, m => (<\/p>\n

              { ‘&’:’&amp;’, ‘<‘:’&lt;’, ‘>’:’&gt;’, ‘”‘:’&quot;’, “‘”:’&#39;’ }[m]));<\/p>\n

              const rows = results.map(r =><\/p>\n

              `<tr><\/p>\n

              <td>${esc(r.address)}<\/td><\/p>\n

              <td>${esc(r.value)}<\/td><\/p>\n

              <td class=”note”>${esc(r.note)}<\/td><\/p>\n

              <\/tr>`).join(”);<\/p>\n

              const html = HtmlService.createHtmlOutput(<\/p>\n

              `<!doctype html><\/p>\n

              <html><head><meta charset=”utf-8″><\/p>\n

              <style><\/p>\n

              body{font:14px\/1.6 system-ui, -apple-system, “Segoe UI”, Roboto, sans-serif; margin:12px}<\/p>\n

              h3{margin:0 0 8px}<\/p>\n

              table{border-collapse:collapse; width:100%}<\/p>\n

              th,td{border:1px solid #ddd; padding:6px; vertical-align:top}<\/p>\n

              td.note{background:#FFFACD; white-space:pre-wrap}<\/p>\n

              <\/style><\/head><\/p>\n

              <body><\/p>\n

              <h3>\u30e1\u30e2\u691c\u7d22\u7d50\u679c\uff1a\u300c${esc(keyword)}\u300d<\/h3><\/p>\n

              <div>\u30d2\u30c3\u30c8\u4ef6\u6570\uff1a${results.length}<\/div><\/p>\n

              <table><\/p>\n

              <thead><tr><th>\u30bb\u30eb\u756a\u5730<\/th><th>\u30bb\u30eb\u306e\u5024<\/th><th>\u30e1\u30e2<\/th><\/tr>&lt;\/thead><\/p>\n

              <tbody>${rows || ‘<tr><td colspan=”3″>\u8a72\u5f53\u306a\u3057<\/td><\/tr>’}<\/tbody><\/p>\n

              <\/table><\/p>\n

              <\/body><\/html>`<\/p>\n

              ).setTitle(‘\u30e1\u30e2\u691c\u7d22\u7d50\u679c’).setWidth(540);<\/p>\n

              SpreadsheetApp.getUi().showSidebar(html);}<\/p>\n

              \/\/ \u5217\u756a\u53f7\u2192A1\u8a18\u6cd5\uff081\u2192A, 27\u2192AA\uff09<\/p>\n

              function toA1(row, col) {<\/p>\n

              let s = ”;<\/p>\n

              while (col > 0) {<\/p>\n

              const m = (col – 1) % 26;<\/p>\n

              s = String.fromCharCode(65 + m) + s;<\/p>\n

              col = (col – 1 – m) \/ 26;}<\/p>\n

              return s + row;}<\/p>\n

              \n
              \u88dc\u8db3\uff08\u4efb\u610f\u306e\u6700\u9069\u5316\uff09<\/strong><\/span><\/div>\n
                \n
              • \u30b7\u30fc\u30c8\u304c\u5de8\u5927\u3067\u5168\u8d70\u67fb\u304c\u91cd\u3044\u5834\u5408\u306f\u3001getLastRow()\/getLastColumn() \u3067\u5bfe\u8c61\u3092\u7e2e\u5c0f\u3059\u308b\u3001\u3082\u3057\u304f\u306f\u691c\u7d22\u5bfe\u8c61\u30b7\u30fc\u30c8\u3092\u5206\u3051\u308b\u904b\u7528\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n
              • \u5927\u6587\u5b57\u5c0f\u6587\u5b57\u3092\u533a\u5225\u3057\u305f\u3044\u5834\u5408\u306f .toLowerCase() \u3092\u5916\u3057\u3001includes(keyword) \u306e\u4ee3\u308f\u308a\u306b indexOf(keyword) >= 0 \u306a\u3069\u3078\u8abf\u6574\u3067\u304d\u307e\u3059\u3002<\/li>\n<\/ul>\n<\/div>\n

                \u30e1\u30e2\u6a5f\u80fd\u3092\u696d\u52d9\u3067\u52b9\u679c\u7684\u306b\u6d3b\u7528\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h2>\n

                \u30e1\u30e2\u6a5f\u80fd\u3092\u696d\u52d9\u3067\u6700\u5927\u9650\u6d3b\u7528\u3059\u308b\u306b\u306f\u3001\u30c1\u30fc\u30e0\u5185\u3067\u30eb\u30fc\u30eb\u3092\u7d71\u4e00\u3057\u3001\u5b9a\u671f\u7684\u306a\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u3092\u884c\u3046\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<\/b><\/span>\u5358\u306a\u308b\u5099\u5fd8\u9332\u3068\u3057\u3066\u3067\u306f\u306a\u304f\u3001\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u306e\u4e00\u90e8\u3068\u3057\u3066\u7d44\u307f\u8fbc\u3080\u3053\u3068\u3067\u3001\u60c5\u5831\u5171\u6709\u306e\u8cea\u304c\u5411\u4e0a\u3057\u307e\u3059\u3002<\/p>\n

                \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7ba1\u7406\u3067\u306e\u6d3b\u7528\u4f8b<\/h3>\n

                \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7ba1\u7406\u306b\u304a\u3044\u3066\u306f\u3001\u30bf\u30b9\u30af\u306e\u8a73\u7d30\u60c5\u5831\u3084\u9032\u6357\u306e\u80cc\u666f\u8aac\u660e\u3092\u30e1\u30e2\u306b\u8a18\u9332\u3059\u308b\u3053\u3068\u3067\u3001\u30e1\u30a4\u30f3\u306e\u30b7\u30fc\u30c8\u3092\u30b7\u30f3\u30d7\u30eb\u306b\u4fdd\u3061\u306a\u304c\u3089\u5fc5\u8981\u306a\u60c5\u5831\u3092\u7ba1\u7406\u3067\u304d\u307e\u3059\u3002<\/b><\/span><\/p>\n

                \n
                \u52b9\u679c\u7684\u306a\u6d3b\u7528\u30d1\u30bf\u30fc\u30f3<\/strong><\/span><\/div>\n
                  \n
                • \u30bf\u30b9\u30af\u7ba1\u7406\u30b7\u30fc\u30c8\uff1a\u5404\u30bf\u30b9\u30af\u306e\u8a73\u7d30\u306a\u8981\u4ef6\u3084\u6ce8\u610f\u4e8b\u9805\u3092\u30e1\u30e2\u306b\u8a18\u8f09<\/li>\n
                • \u4e88\u7b97\u7ba1\u7406\u8868\uff1a\u8cbb\u7528\u306e\u5185\u8a33\u3084\u627f\u8a8d\u7d4c\u7def\u3092\u30e1\u30e2\u3067\u88dc\u8db3<\/li>\n
                • \u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u8868\uff1a\u65e5\u7a0b\u5909\u66f4\u306e\u7406\u7531\u3084\u95a2\u9023\u3059\u308b\u4f1a\u8b70\u60c5\u5831\u3092\u8a18\u9332<\/li>\n<\/ul>\n<\/div>\n

                  \u30c7\u30fc\u30bf\u5206\u6790\u3067\u306e\u6d3b\u7528\u65b9\u6cd5<\/h3>\n

                  \u30c7\u30fc\u30bf\u5206\u6790\u3067\u306f\u3001\u6570\u5024\u306e\u80cc\u666f\u306b\u3042\u308b\u4eee\u5b9a\u3084\u8a08\u7b97\u6839\u62e0\u3092\u30e1\u30e2\u306b\u6b8b\u3059\u3053\u3068\u3067\u3001\u5f8c\u304b\u3089\u898b\u8fd4\u3057\u305f\u969b\u306e\u7406\u89e3\u3092\u52a9\u3051\u3001\u5206\u6790\u306e\u518d\u73fe\u6027\u3092\u9ad8\u3081\u307e\u3059\u3002<\/b><\/span><\/p>\n

                  \n
                  \u5206\u6790\u696d\u52d9\u3067\u306e\u5177\u4f53\u4f8b<\/strong><\/span><\/div>\n
                    \n
                  • \u7570\u5e38\u5024\u306e\u8aac\u660e\uff1a\u30c7\u30fc\u30bf\u30af\u30ec\u30f3\u30b8\u30f3\u30b0\u3067\u9664\u5916\u3057\u305f\u7406\u7531<\/li>\n
                  • \u8a08\u7b97\u5f0f\u306e\u88dc\u8db3\uff1a\u8907\u96d1\u306a\u8a08\u7b97\u306e\u8003\u3048\u65b9\u3084\u53c2\u7167\u5143<\/li>\n
                  • \u4eee\u5b9a\u306e\u8a18\u9332\uff1a\u4e88\u6e2c\u30e2\u30c7\u30eb\u3067\u4f7f\u7528\u3057\u305f\u524d\u63d0\u6761\u4ef6<\/li>\n<\/ul>\n<\/div>\n

                    \u30c1\u30fc\u30e0\u3067\u306e\u30e1\u30e2\u904b\u7528\u30eb\u30fc\u30eb<\/h3>\n

                    \u30c1\u30fc\u30e0\u5168\u4f53\u3067\u30e1\u30e2\u306e\u66f8\u304d\u65b9\u3084\u4f7f\u3044\u65b9\u306e\u30eb\u30fc\u30eb\u3092\u5b9a\u3081\u308b\u3053\u3068\u3067\u3001\u60c5\u5831\u306e\u4e00\u8cab\u6027\u3068\u691c\u7d22\u6027\u304c\u5411\u4e0a\u3057\u307e\u3059\u3002<\/b><\/span>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30eb\u30fc\u30eb\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3092\u63a8\u5968\u3057\u307e\u3059\u3002<\/p>\n

                    \n
                    \u63a8\u5968\u30eb\u30fc\u30eb\u306e\u4f8b<\/strong><\/span><\/div>\n
                      \n
                    1. \u8a18\u8f09\u5f62\u5f0f\u306e\u7d71\u4e00
                      \n[\u65e5\u4ed8]\u8a18\u8f09\u8005\u540d
                      \n\u5185\u5bb9\uff1a\u301c\u301c\u301c
                      \n\u7406\u7531\uff1a\u301c\u301c\u301c<\/li>\n
                    2. \u30ab\u30c6\u30b4\u30ea\u30bf\u30b0\u306e\u4f7f\u7528\n
                        \n
                      • #\u91cd\u8981\uff1a\u512a\u5148\u5ea6\u306e\u9ad8\u3044\u60c5\u5831<\/li>\n
                      • #\u78ba\u8a8d\u6e08\uff1a\u30ec\u30d3\u30e5\u30fc\u5b8c\u4e86<\/li>\n
                      • #\u8981\u66f4\u65b0\uff1a\u60c5\u5831\u306e\u66f4\u65b0\u304c\u5fc5\u8981<\/li>\n<\/ul>\n<\/li>\n
                      • \u5b9a\u671f\u7684\u306a\u68da\u5378\u3057\n
                          \n
                        • \u6708\u6b21\u3067\u30e1\u30e2\u306e\u6574\u7406<\/li>\n
                        • \u4e0d\u8981\u306a\u30e1\u30e2\u306e\u524a\u9664<\/li>\n
                        • \u91cd\u8981\u30e1\u30e2\u306e\u6587\u66f8\u5316<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/div>\n

                          \u30e1\u30e2\u306e\u8868\u793a\u3092\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3059\u308bGAS\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\u306f\uff1f<\/h2>\n

                          GAS\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30e1\u30e2\u306e\u8868\u793a\u65b9\u6cd5\u3092\u696d\u52d9\u30cb\u30fc\u30ba\u306b\u5408\u308f\u305b\u3066\u81ea\u7531\u306b\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3067\u304d\u307e\u3059\u3002<\/b><\/span>\u6761\u4ef6\u306b\u5fdc\u3058\u305f\u52d5\u7684\u306a\u8868\u793a\u3084\u3001\u8996\u899a\u7684\u306a\u30a4\u30f3\u30b8\u30b1\u30fc\u30bf\u30fc\u306e\u8ffd\u52a0\u306a\u3069\u3001\u9ad8\u5ea6\u306a\u6a5f\u80fd\u3092\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002<\/p>\n

                          \u91cd\u8981\u5ea6\u306b\u5fdc\u3058\u3066\u30e1\u30e2\u3092\u8272\u5206\u3051\u8868\u793a\u3059\u308b<\/h3>\n

                          \u30e1\u30e2\u306e\u5185\u5bb9\u306b\u7279\u5b9a\u306e\u30ad\u30fc\u30ef\u30fc\u30c9\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u30bb\u30eb\u306e\u8272\u3092\u81ea\u52d5\u7684\u306b\u5909\u66f4\u3059\u308b\u3053\u3068\u3067\u3001\u91cd\u8981\u306a\u60c5\u5831\u3092\u898b\u9003\u3055\u306a\u3044\u3088\u3046\u306b\u3067\u304d\u307e\u3059\u3002<\/b><\/span><\/p>\n

                          javascript<\/p>\n

                          \/** \u30e1\u30cb\u30e5\u30fc\u8ffd\u52a0\uff08\u62e1\u5f35\u6a5f\u80fd \u2192 \u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3001\u3067\u3082\u53ef\uff09 *\/<\/p>\n

                          function onOpen() {<\/p>\n

                          SpreadsheetApp.getUi()<\/p>\n

                          .createMenu(‘\u30e1\u30e2\u30c4\u30fc\u30eb’)<\/p>\n

                          .addItem(‘\u30e1\u30e2\u3067\u8272\u5206\u3051\u3092\u5b9f\u884c’, ‘colorCellsByNoteContent’)<\/p>\n

                          .addItem(‘\u76f4\u524d\u306e\u8272\u5206\u3051\u3092\u89e3\u9664’, ‘clearLastNoteColoring’)<\/p>\n

                          .addToUi();}<\/p>\n

                          \/** \u8272\u5206\u3051\u30eb\u30fc\u30eb\u3092\u3053\u3053\u3067\u5b9a\u7fa9 *\/<\/p>\n

                          const NOTE_COLOR_RULES = {<\/p>\n

                          ‘\u91cd\u8981’: ‘#FF6B6B’, \u00a0 \/\/ \u8d64<\/p>\n

                          ‘\u78ba\u8a8d’: ‘#FFD93D’, \u00a0 \/\/ \u9ec4<\/p>\n

                          ‘\u5b8c\u4e86’: ‘#6BCF7F’, \u00a0 \/\/ \u7dd1<\/p>\n

                          ‘\u4fdd\u7559’: ‘#95E1D3’\u00a0 \u00a0 \/\/ \u9752\u7dd1};<\/p>\n

                          \/** \u30e1\u30e2\u5185\u5bb9\u306b\u5fdc\u3058\u3066\u30bb\u30eb\u80cc\u666f\u8272\u3092\u8a2d\u5b9a\uff08\u9ad8\u901f\u30fb\u5b89\u5168\u7248\uff09 *\/<\/p>\n

                          function colorCellsByNoteContent() {<\/p>\n

                          const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n

                          const props = PropertiesService.getDocumentProperties();<\/p>\n

                          \/\/ \u25bc \u76f4\u524d\u306e\u30cf\u30a4\u30e9\u30a4\u30c8\u3060\u3051\u89e3\u9664\uff08\u65e2\u5b58\u306e\u914d\u8272\u30fb\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306f\u4fdd\u6301\uff09<\/p>\n

                          clearLastNoteColoring();<\/p>\n

                          \/\/ \u25bc \u30b7\u30fc\u30c8\u5168\u4f53\uff08\u7a7a\u30bb\u30eb\u306e\u30e1\u30e2\u3082\u5bfe\u8c61\uff09\u3092\u4e00\u62ec\u53d6\u5f97<\/p>\n

                          const rows = sheet.getMaxRows();<\/p>\n

                          const cols = sheet.getMaxColumns();<\/p>\n

                          if (!rows || !cols) return;<\/p>\n

                          const rng \u00a0 = sheet.getRange(1, 1, rows, cols);<\/p>\n

                          const notes = rng.getNotes(); \/\/ 2\u6b21\u5143\u914d\u5217<\/p>\n

                          \/\/ \u30eb\u30fc\u30eb\u3054\u3068\u306b A1 \u4e00\u89a7\u3092\u30d0\u30b1\u30c3\u30c8\u5316<\/p>\n

                          const buckets = Object.fromEntries(Object.keys(NOTE_COLOR_RULES).map(k => [k, []]));<\/p>\n

                          for (let r = 0; r < rows; r++) {<\/p>\n

                          for (let c = 0; c < cols; c++) {<\/p>\n

                          const note = notes[r][c];<\/p>\n

                          if (!note) continue;<\/p>\n

                          for (const [kw, color] of Object.entries(NOTE_COLOR_RULES)) {<\/p>\n

                          if (note.indexOf(kw) !== -1) { \/\/ \u5927\u6587\u5b57\u5c0f\u6587\u5b57\u533a\u5225\u304c\u4e0d\u8981\u306a\u3089 toLowerCase() \u3057\u3066\u6bd4\u8f03<\/p>\n

                          buckets[kw].push(toA1(r + 1, c + 1));<\/p>\n

                          break; \/\/ \u6700\u521d\u306b\u30de\u30c3\u30c1\u3057\u305f\u30eb\u30fc\u30eb\u3067\u78ba\u5b9a}}}}<\/p>\n

                          \/\/ \u25bc \u5bfe\u8c61\u30bb\u30eb\u3060\u3051\u3092\u7740\u8272\uff08\u5168\u4f53\u30ea\u30bb\u30c3\u30c8\u306f\u3057\u306a\u3044\uff09<\/p>\n

                          const applied = [];<\/p>\n

                          for (const [kw, a1s] of Object.entries(buckets)) {<\/p>\n

                          if (a1s.length) {<\/p>\n

                          sheet.getRangeList(a1s).setBackground(NOTE_COLOR_RULES[kw]);<\/p>\n

                          applied.push(…a1s);}}<\/p>\n

                          \/\/ \u4eca\u56de\u9069\u7528\u3057\u305f\u30bb\u30eb\u3092\u8a18\u9332\uff08\u6b21\u56de\u306e\u89e3\u9664\u7528\uff09<\/p>\n

                          props.setProperty(‘prevHighlighted’, JSON.stringify(applied));}<\/p>\n

                          \/** \u76f4\u524d\u306e\u8272\u5206\u3051\u3060\u3051\u3092\u89e3\u9664\uff08\u5168\u4f53\u306f\u89e6\u3089\u306a\u3044\uff09 *\/<\/p>\n

                          function clearLastNoteColoring() {<\/p>\n

                          const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n

                          const props = PropertiesService.getDocumentProperties();<\/p>\n

                          const prev = JSON.parse(props.getProperty(‘prevHighlighted’) || ‘[]’);<\/p>\n

                          if (prev.length) {<\/p>\n

                          sheet.getRangeList(prev).setBackground(null);<\/p>\n

                          props.deleteProperty(‘prevHighlighted’);}}<\/p>\n

                          \/** \u5217\u756a\u53f7\u2192A1\u8a18\u6cd5\uff081\u2192A, 27\u2192AA\uff09 *\/<\/p>\n

                          function toA1(row, col) {<\/p>\n

                          let s = ”;<\/p>\n

                          while (col > 0) {<\/p>\n

                          const m = (col – 1) % 26;<\/p>\n

                          s = String.fromCharCode(65 + m) + s;<\/p>\n

                          col = (col – 1 – m) \/ 26;}<\/p>\n

                          return s + row;}<\/p>\n

                          \u30e1\u30e2\u306e\u5185\u5bb9\u3092\u81ea\u52d5\u3067\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u8868\u793a<\/h3>\n

                          \u7279\u5b9a\u306e\u30bb\u30eb\u304c\u9078\u629e\u3055\u308c\u305f\u969b\u306b\u3001\u30e1\u30e2\u306e\u5185\u5bb9\u3092\u81ea\u52d5\u7684\u306b\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u3067\u8868\u793a\u3059\u308b\u6a5f\u80fd\u3092\u5b9f\u88c5\u3067\u304d\u307e\u3059\u3002<\/b><\/span>\u3053\u308c\u306b\u3088\u308a\u3001\u30de\u30a6\u30b9\u30aa\u30fc\u30d0\u30fc\u3057\u306a\u304f\u3066\u3082\u30e1\u30e2\u5185\u5bb9\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n

                          \/** ================================<\/p>\n

                          * \u30e1\u30e2\u306e\u5b89\u5168\u8868\u793a\uff06\u30e1\u30cb\u30e5\u30fc\u8ffd\u52a0\uff08\u4e38\u3054\u3068\u5dee\u3057\u66ff\u3048\uff09<\/p>\n

                          * ================================ *\/<\/p>\n

                          \/** HTML\u57cb\u3081\u8fbc\u307f\u7528\u306e\u7c21\u6613\u30a8\u30b9\u30b1\u30fc\u30d7 *\/<\/p>\n

                          function _esc(s) {<\/p>\n

                          return String(s ?? ”).replace(\/[&<>”‘]\/g, m => (<\/p>\n

                          { ‘&’:’&amp;’, ‘<‘:’&lt;’, ‘>’:’&gt;’, ‘”‘:’&quot;’, “‘”:’&#39;’ }[m]));}<\/p>\n

                          \/** \u9078\u629e\u30bb\u30eb\u306e\u30e1\u30e2\u3092\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u8868\u793a\uff08XSS\u5bfe\u7b56\u6e08\u307f\uff09 *\/<\/p>\n

                          function showNotePopup() {<\/p>\n

                          const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n

                          const cell\u00a0 = sheet.getActiveCell();<\/p>\n

                          if (!cell) {<\/p>\n

                          SpreadsheetApp.getUi().alert(‘\u30bb\u30eb\u304c\u9078\u629e\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002’);<\/p>\n

                          return;}<\/p>\n

                          const note = cell.getNote();<\/p>\n

                          if (!note) {<\/p>\n

                          SpreadsheetApp.getUi().alert(‘\u3053\u306e\u30bb\u30eb\u306b\u306f\u30e1\u30e2\u304c\u3042\u308a\u307e\u305b\u3093\u3002’);<\/p>\n

                          return;}<\/p>\n

                          const cellAddress = cell.getA1Notation();<\/p>\n

                          const html = HtmlService.createHtmlOutput(<\/p>\n

                          `<!doctype html><meta charset=”utf-8″><\/p>\n

                          <div style=”font-family:system-ui, Arial, sans-serif;”><\/p>\n

                          <h3 style=”color:#333; margin:0 0 8px;”>\u30bb\u30eb ${_esc(cellAddress)} \u306e\u30e1\u30e2<\/h3><\/p>\n

                          <div style=”<\/p>\n

                          background:#FFFACD;<\/p>\n

                          padding:15px;<\/p>\n

                          border-radius:8px;<\/p>\n

                          margin:10px 0;<\/p>\n

                          white-space:pre-wrap;<\/p>\n

                          word-wrap:break-word;<\/p>\n

                          “>${_esc(note)}<\/div><\/p>\n

                          <\/div>`<\/p>\n

                          ).setWidth(420).setHeight(300);<\/p>\n

                          SpreadsheetApp.getUi().showModalDialog(html, ‘\u30e1\u30e2\u5185\u5bb9’);}<\/p>\n

                          \/** \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3092\u958b\u3044\u305f\u3089\u30ab\u30b9\u30bf\u30e0\u30e1\u30cb\u30e5\u30fc\u3092\u81ea\u52d5\u8ffd\u52a0 *\/<\/p>\n

                          function onOpen() {<\/p>\n

                          SpreadsheetApp.getUi()<\/p>\n

                          .createMenu(‘\u30e1\u30e2\u30c4\u30fc\u30eb’)<\/p>\n

                          .addItem(‘\u9078\u629e\u30bb\u30eb\u306e\u30e1\u30e2\u3092\u8868\u793a’, ‘showNotePopup’)<\/p>\n

                          .addItem(‘\u30e1\u30e2\u3092\u8272\u5206\u3051’, ‘colorCellsByNoteContent’)\u00a0 \u00a0\/\/ \u65e2\u5b58\u306e\u95a2\u6570\u304c\u5225\u9014\u3042\u308b\u60f3\u5b9a<\/p>\n

                          .addItem(‘\u30e1\u30e2\u4e00\u89a7\u3092\u51fa\u529b’, ‘exportAllNotesToNewSheet’)\u00a0 \/\/ \u65e2\u5b58\u306e\u95a2\u6570\u304c\u5225\u9014\u3042\u308b\u60f3\u5b9a<\/p>\n

                          .addSeparator()<\/p>\n

                          .addItem(‘\u30e1\u30e2\u3092\u691c\u7d22’, ‘searchNotesWithKeyword’)\u00a0 \u00a0\/\/ \u65e2\u5b58\u306e\u95a2\u6570\u304c\u5225\u9014\u3042\u308b\u60f3\u5b9a<\/p>\n

                          .addToUi();}<\/p>\n

                          \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30e1\u30e2\u3092\u5e38\u306b\u8868\u793a\u3059\u308b\u306b\u306fGAS\u3092\u6d3b\u7528<\/h2>\n

                          \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306f\u6a19\u6e96\u6a5f\u80fd\u3060\u3051\u3067\u306f\u30e1\u30e2\u306e\u5e38\u6642\u8868\u793a\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u30b3\u30e1\u30f3\u30c8\u5207\u66ff\u30fb\u5c02\u7528\u5217\u30fb\u63cf\u753b\u30c6\u30ad\u30b9\u30c8\u3068\u3044\u3063\u305f\u4ee3\u66ff\u624b\u6bb5\u306b\u52a0\u3048\u3001GAS\u306e\u30b5\u30a4\u30c9\u30d0\u30fc\u8868\u793a\u3084\u4e00\u89a7\u51fa\u529b\u3092\u7d44\u307f\u5408\u308f\u305b\u308c\u3070\u3001\u5b9f\u8cea\u7684\u306a\u201c\u5e38\u6642\u53ef\u8996\u5316\u201d\u304c\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n

                          \u91cd\u8981\u5ea6\u3067\u8272\u5206\u3051\u3001\u30ad\u30fc\u30ef\u30fc\u30c9\u691c\u7d22\u3001\u9078\u629e\u30bb\u30eb\u306e\u30dd\u30c3\u30d7\u30a2\u30c3\u30d7\u306a\u3069\u3092\u52a0\u3048\u308b\u3068\u3001\u898b\u843d\u3068\u3057\u3092\u9632\u304e\u3064\u3064\u904b\u7528\u52b9\u7387\u304c\u5411\u4e0a\u3057\u307e\u3059\u3002<\/p>\n

                          \u672c\u8a18\u4e8b\u3067\u7d39\u4ecb\u3057\u305fGAS\u30b3\u30fc\u30c9\u3092\u57fa\u306b\u3001\u30c1\u30fc\u30e0\u306e\u30cb\u30fc\u30ba\u306b\u5408\u308f\u305b\u305f\u72ec\u81ea\u306e\u30e1\u30e2\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u3092\u69cb\u7bc9\u3057\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306e\u4f5c\u696d\u52b9\u7387\u3092\u6700\u5927\u5316\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

                          Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google Sheets\uff09\u306e\u30e1\u30e2\u6a5f\u80fd\u306f\u3001\u30bb\u30eb\u306b\u88dc\u8db3\u60c5\u5831\u3092\u8ffd\u52a0\u3067\u304d\u308b\u4fbf\u5229\u306a\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001\u901a\u5e38\u306f\u30de\u30a6\u30b9\u30aa\u30fc\u30d0\u30fc\u6642\u306e\u307f\u8868\u793a\u3055\u308c\u308b\u305f\u3081\u3001\u91cd\u8981\u306a\u60c5\u5831\u3092\u898b\u9003\u3057\u304c\u3061\u3067\u3059\u3002 \u672c\u8a18\u4e8b\u3067\u306f\u3001\u30e1\u30e2\u3092\u5e38\u6642\u8868\u793a\u3055\u305b […]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-21128","post","type-post","status-publish","format-standard","hentry","category-excel"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/21128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/comments?post=21128"}],"version-history":[{"count":16,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/21128\/revisions"}],"predecessor-version":[{"id":21411,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/21128\/revisions\/21411"}],"wp:attachment":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/media?parent=21128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/categories?post=21128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/tags?post=21128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}