{"id":218,"date":"2025-05-25T21:06:52","date_gmt":"2025-05-25T12:06:52","guid":{"rendered":"https:\/\/cg-method.com\/google\/?p=218"},"modified":"2025-05-25T21:10:41","modified_gmt":"2025-05-25T12:10:41","slug":"google-sheets-auto-copy-with-date","status":"publish","type":"post","link":"https:\/\/cg-method.com\/google\/google-sheets-auto-copy-with-date\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u81ea\u52d5\u3067\u65e5\u4ed8\u5165\u308a\uff01\u8907\u88fd\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u3001<strong>\u6bce\u6708\u4f7f\u3046\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u81ea\u52d5\u3067\u8907\u88fd\u3057\u3001\u30b7\u30fc\u30c8\u540d\u306b\u65e5\u4ed8\u3092\u4ed8\u3051\u305f\u3044<\/strong>\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\uff1f<\/p>\n\n\n\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Google Apps Script\uff08GAS\uff09\u3092\u4f7f\u3063\u3066\u3001\u300c<code>master<\/code>\u300d\u3068\u3044\u3046\u30b7\u30fc\u30c8\u3092\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3068\u3057\u3066\u3001<strong>\u65e5\u4ed8\u4ed8\u304d\u3067\u81ea\u52d5\u30b3\u30d4\u30fc\u3059\u308b\u65b9\u6cd5<\/strong>\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"366\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/2025-05-25_21h03_12.png\" alt=\"\" class=\"wp-image-219\" srcset=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/2025-05-25_21h03_12.png 566w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/2025-05-25_21h03_12-300x194.png 300w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><\/figure>\n\n\n\n<p class=\"is-style-icon_pen\">\u5b9a\u4f8b\u4f1a\u8b70\u306e\u8b70\u4e8b\u9332\u306a\u3069\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u304c\u6c7a\u307e\u3063\u3066\u3044\u308b\u3082\u306e\u306b\u4f7f\u3048\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u81ea\u52d5\u3067\u65e5\u4ed8\u5165\u308a\u306e\u8907\u88fd\u30b7\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/h2>\n\n\n\n<p>Google App Script\uff08GAS\uff09\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d71\uff1a\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u30b7\u30fc\u30c8\u3092\u6e96\u5099<\/h3>\n\n\n\n<p>\u307e\u305a\u3001\u8907\u88fd\u5143\u3068\u306a\u308b\u30b7\u30fc\u30c8\u306b <strong><code>master<\/code><\/strong> \u3068\u3044\u3046\u540d\u524d\u3092\u4ed8\u3051\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d72\uff1a\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30c7\u30a3\u30bf\u3092\u958b\u304f<\/h3>\n\n\n\n<p>\u30e1\u30cb\u30e5\u30fc\u304b\u3089<br><code>\u30c4\u30fc\u30eb<\/code> \u2192 <code>\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30c7\u30a3\u30bf<\/code> \u3092\u30af\u30ea\u30c3\u30af\u3002<br>\u65b0\u3057\u3044GAS\u30a8\u30c7\u30a3\u30bf\u304c\u958b\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30b9\u30c6\u30c3\u30d73\uff1a\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8cbc\u308a\u4ed8\u3051<\/h3>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>function AutoSheetCopy() {\n  var ss = SpreadsheetApp.getActiveSpreadsheet(); \n  var templateSheet = ss.getSheetByName(&#39;master&#39;); \n  ss.insertSheet(getDate(), 0, {template: templateSheet}); \n}\n\n\/\/ \u73fe\u5728\u306e\u5e74\u6708\uff08YYYYMM\uff09\u3092\u53d6\u5f97\nfunction getDate() {\n  var today = new Date(); \n  return Utilities.formatDate(today, &quot;JST&quot;, &quot;yyyyMM&quot;);\n}<\/code><\/pre><\/div>\n\n\n\n<p>\u5b9f\u884c\u3059\u308b\u3068\u2026<\/p>\n\n\n\n<p class=\"is-style-icon_pen\">\u521d\u56de\u306f\u627f\u8a8d\u306e\u30e2\u30fc\u30c0\u30eb\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u306e\u3067\u627f\u8a8d\u304c\u5fc5\u8981\u3067\u3059<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u300cmaster\u300d\u30b7\u30fc\u30c8\u306e\u5185\u5bb9\u304c\u30b3\u30d4\u30fc\u3055\u308c<\/li>\n\n\n\n<li>\u65b0\u3057\u3044\u30b7\u30fc\u30c8\u304c\u300c202505\u300d\u306a\u3069\u306e\u5e74\u6708\u306e\u540d\u524d\u3067\u8ffd\u52a0\u3055\u308c\u307e\u3059<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"366\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/2025-05-25_21h03_12.png\" alt=\"\" class=\"wp-image-219\" srcset=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/2025-05-25_21h03_12.png 566w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/2025-05-25_21h03_12-300x194.png 300w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u5fdc\u7528\u4f8b<\/h3>\n\n\n\n<p>\u30c8\u30ea\u30ac\u30fc\u3092\u4f7f\u3063\u3066\u3001\u81ea\u52d5\u3067\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30c7\u30a3\u30bf\u306e\u5de6\u5074\u300c\u6642\u8a08\u30a2\u30a4\u30b3\u30f3\u300d\u304b\u3089\u300c\u30c8\u30ea\u30ac\u30fc\u300d\u3092\u958b\u304f<\/li>\n\n\n\n<li>\u95a2\u6570 <code>AutoSheetCopy<\/code> \u3092\u9078\u629e<\/li>\n\n\n\n<li>\u30a4\u30d9\u30f3\u30c8\u306e\u7a2e\u985e\uff1a\u300c\u6642\u9593\u4e3b\u5c0e\u578b\u300d<\/li>\n\n\n\n<li>\u6642\u9593\u306e\u9593\u9694\uff1a\u300c\u6708\u5358\u4f4d\u300d\u300c\u6bce\u67081\u65e5\u5348\u524d9\u6642\u300d\u306a\u3069\u4efb\u610f\u306e\u8a2d\u5b9a<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u5fdc\u7528\u30a2\u30a4\u30c7\u30a2<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u30b7\u30fc\u30c8\u540d\u3092\u300c2025\u5e745\u6708\u300d\u5f62\u5f0f\u306b\u3057\u305f\u3044\u5834\u5408\u306f <code>yyyy\u5e74MM\u6708<\/code> \u306b\u5909\u66f4<\/li>\n\n\n\n<li>\u6bce\u9031\u8907\u88fd\u3057\u305f\u3044\u5834\u5408\u306f <code>ww<\/code> \u3092\u4f7f\u3063\u3066\u300c2025W21\u300d\u306e\u3088\u3046\u306b\u9031\u756a\u53f7\u3082\u8ffd\u52a0\u53ef\u80fd<\/li>\n<\/ul>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>return Utilities.formatDate(today, &quot;JST&quot;, &quot;yyyy\u5e74MM\u6708&quot;);<\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u304a\u3059\u3059\u3081\u306e\u6d3b\u7528\u4f8b<\/h2>\n\n\n\n<ul class=\"wp-block-list is-style-num_circle\">\n<li>\u52e4\u6020\u7ba1\u7406\u306e\u6708\u5225\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8<\/li>\n\n\n\n<li>\u6708\u6b21\u5831\u544a\u66f8\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u5316<\/li>\n\n\n\n<li>\u6708\u9593\u30bf\u30b9\u30af\u30ea\u30b9\u30c8\u3084\u30ec\u30dd\u30fc\u30c8\u306e\u81ea\u52d5\u751f\u6210<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081<\/h2>\n\n\n\n<p>Google Apps Script \u3092\u4f7f\u3048\u3070\u3001\u6bce\u6708\u306e\u30eb\u30fc\u30c1\u30f3\u696d\u52d9\u3092\u5927\u5e45\u306b\u52b9\u7387\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p><strong>\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u81ea\u52d5\u30b3\u30d4\u30fc + \u65e5\u4ed8\u7ba1\u7406<\/strong>\u3092\u3001\u305c\u3072\u81ea\u5206\u306e\u696d\u52d9\u306b\u53d6\u308a\u5165\u308c\u3066\u307f\u3066\u304f\u3060\u3055\u3044\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u3001\u6bce\u6708\u4f7f\u3046\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u81ea\u52d5\u3067\u8907\u88fd\u3057\u3001\u30b7\u30fc\u30c8\u540d\u306b\u65e5\u4ed8\u3092\u4ed8\u3051\u305f\u3044\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\uff1f \u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Google Apps Script\uff08GAS\uff09\u3092\u4f7f\u3063\u3066\u3001\u300cmaster\u300d\u3068\u3044\u3046\u30b7\u30fc\u30c8\u3092\u30c6\u30f3\u30d7 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":220,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[17],"tags":[18,9],"class_list":["post-218","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\/218","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=218"}],"version-history":[{"count":1,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":221,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/218\/revisions\/221"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media\/220"}],"wp:attachment":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}