{"id":136,"date":"2025-05-22T16:19:41","date_gmt":"2025-05-22T07:19:41","guid":{"rendered":"https:\/\/cg-method.com\/google\/?p=136"},"modified":"2026-10-02T21:49:41","modified_gmt":"2026-10-02T12:49:41","slug":"google-sheets-output-hyperlink","status":"publish","type":"post","link":"https:\/\/cg-method.com\/google\/google-sheets-output-hyperlink\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u6587\u5b57\u306bURL\u30ea\u30f3\u30af\u3092\u8cbc\u308b\u65b9\u6cd5\u3068\u30ea\u30f3\u30af\u304b\u3089URL\u3092\u62bd\u51fa\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u6587\u5b57\u3078\u30ea\u30f3\u30af\u3092\u4ed8\u3051\u308b\u64cd\u4f5c\u3068\u3001\u8868\u793a\u540d\u304b\u3089URL\u3092\u53d6\u308a\u51fa\u3059\u64cd\u4f5c\u3092\u5206\u3051\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5143\u306eURL\u3092\u5217\u306b\u6b8b\u3057\u3066\u304a\u304f\u3068\u3001\u5f8c\u304b\u3089\u30ea\u30f3\u30af\u5148\u3092\u78ba\u8a8d\u3057\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-cell-ui-practice-20261002.zip\">\u7df4\u7fd2\u30c7\u30fc\u30bf\u30fb\u30b9\u30e9\u30a4\u30c9\u30fbPDF\u30fb\u30b3\u30fc\u30c9TXT\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b<\/a>\u3068\u3001\u540c\u3058\u5165\u529b\u3067\u8a66\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u52d9\u30d5\u30a1\u30a4\u30eb\u306f\u5909\u66f4\u524d\u306b\u30b3\u30d4\u30fc\u3092\u4f5c\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u753b\u9762\u306f2026\u5e7410\u67082\u65e5\u306e\u30d1\u30bd\u30b3\u30f3\u306e\u30d6\u30e9\u30a6\u30b6\u30fc\u7248\u3067\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">URL\u5217\u304b\u3089HYPERLINK\u3067\u4f5c\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">link-practice.tsv\u3092\u30ea\u30f3\u30af\u30b7\u30fc\u30c8\u306eA1\u3078\u8cbc\u308b\u3068\u3001A\u5217\u306bURL\u3001B\u5217\u306bGoogle\u3068Unity\u304c\u5165\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">C2\u3078\u6b21\u306e\u5f0f\u3092\u5165\u308c\u3001C3\u3078\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=HYPERLINK(A2,B2)<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">C2\u306b\u306fGoogle\u3001C3\u306b\u306fUnity\u304c\u8868\u793a\u3055\u308c\u3001\u30ea\u30f3\u30af\u5148\u306f\u305d\u308c\u305e\u308cA\u5217\u306eURL\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">URL\u3092\u5f0f\u3078\u76f4\u63a5\u66f8\u304f\u5834\u5408\u306f\u6b21\u306e\u5f62\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=HYPERLINK(&quot;https:\/\/cg-method.com\/google\/&quot;,&quot;Google&quot;)<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-cell-ui-07-136-native-1.jpg\" alt=\"\u6570\u5f0f\u30ea\u30f3\u30af\u3068\u88c5\u98fe\u30ea\u30f3\u30af\u3001\u901a\u5e38\u306e\u30bb\u30eb\u53c2\u7167\u3092\u6bd4\u3079\u305f\u8868\" width=\"910\" height=\"240\" class=\"wp-image-23565\" srcset=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-cell-ui-07-136-native-1.jpg 910w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-cell-ui-07-136-native-1-300x79.jpg 300w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-google-cell-ui-07-136-native-1-768x203.jpg 768w\" sizes=\"auto, (max-width: 910px) 100vw, 910px\" \/><figcaption class=\"wp-element-caption\">C\u5217\u306fHYPERLINK\u3001D\u5217\u306f\u88c5\u98fe\u30ea\u30f3\u30af\u3001E\u5217\u306f\u30bb\u30eb\u53c2\u7167\u30022026\/10\/02\u6642\u70b9\u306e\u8868\u793a\u3002<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Ctrl+K\u3067\u8868\u793a\u6587\u5b57\u3078\u30ea\u30f3\u30af\u3092\u4ed8\u3051\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">D2\u3078Google\u3001D3\u3078Unity\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5bfe\u8c61\u30bb\u30eb\u3092\u9078\u3073\u3001Ctrl+K\uff08Mac\u306fCommand+K\uff09\u3067URL\u3092\u5165\u308c\u3066\u9069\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9069\u7528\u5f8c\u306f\u5b9f\u969b\u306e\u30ea\u30f3\u30af\u5148\u3092\u78ba\u8a8d\u3057\u3001\u610f\u56f3\u3057\u306a\u3044\u30bb\u30eb\u306b\u4ed8\u3044\u305f\u5834\u5408\u306f\u30ea\u30f3\u30af\u306e\u524a\u9664\u3067\u623b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u65b9\u6cd5\u306f\u30bb\u30eb\u306e\u6587\u5b57\u306b\u30ea\u30f3\u30af\u5c5e\u6027\u3092\u4ed8\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4eca\u56de\u306eGoogle Sheets\u3067\u306f\u3001E2\u3078D2\u306e\u30bb\u30eb\u53c2\u7167\u3092\u5165\u308c\u308b\u3068\u8868\u793a\u540dGoogle\u3068\u30ea\u30f3\u30af\u5c5e\u6027\u304c\u5f15\u304d\u7d99\u304c\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u305f\u3060\u3057\u3001\u30bb\u30eb\u306e\u6587\u5b57\u5217\u3068\u3057\u3066URL\u3060\u3051\u3092\u8fd4\u3059\u5f0f\u306b\u306f\u306a\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">URL\u304c\u5fc5\u8981\u306a\u51e6\u7406\u306b\u306fA\u5217\u306eURL\u3092\u6e21\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u88c5\u98fe\u30ea\u30f3\u30af\u304b\u3089URL\u3092\u53d6\u308a\u51fa\u3059GAS<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">URL\u5217\u304c\u6b8b\u3063\u3066\u3044\u306a\u3044\u5834\u5408\u306e\u88dc\u52a9\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u62e1\u5f35\u6a5f\u80fd \u2192 Apps Script\u3078\u6b21\u306e\u95a2\u6570\u3060\u3051\u3092\u8cbc\u308a\u3001\u4fdd\u5b58\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30b7\u30fc\u30c8\u540d\u3092\u542b\u3081\u3066\u6307\u5b9a\u3059\u308b\u305f\u3081\u3001\u5225\u306e\u30bf\u30d6\u3092\u958b\u3044\u305f\u72b6\u614b\u3067\u3082\u53c2\u7167\u5148\u304c\u66d6\u6627\u306b\u306a\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\"><code>function getHyperlinks(rangeA1Notation) {\n  if (typeof rangeA1Notation !== &#x27;string&#x27; || !rangeA1Notation.includes(&#x27;!&#x27;)) {\n    throw new Error(&#x27;\u30b7\u30fc\u30c8\u540d\u3092\u542b\u3081\u3066\u6307\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u4f8b: \u30ea\u30f3\u30af!D2:D4&#x27;);\n  }\n  const range = SpreadsheetApp.getActiveSpreadsheet().getRange(rangeA1Notation);\n  if (range.getNumRows() * range.getNumColumns() &gt; 1000) {\n    throw new Error(&#x27;1\u56de\u306e\u5bfe\u8c61\u306f1000\u30bb\u30eb\u4ee5\u5185\u306b\u3057\u3066\u304f\u3060\u3055\u3044&#x27;);\n  }\n  return range.getRichTextValues().map(row =&gt;\n    row.map(value =&gt; value ? (value.getLinkUrl() || &#x27;&#x27;) : &#x27;&#x27;)\n  );\n}<\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u30ea\u30f3\u30af\u30b7\u30fc\u30c8\u306eF2:F4\u3092\u7a7a\u3051\u3001F2\u3078\u6b21\u306e\u5f0f\u3092\u5165\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D2\u30fbD3\u306f1\u30bb\u30eb\u306b1\u3064\u306e\u88c5\u98fe\u30ea\u30f3\u30af\u3001D4\u306f\u30ea\u30f3\u30af\u306a\u3057\u3068\u3044\u3046\u6587\u5b57\u3060\u3051\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=getHyperlinks(&quot;\u30ea\u30f3\u30af!D2:D4&quot;)<\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-native-followup-136-native.jpg\" alt=\"Google Sheets\u306eGAS\u3067\u88c5\u98fe\u30ea\u30f3\u30af\u304b\u3089Google\u3068Unity\u306eURL\u3092\u53d6\u5f97\u3057\u3001\u30ea\u30f3\u30af\u306a\u3057\u306e\u30bb\u30eb\u306f\u7a7a\u6b04\u306b\u306a\u3063\u305f\u5b9f\u753b\u9762\" width=\"1065\" height=\"217\" class=\"wp-image-23571\" srcset=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-native-followup-136-native.jpg 1065w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-native-followup-136-native-300x61.jpg 300w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-native-followup-136-native-1024x209.jpg 1024w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/10\/cgm-native-followup-136-native-768x156.jpg 768w\" sizes=\"auto, (max-width: 1065px) 100vw, 1065px\" \/><figcaption class=\"wp-element-caption\">GAS\u306e\u5b9f\u884c\u7d50\u679c\u3002F2\u306fGoogle\u306eURL\u3001F3\u306fUnity\u306eURL\u3001F4\u306f\u7a7a\u6b04\u30022026\/10\/02\u6642\u70b9\u306e\u8868\u793a\u3002<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b9f\u884c\u7d50\u679c\u306fF2\u304cGoogle\u306eURL\u3001F3\u304cUnity\u306eURL\u3001F4\u304c\u7a7a\u6b04\u3067\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u30bb\u30eb\u306b\u7570\u306a\u308b\u30ea\u30f3\u30af\u304c\u8907\u6570\u3042\u308b\u5834\u5408\u3001getLinkUrl\u306fnull\u306b\u306a\u308b\u305f\u3081\u3001\u3053\u306e\u7c21\u6613\u7248\u3067\u306f\u7a7a\u6b04\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">HYPERLINK\u3084\u5404\u7a2e\u306e\u81ea\u52d5\u30ea\u30f3\u30af\u307e\u3067\u540c\u3058\u53d6\u5f97\u7d50\u679c\u306b\u306a\u308b\u3068\u6271\u308f\u305a\u3001\u307e\u305a\u88c5\u98fe\u30ea\u30f3\u30af\u306e\u4f8b\u3067\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u66f4\u65b0\u3055\u308c\u306a\u3044\u30fb\u5c55\u958b\u3067\u304d\u306a\u3044\u3068\u304d\u3068\u623b\u3057\u65b9<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u56f2\u3092\u6587\u5b57\u5217\u3067\u6e21\u3059\u95a2\u6570\u306f\u3001\u30ea\u30f3\u30af\u5148\u306e\u5909\u66f4\u3060\u3051\u3067\u306f\u518d\u8a08\u7b97\u3055\u308c\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u66f4\u65b0\u6642\u306fF2\u306e\u6570\u5f0f\u3092\u524a\u9664\u3057\u3066\u5165\u308c\u76f4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u5148\u306b\u5024\u304c\u3042\u308c\u3070\u7a7a\u3051\u3001\u30b7\u30fc\u30c8\u540d\u304c\u9055\u3046\u5834\u5408\u306f\u5f15\u6570\u3092\u4fee\u6b63\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6570\u5f0f\u306e\u5f15\u6570\u3092D2:D4\u3060\u3051\u3078\u7f6e\u304d\u63db\u3048\u308b\u3068\u3001\u30bb\u30eb\u306e\u5024\u3092\u53d7\u3051\u53d6\u308a\u3001\u30ea\u30f3\u30af\u5c5e\u6027\u306e\u7bc4\u56f2\u6307\u5b9a\u306b\u306f\u306a\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5143\u306b\u623b\u3059\u3068\u304d\u306f\u51fa\u529b\u5148F2\u306e\u5f0f\u3092\u5916\u3057\u3001URL\u3084\u30ea\u30f3\u30af\u3092\u4ed8\u3051\u305fD\u5217\u306f\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u6b8b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e26\u3079\u66ff\u3048\u3067\u306fA\uff5eF\u5217\u3092\u540c\u3058\u7bc4\u56f2\u306b\u542b\u3081\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u516c\u5f0f\u306e\u4ed5\u69d8\u3068\u691c\u8a3c\u7bc4\u56f2<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/rich-text-value\" target=\"_blank\" rel=\"noreferrer noopener\">RichTextValue.getLinkUrl<\/a>\u3067\u73fe\u5728\u306e\u4ed5\u69d8\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">HYPERLINK\u306e\u8868\u793a\u5024\u3068\u30ea\u30f3\u30af\u5148\u3001\u88c5\u98fe\u30ea\u30f3\u30af\u3001\u30bb\u30eb\u53c2\u7167\u306f\u5b9f\u969b\u306eGoogle Sheets\u3067\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u63b2\u8f09\u3057\u305fGAS\u3092\u7df4\u7fd2\u30b7\u30fc\u30c8\u306eApps Script\u306b\u4fdd\u5b58\u3057\u3001\u88c5\u98fe\u30ea\u30f3\u30af2\u4ef6\u306eURL\u53d6\u5f97\u3001\u30ea\u30f3\u30af\u306a\u3057\u30fb\u8907\u6570\u30ea\u30f3\u30af\u306e\u7a7a\u6b04\u3001\u30b7\u30fc\u30c8\u540d\u306a\u3057\u30681001\u30bb\u30eb\u306e\u30a8\u30e9\u30fc\u3001\u5f0f\u306e\u524a\u9664\u3068\u518d\u5165\u529b\u306b\u3088\u308b\u5fa9\u5143\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30ea\u30f3\u30af\u5909\u66f4\u3060\u3051\u306b\u3088\u308b\u81ea\u52d5\u518d\u8a08\u7b97\u306f\u672a\u78ba\u8a8d\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5143URL\u304c\u3042\u308b\u5834\u5408\u306f\u305d\u306e\u5217\u3092\u4f7f\u3044\u3001GAS\u306f\u7df4\u7fd2\u30b3\u30d4\u30fc\u3067\u51fa\u529b\u3092\u7167\u5408\u3057\u3066\u304b\u3089\u5229\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u7df4\u7fd2\u30c7\u30fc\u30bf\u3068\u30b3\u30fc\u30c9\u306e\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7df4\u7fd2ZIP\u306b\u306f3\u3064\u306eTSV\u30013\u679a\u306ePPTX\u3001Google\u304b\u3089\u66f8\u304d\u51fa\u3057\u305fPDF\u3001\u6570\u5f0fTXT\u3068GAS\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u62c5\u5f53\u8005\u306e\u975e\u516c\u958bGoogle\u30d5\u30a1\u30a4\u30ebID\u306f\u5165\u3063\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">TXT\u306b\u3042\u308b\u6570\u5f0f\u306f\u30b7\u30fc\u30c8\u3001GAS\u306fApps Script\u3078\u8cbc\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e7GitHub\u8cc7\u6599\u3068\u4eca\u56de\u306e\u6539\u8a02\u30b3\u30fc\u30c9\u306f\u540c\u3058\u7248\u3068\u306f\u9650\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2026\/09\/google-apps-matome-3-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/google-apps-matome\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u30fb\u30c9\u30e9\u30a4\u30d6\u306e\u4f7f\u3044\u65b9\u307e\u3068\u3081\uff5c\u95a2\u6570\u3068GAS<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">Google\u306e\u64cd\u4f5c\u3092\u300c\u4f55\u3092\u3057\u305f\u3044\u304b\u300d\u304b\u3089\u63a2\u305b\u308b\u30ac\u30a4\u30c9\u3067\u3059\u3002 \u307e\u305a\u6a19\u6e96\u306e\u753b\u9762\u64cd\u4f5c\u3084\u95a2\u6570\u3067\u89e3\u6c7a\u3067\u304d\u308b\u304b\u3092\u78ba\u8a8d\u3057\u3001\u7e70\u308a\u8fd4\u3059\u51e6\u7406\u306bGAS\u3092\u4f7f\u3044\u307e\u3059\u3002 \u76ee\u7684\u304b\u3089\u624b\u9806\u3092\u9078\u3076 \u3084\u308a\u305f&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/google-sheets-release-all-merged-cells-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/google-sheets-release-all-merged-cells\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u7d50\u5408\u30bb\u30eb\u3092\u4e00\u62ec\u3067\u89e3\u9664\u3059\u308b\u65b9\u6cd5\uff5cGAS<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">\u672c\u7a3f\u306fWeb\u7248Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u7df4\u7fd2\u8868\u3067\u3001\u64cd\u4f5c\u3068\u7d50\u679c\u3092\u78ba\u304b\u3081\u308b\u624b\u9806\u3092\u8aac\u660e\u3057\u307e\u3059\u3002 \u901a\u5e38\u306e\u7d50\u5408\u89e3\u9664\u3067\u306f\u3001\u7d50\u5408\u7bc4\u56f2\u306e\u5de6\u4e0a\u306e\u5024\u304c\u6b8b\u308a\u3001\u4ed6\u306e\u30bb\u30eb\u306f\u7a7a\u6b04\u306b\u306a\u308a\u307e\u3059\u3002 &#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/google-sheets-timestamp-script-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/google-sheets-timestamp-script\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u5165\u308c\u308b\u65b9\u6cd5\u3068NOW\u95a2\u6570\u306e\u6ce8\u610f\u70b9<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u65e5\u6642\u3092\u5165\u308c\u308b\u65b9\u6cd5\u306f\u3001\u76ee\u7684\u306b\u3088\u3063\u30663\u3064\u306b\u5206\u304b\u308c\u307e\u3059\u3002 \u9078\u3073\u65b9\u3092\u9593\u9055\u3048\u308b\u3068\u3001\u3042\u3068\u304b\u3089\u958b\u3044\u305f\u3068\u304d\u306b\u65e5\u6642\u304c\u66f8\u304d\u63db\u308f\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002 \u5148\u306b\u7d50\u8ad6\u3092\u307e\u3068\u3081\u307e&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/google-sheets-remove-duplicates-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/google-sheets-remove-duplicates\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u91cd\u8907\u30c7\u30fc\u30bf\u3092\u4e00\u767a\u524a\u9664\u3059\u308b\u65b9\u6cd5<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u30ed\u30b0\u3084\u65e5\u6b21\u30c7\u30fc\u30bf\u3092\u8a18\u9332\u3057\u3066\u3044\u308b\u3068\u3001\u540c\u3058\u30ad\u30fc\u306e\u30c7\u30fc\u30bf\u304c\u8907\u6570\u884c\u306b\u308f\u305f\u3063\u3066\u5b58\u5728\u3059\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002 \u624b\u52d5\u3067\u524a\u9664\u3059\u308b\u3068\u624b\u9593\u304c\u304b\u304b\u308a\u307e\u3059\u3002 \u672c\u8a18&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"swell-block-postLink\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/google-sheets-search-300x169.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/cg-method.com\/google\/google-sheets-search\/\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u30b7\u30fc\u30c8\u5185\u306e\u6587\u5b57\u3092\u691c\u7d22\u3059\u308b\u65b9\u6cd5<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">\u958b\u3044\u3066\u3044\u308b\u30b7\u30fc\u30c8\u306fCtrl+F\u3001\u540c\u3058\u30d5\u30a1\u30a4\u30eb\u306e\u4ed6\u30b7\u30fc\u30c8\u3084\u7279\u5b9a\u7bc4\u56f2\u306f\u691c\u7d22\u3068\u7f6e\u63db\u3067\u63a2\u3057\u307e\u3059\u3002 \u691c\u7d22\u5bfe\u8c61\u3068\u4e00\u81f4\u6761\u4ef6\u3092\u6c7a\u3081\u308b\u3068\u3001\u6771\u4eac\u3060\u3051\u3092\u63a2\u3059\u5834\u5408\u3068\u6771\u4eac\u90fd\u30fb\u6771\u4eac\u99c5\u3082\u542b\u3081\u308b\u5834&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"product-card\" data-id=\"23048\" data-sale-effect=\"flash\">\n\t\t<div class=\"product-card__image\">\n\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/4297156644?tag=cgm-google-22&#038;linkCode=ogi&#038;th=1&#038;psc=1\" rel=\"nofollow noopener sponsored\" target=\"_blank\">\t\t\t<img src=\"https:\/\/m.media-amazon.com\/images\/I\/5122YS4xqvL._SL500_.jpg\" alt=\"\" width=\"200\" height=\"200\" loading=\"lazy\" decoding=\"async\" \/>\t\t<\/a>\t<\/div>\n\t\t<div class=\"product-card__body\">\n\t\t<div class=\"product-card__title\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/4297156644?tag=cgm-google-22&#038;linkCode=ogi&#038;th=1&#038;psc=1\" rel=\"nofollow noopener sponsored\" target=\"_blank\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u5b8c\u5168\u653b\u7565 \u6700\u9ad8\u52b9\u7387\u306e\u6b66\u5668\u306b\u306a\u308b<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"product-card__info\">\u6280\u8853\u8a55\u8ad6\u793e<\/div>\n\t\t\t\t\t\t<div class=\"product-card__price\">\u00a52,200<span>\uff082026\/09\/24 18:33\u6642\u70b9 | Amazon\u8abf\u3079\uff09<\/span><\/div>\n\t\t\t\t\t\t<div class=\"product-card__review\"><a href=\"https:\/\/www.amazon.co.jp\/product-reviews\/4297156644?tag=cgm-google-22\" rel=\"nofollow noopener sponsored\" target=\"_blank\"><svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" aria-hidden=\"true\"><path fill=\"currentColor\" d=\"M12 17.3l-6.2 3.7 1.6-7L2 9.2l7.2-.6L12 2l2.8 6.6 7.2.6-5.4 4.8 1.6 7z\"\/><\/svg><span>\u53e3\u30b3\u30df\u3092\u898b\u308b<\/span><\/a><\/div>\n\t\t\t<\/div>\n\t\t<div class=\"product-card__btns\">\n\t\t\t\t<div class=\"product-card__btnwrap -rakuten -on-sale\">\n\t\t\t\t\t\t<div class=\"product-card__sale\">\uff3c\u697d\u5929\u30bb\u30fc\u30eb\u958b\u50ac\u4e2d\uff01\u30dd\u30a4\u30f3\u30c8\u6700\u592711\u500d\uff01\uff0f<\/div>\n\t\t\t\t\t\t<a href=\"https:\/\/hb.afl.rakuten.co.jp\/hgc\/14eb6112.12938970.14eb6113.c6861b17\/_RTLink148150?pc=https%3A%2F%2Fsearch.rakuten.co.jp%2Fsearch%2Fmall%2FGoogle%25E3%2582%25B9%25E3%2583%2597%25E3%2583%25AC%25E3%2583%2583%25E3%2583%2589%25E3%2582%25B7%25E3%2583%25BC%25E3%2583%2588%25E5%25AE%258C%25E5%2585%25A8%25E6%2594%25BB%25E7%2595%25A5&#038;m=https%3A%2F%2Fsearch.rakuten.co.jp%2Fsearch%2Fmall%2FGoogle%25E3%2582%25B9%25E3%2583%2597%25E3%2583%25AC%25E3%2583%2583%25E3%2583%2589%25E3%2582%25B7%25E3%2583%25BC%25E3%2583%2588%25E5%25AE%258C%25E5%2585%25A8%25E6%2594%25BB%25E7%2595%25A5\" class=\"product-card__btn\" rel=\"nofollow noopener sponsored\" target=\"_blank\"><span>\u697d\u5929\u5e02\u5834<\/span><\/a>\n\t\t<\/div>\n\t\t\t\t<div class=\"product-card__btnwrap -amazon\">\n\t\t\t\t\t\t<a href=\"https:\/\/www.amazon.co.jp\/dp\/4297156644?tag=cgm-google-22&#038;linkCode=ogi&#038;th=1&#038;psc=1\" class=\"product-card__btn\" rel=\"nofollow noopener sponsored\" target=\"_blank\"><span>Amazon<\/span><\/a>\n\t\t<\/div>\n\t\t\t\t<div class=\"product-card__btnwrap -yahoo\">\n\t\t\t\t\t\t<a href=\"https:\/\/shopping.yahoo.co.jp\/search?p=Google%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E5%AE%8C%E5%85%A8%E6%94%BB%E7%95%A5\" class=\"product-card__btn\" rel=\"nofollow noopener sponsored\" target=\"_blank\"><span>Yahoo\u30b7\u30e7\u30c3\u30d4\u30f3\u30b0<\/span><\/a>\n\t\t<\/div>\n\t\t\t<\/div>\n\t<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u5b57\u3078\u30ea\u30f3\u30af\u3092\u4ed8\u3051\u308b\u64cd\u4f5c\u3068\u3001\u8868\u793a\u540d\u304b\u3089URL\u3092\u53d6\u308a\u51fa\u3059\u64cd\u4f5c\u3092\u5206\u3051\u3066\u8aac\u660e\u3057\u307e\u3059\u3002 \u5143\u306eURL\u3092\u5217\u306b\u6b8b\u3057\u3066\u304a\u304f\u3068\u3001\u5f8c\u304b\u3089\u30ea\u30f3\u30af\u5148\u3092\u78ba\u8a8d\u3057\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002 \u7df4\u7fd2\u30c7\u30fc\u30bf\u30fb\u30b9\u30e9\u30a4\u30c9\u30fbPDF\u30fb\u30b3\u30fc\u30c9TXT\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u3068\u3001\u540c\u3058\u5165 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":140,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","book_review_data":"","footnotes":"","ssp_meta_title":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306e\u30cf\u30a4\u30d1\u30fc\u30ea\u30f3\u30af\u3092\u8cbc\u308b\u30fb\u53d6\u308a\u51fa\u3059","ssp_meta_description":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6587\u5b57\u306b\u30ea\u30f3\u30af\u3092\u8cbc\u308b\u65b9\u6cd5\uff08=HYPERLINK\u95a2\u6570\u3001Ctrl+K\uff09\u3068\u3001\u5225\u306e\u5217\u306eURL\u3092\u307e\u3068\u3081\u3066\u30ea\u30f3\u30af\u5316\u3059\u308b\u65b9\u6cd5\u3092\u307e\u3068\u3081\u307e\u3057\u305f\u3002\u9006\u306b\u3001\u30ea\u30f3\u30af\u4ed8\u304d\u30c6\u30ad\u30b9\u30c8\u304b\u3089URL\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059\u95a2\u6570\u306f\u7528\u610f\u3055\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3001GAS\u3067\u81ea\u4f5c\u95a2\u6570\u3092\u4f5c\u308b\u624b\u9806\u3082\u63b2\u8f09\u3057\u3066\u3044\u307e\u3059\u3002"},"categories":[17],"tags":[18,9],"class_list":["post-136","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets","tag-gas","tag-free"],"_links":{"self":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/comments?post=136"}],"version-history":[{"count":13,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/136\/revisions"}],"predecessor-version":[{"id":23573,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/136\/revisions\/23573"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media\/140"}],"wp:attachment":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media?parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/categories?post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/tags?post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}