{"id":359,"date":"2026-04-30T11:30:00","date_gmt":"2026-04-30T02:30:00","guid":{"rendered":"https:\/\/wizardofcode.kr\/?p=359"},"modified":"2026-04-28T16:44:00","modified_gmt":"2026-04-28T07:44:00","slug":"%ed%8c%94%eb%a1%9c%ec%97%85-%ed%83%80%ec%9d%b4%eb%b0%8d%ec%9d%84-%eb%86%93%ec%b3%90-%ea%b3%84%ec%95%bd%ec%9d%84-%eb%82%a0%eb%a6%b0-%ea%b2%bd%ed%97%98-%ea%b5%ac%ea%b8%80%ec%8b%9c%ed%8a%b8","status":"publish","type":"post","link":"https:\/\/wizardofcode.kr\/?p=359","title":{"rendered":"\ud314\ub85c\uc5c5 \ud0c0\uc774\ubc0d\uc744 \ub193\uccd0 \uacc4\uc57d\uc744 \ub0a0\ub9b0 \uacbd\ud5d8 \u2014 \uad6c\uae00\uc2dc\ud2b8\ub85c \uc790\ub3d9 \uc54c\ub9bc \ub9cc\ub4dc\ub294 \ubc95"},"content":{"rendered":"\n<p>\uc9c0\ub09c \uae00\uc5d0\uc11c\ub294 \uad6c\uae00\uc2dc\ud2b8\ub85c \uba54\uc77c\uba38\uc9c0\ub97c \uad6c\ud604\ud558\ub294 \uc138 \uac00\uc9c0 \ubc29\ubc95\uc744 \ube44\uad50\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\uad00\ub828 \uae00: <a href=\"https:\/\/wizardofcode.kr\/?p=352\" data-type=\"post\" data-id=\"352\">[\uad6c\uae00\uc2dc\ud2b8 \uba54\uc77c\uba38\uc9c0 \uc644\uc804 \uac00\uc774\ub4dc \u2014 \uace0\uac1d 100\uba85\uc5d0\uac8c \ub9de\ucda4 \uba54\uc77c \ubcf4\ub0b4\uae30]<\/a><\/p>\n<\/blockquote>\n\n\n\n<p>\uba54\uc77c\uc744 \uc798 \ubcf4\ub0c8\ub2e4\uace0 \ub05d\uc774 \uc544\ub2d9\ub2c8\ub2e4.<br>\uc624\ud788\ub824 \uac70\uae30\uc11c\ubd80\ud130\uac00 \uc9c4\uc9dc \uc601\uc5c5\uc758 \uc2dc\uc791\uc774\uc8e0.<br><strong>\ud68c\uc2e0\uc774 \uc624\uc9c0 \uc54a\uc740 \uba54\uc77c<\/strong>,&nbsp;<strong>\ubbf8\ud305 \ud6c4 \uac10\uac10\ubb34\uc18c\uc2dd\uc778 \uac74<\/strong>,&nbsp;<strong>\uc81c\uc548\uc11c \ubcf4\ub0b4\ub193\uace0 \uacb0\uacfc\ub97c \uae30\ub2e4\ub9ac\ub294 \uace0\uac1d<\/strong>.<br>\uc774 \uc0ac\ub78c\ub4e4\uc744 \uc5b8\uc81c \ub2e4\uc2dc \uc5f0\ub77d\ud560\uc9c0 \uae30\uc5b5\ud558\ub294 \uac8c \uc601\uc5c5\uc758 \ud575\uc2ec \uc2a4\ud0ac\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub7f0\ub370 \uc774 &#8220;\uc5b8\uc81c \uc5f0\ub77d\ud560\uc9c0 \uae30\uc5b5\ud558\uae30&#8221;\uac00 \uace0\uac1d \uc218\uac00 \ub298\uc5b4\ub0a0\uc218\ub85d \ubd88\uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4.<br>\uadf8\ub798\uc11c \uc624\ub298\uc740&nbsp;<strong>\uad6c\uae00\uc2dc\ud2b8\ub9cc\uc73c\ub85c \ud314\ub85c\uc5c5 \uc790\ub3d9 \uc54c\ub9bc<\/strong>\uc744 \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc744 \uc815\ub9ac\ud574 \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<br>Apps Script \uc5c6\uc774 \uc870\uac74\ubd80 \uc11c\uc2dd\uacfc \uae30\ubcf8 \uc218\uc2dd\ub9cc\uc73c\ub85c\ub3c4 \ucda9\ubd84\ud788 \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ud314\ub85c\uc5c5\uc774 \uc65c \uadf8\ub807\uac8c \uc911\uc694\ud55c\uac00<\/h2>\n\n\n\n<p>B2B \uc601\uc5c5\uc5d0\uc11c \uacc4\uc57d\uc774 \ud55c \ubc88\uc5d0 \uacb0\uc815\ub418\ub294 \uacbd\uc6b0\ub294 \uac70\uc758 \uc5c6\uc2b5\ub2c8\ub2e4.<br>\ud3c9\uade0\uc801\uc73c\ub85c&nbsp;<strong>\ud55c \uac74\uc758 \uacc4\uc57d\uae4c\uc9c0 5~7\ubc88\uc758 \uc811\ucd09<\/strong>\uc774 \ud544\uc694\ud558\ub2e4\ub294 \uac8c \uc5c5\uacc4 \uc0c1\uc2dd\uc785\ub2c8\ub2e4.<br>\uccab \uba54\uc77c\uc5d0 \ubc14\ub85c \ub2f5\uc774 \uc624\ub294 \uace0\uac1d\uc740 \uc0dd\uac01\ubcf4\ub2e4 \ub4dc\ubb3c\uace0, \ub300\ubd80\ubd84\uc740 \ub450 \ubc88\uc9f8, \uc138 \ubc88\uc9f8, \ub124 \ubc88\uc9f8 \uc5f0\ub77d\uc5d0\uc11c \uc2e4\uc81c \ub300\ud654\uac00 \uc2dc\uc791\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubb38\uc81c\ub294 \uc774 \ud314\ub85c\uc5c5 \ud0c0\uc774\ubc0d\uc785\ub2c8\ub2e4.<br>\ub108\ubb34 \ube68\ub9ac \uc7ac\ucd09\ud558\uba74 \ubd80\ub2f4\uc2a4\ub7ec\uc6cc\ud558\uace0, \ub108\ubb34 \ub2a6\uc73c\uba74 \uc78a\ud600\uc9d1\ub2c8\ub2e4.<br>\uc77c\ubc18\uc801\uc73c\ub85c&nbsp;<strong>\ucc98\uc74c \uc811\ucd09 \ud6c4 7~10\uc77c \uc774\ub0b4<\/strong>\uac00 \uac00\uc7a5 \uc790\uc5f0\uc2a4\ub7ec\uc6b4 \uc7ac\uc5f0\ub77d \uc2dc\uc810\uc774\ub77c\uace0 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub7f0\ub370 \uc601\uc5c5 \ub2f4\ub2f9\uc790\uac00 \uba38\ub9bf\uc18d\uc5d0 \ub2f4\uc544\ub458 \uc218 \uc788\ub294 \ud314\ub85c\uc5c5\uc740 \uae30\uaecf\ud574\uc57c 5~10\uac74\uc785\ub2c8\ub2e4.<br>\uace0\uac1d\uc774 100\uba85, 200\uba85\uc774 \ub418\uba74 \uba38\ub9ac\ub85c\ub294 \uad00\ub9ac\uac00 \ubd88\uac00\ub2a5\ud569\ub2c8\ub2e4.<br>\ub2ec\ub825\uc5d0 \ud558\ub098\uc529 \ub9ac\ub9c8\uc778\ub354\ub97c \uac78\uc790\ub2c8 \uace0\uac1d \uc218\ub9cc\ud07c \uc77c\uc815\uc774 \uc313\uc774\uace0, \uc5d1\uc140 \ud30c\uc77c \uc5b4\ub518\uac00\uc5d0 \uba54\ubaa8\ub97c \ud574\ub450\uc790\ub2c8 \ub9e4\ubc88 \uc5f4\uc5b4\ubcf4\uc9c0 \uc54a\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc800\ub294 \uc774 \ubb38\uc81c\ub97c&nbsp;<strong>\uc2dc\ud2b8\ub97c \uc5f4 \ub54c\ub9c8\ub2e4 \uc790\ub3d9\uc73c\ub85c \ub208\uc5d0 \ub744\ub3c4\ub85d<\/strong>&nbsp;\ud574\uacb0\ud588\uc2b5\ub2c8\ub2e4.<br>\uace0\uac1d DB\ub97c \uc5f4\uba74 &#8220;\uc624\ub298 \uc5f0\ub77d\ud574\uc57c \ud560 \uc0ac\ub78c&#8221;\uc774 \ube68\uac04\uc0c9\uc73c\ub85c \ubc18\uc9dd\uc774\ub294 \uac70\uc8e0. \uc544\uce68\uc5d0 \uc2dc\ud2b8\ub97c \ud55c \ubc88\ub9cc \uc5f4\uc5b4\ub3c4 \uadf8\ub0a0\uc758 \ud314\ub85c\uc5c5 \ub9ac\uc2a4\ud2b8\uac00 \ubc14\ub85c \ubcf4\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc6d0\ub9ac: \uacbd\uacfc \uc77c\uc218\ub97c \uacc4\uc0b0\ud558\uace0, \uc0c9\uc0c1\uc73c\ub85c \ud45c\uc2dc\ud55c\ub2e4<\/h2>\n\n\n\n<p>\uad6c\uc870\ub294 \ub2e8\uc21c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\ucd5c\uc885 \uc5f0\ub77d\uc77c<\/strong>&nbsp;\ud544\ub4dc\uc5d0 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc5f0\ub77d\ud55c \ub0a0\uc9dc\ub97c \uae30\ub85d\ud569\ub2c8\ub2e4<\/li>\n\n\n\n<li><strong>\uacbd\uacfc \uc77c\uc218<\/strong>&nbsp;\ud544\ub4dc\uc5d0\uc11c &#8220;\uc624\ub298 &#8211; \ucd5c\uc885 \uc5f0\ub77d\uc77c&#8221; \uc218\uc2dd\uc73c\ub85c \uc77c\uc218\ub97c \uc790\ub3d9 \uacc4\uc0b0\ud569\ub2c8\ub2e4<\/li>\n\n\n\n<li><strong>\uc870\uac74\ubd80 \uc11c\uc2dd<\/strong>\uc73c\ub85c \uacbd\uacfc \uc77c\uc218\uac00 7\uc77c \uc774\uc0c1\uc774\uba74 \uc140 \ubc30\uacbd\uc744 \ube68\uac04\uc0c9\uc73c\ub85c \ubc14\uafc9\ub2c8\ub2e4<\/li>\n<\/ol>\n\n\n\n<p>\uc774\uac8c \uc804\ubd80\uc785\ub2c8\ub2e4.<br>Apps Script\ub3c4, \ud2b8\ub9ac\uac70\ub3c4, \ubcc4\ub3c4 \uc54c\ub9bc\ub3c4 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4.<br>\uc2dc\ud2b8\ub97c \uc5f4\uba74 \uc790\ub3d9\uc73c\ub85c \ub2e4\uc2dc \uacc4\uc0b0\ub418\uae30 \ub54c\ubb38\uc5d0, \uc624\ub298 \uae30\uc900 \ud314\ub85c\uc5c5\uc774 \ud544\uc694\ud55c \uace0\uac1d\uc774 \ub298 \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc2e4\uc804 \uad6c\ud604 \u2014 3\ub2e8\uacc4\ub9cc \ub530\ub77c \ud558\uc138\uc694<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1\ub2e8\uacc4: \uc2dc\ud2b8 \uad6c\uc870 \ub9cc\ub4e4\uae30<\/h3>\n\n\n\n<p>\uad6c\uae00\uc2dc\ud2b8 \uc0c8 \ud30c\uc77c\uc744 \uc5f4\uace0 \ub2e4\uc74c\uacfc \uac19\uc774 \uc5f4\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>A\uc5f4<\/th><th>B\uc5f4<\/th><th>C\uc5f4<\/th><th>D\uc5f4<\/th><th>E\uc5f4<\/th><th>F\uc5f4<\/th><\/tr><\/thead><tbody><tr><td>\uc774\ub984<\/td><td>\uc18c\uc18d<\/td><td>\uc774\uba54\uc77c<\/td><td>\uc601\uc5c5\ub2e8\uacc4<\/td><td>\ucd5c\uc885\uc5f0\ub77d\uc77c<\/td><td>\uacbd\uacfc\uc77c\uc218<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\ucd5c\uc885 \uc5f0\ub77d\uc77c\uc740 \ubc18\ub4dc\uc2dc&nbsp;<strong>\ub0a0\uc9dc \ud615\uc2dd<\/strong>\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4.<br>[\uc11c\uc2dd] &gt; [\uc22b\uc790] &gt; [\ub0a0\uc9dc]\ub97c \uc120\ud0dd\ud558\uba74 \ub429\ub2c8\ub2e4.<br>\uc774\uac8c \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc73c\ub85c \ub418\uc5b4 \uc788\uc73c\uba74 \ub2e4\uc74c \ub2e8\uacc4\uc758 \uc218\uc2dd\uc774 \uc791\ub3d9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2\ub2e8\uacc4: \uacbd\uacfc \uc77c\uc218 \uc790\ub3d9 \uacc4\uc0b0 \uc218\uc2dd \ub123\uae30<\/h3>\n\n\n\n<p>F2 \uc140(\uacbd\uacfc\uc77c\uc218 \uc5f4\uc758 \uccab \ubc88\uc9f8 \ub370\uc774\ud130 \ud589)\uc5d0 \ub2e4\uc74c \uc218\uc2dd\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>=IF(E2=\"\";\"\";TODAY()-E2)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">=IF<\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #D8DEE9\">E2<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #ECEFF4\">&quot;&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><span style=\"color: #ECEFF4\">&quot;&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><span style=\"color: #88C0D0\">TODAY<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9\">E2<\/span><span style=\"color: #ECEFF4\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc774 \uc218\uc2dd\uc774 \ud558\ub294 \uc77c\uc740 \uac04\ub2e8\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>E2(\ucd5c\uc885\uc5f0\ub77d\uc77c)\uac00 \ube44\uc5b4\uc788\uc73c\uba74 \u2192 \uc544\ubb34\uac83\ub3c4 \ud45c\uc2dc\ud558\uc9c0 \uc54a\uc74c<\/li>\n\n\n\n<li>E2\uc5d0 \ub0a0\uc9dc\uac00 \uc788\uc73c\uba74 \u2192 \uc624\ub298 \ub0a0\uc9dc\uc5d0\uc11c \ube7c\uc11c \uacbd\uacfc \uc77c\uc218\ub97c \uc22b\uc790\ub85c \ud45c\uc2dc<\/li>\n<\/ul>\n\n\n\n<p><strong>\ud55c\uad6d\uc5b4 \uad6c\uae00\uc2dc\ud2b8\uc5d0\uc11c\ub294 \uc27c\ud45c \ub300\uc2e0 \uc138\ubbf8\ucf5c\ub860<\/strong>\uc744 \uc501\ub2c8\ub2e4.<br>\uc601\uc5b4\uad8c \uc790\ub8cc\ub97c \ub530\ub77c \ud558\ub2e4\uac00 \uc5ec\uae30\uc11c \uc624\ub958\uac00 \ub098\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc73c\ub2c8 \uc8fc\uc758\ud558\uc138\uc694.<\/p>\n\n\n\n<p>\uc774 \uc218\uc2dd\uc744 F2\uc5d0 \ub123\uace0 \uc544\ub798\ucabd\uc73c\ub85c \ub4dc\ub798\uadf8\ud574 \ubcf5\uc0ac\ud558\uba74, \ubaa8\ub4e0 \ud589\uc5d0 \uc790\ub3d9\uc73c\ub85c \uacbd\uacfc \uc77c\uc218\uac00 \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">3\ub2e8\uacc4: \uc870\uac74\ubd80 \uc11c\uc2dd\uc73c\ub85c \uc0c9\uc0c1 \uaddc\uce59 \ub9cc\ub4e4\uae30<\/h3>\n\n\n\n<p>\uc774\uc81c \uacbd\uacfc \uc77c\uc218\uc5d0 \ub530\ub77c \uc0c9\uc0c1\uc774 \ubc14\ub00c\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>F2\ubd80\ud130 F1000\uae4c\uc9c0(\ub370\uc774\ud130\uac00 \ub4e4\uc5b4\uac08 \ubc94\uc704)\ub97c \uc120\ud0dd\ud55c \ub4a4, [\uc11c\uc2dd] &gt; [\uc870\uac74\ubd80 \uc11c\uc2dd]\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\uaddc\uce59 1: \ud314\ub85c\uc5c5 \uae34\uae09 (7\uc77c \uc774\uc0c1)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc870\uac74: &#8220;\ub2e4\uc74c\ubcf4\ub2e4 \ud06c\uac70\ub098 \uac19\uc74c&#8221;<\/li>\n\n\n\n<li>\uac12:&nbsp;<code>7<\/code><\/li>\n\n\n\n<li>\uc11c\uc2dd: \ubc30\uacbd\uc0c9 \ube68\uac04\uc0c9, \uae00\uc528 \ud770\uc0c9<\/li>\n<\/ul>\n\n\n\n<p><strong>\uaddc\uce59 2: \ud314\ub85c\uc5c5 \uc8fc\uc758 (3~6\uc77c)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc870\uac74: &#8220;\ub2e4\uc74c \uc0ac\uc774\uc5d0 \uc788\uc74c&#8221;<\/li>\n\n\n\n<li>\uac12:&nbsp;<code>3<\/code>,&nbsp;<code>6<\/code><\/li>\n\n\n\n<li>\uc11c\uc2dd: \ubc30\uacbd\uc0c9 \ub178\ub780\uc0c9<\/li>\n<\/ul>\n\n\n\n<p><strong>\uaddc\uce59 3: \ucd5c\uadfc \uc5f0\ub77d (0~2\uc77c)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc870\uac74: &#8220;\ub2e4\uc74c\ubcf4\ub2e4 \uc791\uac70\ub098 \uac19\uc74c&#8221;<\/li>\n\n\n\n<li>\uac12:&nbsp;<code>2<\/code><\/li>\n\n\n\n<li>\uc11c\uc2dd: \ubc30\uacbd\uc0c9 \ucd08\ub85d\uc0c9<\/li>\n<\/ul>\n\n\n\n<p>\uc774\ub807\uac8c 3\ub2e8\uacc4 \uc0c9\uc0c1\uc744 \uac78\uc5b4\ub450\uba74, \uc2dc\ud2b8\ub97c \uc5f4 \ub54c\ub9c8\ub2e4 \uac01 \uace0\uac1d\uc758 \ud314\ub85c\uc5c5 \uc0c1\ud0dc\uac00 \ud55c\ub208\uc5d0 \ub4e4\uc5b4\uc635\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc5ec\uae30\uc11c \ub05d\ub0b4\uc9c0 \ub9d0\uace0, \ud55c \ub2e8\uacc4 \ub354<\/h2>\n\n\n\n<p>\uc704 3\ub2e8\uacc4\ub9cc\uc73c\ub85c\ub3c4 \ucda9\ubd84\ud788 \uc4f8 \ub9cc\ud569\ub2c8\ub2e4.<br>\ud558\uc9c0\ub9cc \uc2e4\uc81c\ub85c \uc4f0\ub2e4 \ubcf4\uba74 \ub450 \uac00\uc9c0 \ubd88\ud3b8\ud568\uc774 \uc0dd\uae41\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\ubd88\ud3b8\ud568 1: \uacc4\uc57d \uc131\uc0ac\ub41c \uace0\uac1d\ub3c4 \ube68\uac04\uc0c9\uc73c\ub85c \ud45c\uc2dc\ub41c\ub2e4<\/h3>\n\n\n\n<p>\uc774\ubbf8 \uacc4\uc57d\uc774 \uc644\ub8cc\ub41c \uace0\uac1d\uc740 \ub354 \uc774\uc0c1 \ud314\ub85c\uc5c5\uc774 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4.<br>\uadf8\ub7f0\ub370 \uc704 \uc218\uc2dd\ub9cc\uc73c\ub85c\ub294 \uc601\uc5c5 \ub2e8\uacc4\uc640 \uc0c1\uad00\uc5c6\uc774 \uacbd\uacfc \uc77c\uc218\ub9cc \uacc4\uc0b0\ud558\ub2c8\uae4c, 3\ub144 \uc804\uc5d0 \uacc4\uc57d \ub05d\ub09c \uace0\uac1d\ub3c4 &#8220;1095\uc77c \uacbd\uacfc, \ube68\uac04\uc0c9&#8221;\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uac78 \ud574\uacb0\ud558\ub824\uba74 \uc218\uc2dd\uc744 \uc870\uae08 \uc218\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>=IF(OR(E2=\"\";D2=\"\uacc4\uc57d\uc131\uc0ac\";D2=\"\ubcf4\ub958\");\"\";TODAY()-E2)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">=IF<\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #81A1C1\">OR<\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #D8DEE9\">E2<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #ECEFF4\">&quot;&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><span style=\"color: #D8DEE9\">D2<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\uacc4\uc57d\uc131\uc0ac<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><span style=\"color: #D8DEE9\">D2<\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\ubcf4\ub958<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\">;<\/span><span style=\"color: #ECEFF4\">&quot;&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><span style=\"color: #88C0D0\">TODAY<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9\">E2<\/span><span style=\"color: #ECEFF4\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><code>OR<\/code>&nbsp;\ud568\uc218\ub97c \uc368\uc11c &#8220;\ucd5c\uc885 \uc5f0\ub77d\uc77c\uc774 \ube44\uc5b4\uc788\uac70\ub098, \uc601\uc5c5 \ub2e8\uacc4\uac00 &#8216;\uacc4\uc57d\uc131\uc0ac&#8217;\uc774\uac70\ub098, &#8216;\ubcf4\ub958&#8217;\uc778 \uacbd\uc6b0\uc5d0\ub294 \uacbd\uacfc \uc77c\uc218\ub97c \ud45c\uc2dc\ud558\uc9c0 \uc54a\uc74c&#8221;\uc73c\ub85c \ubc14\uafb8\ub294 \uac70\uc8e0.<br>\uc774\ub807\uac8c \ud558\uba74 \uc5ec\uc804\ud788 \uc601\uc5c5 \uc911\uc778 \uace0\uac1d\uc758 \ud314\ub85c\uc5c5\ub9cc \ube68\uac04\uc0c9\uc73c\ub85c \ub5a0\uc624\ub985\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\ubd88\ud3b8\ud568 2: \ud314\ub85c\uc5c5 \ud544\uc694 \uace0\uac1d\ub9cc \ub530\ub85c \ubcf4\uace0 \uc2f6\ub2e4<\/h3>\n\n\n\n<p>\uace0\uac1d DB\uac00 500\uba85\uc744 \ub118\uc5b4\uac00\uba74, \ub9e4\ubc88 \uc2dc\ud2b8 \uc804\uccb4\ub97c \uc2a4\ud06c\ub864\ud558\uba74\uc11c \ube68\uac04\uc0c9\ub9cc \ucc3e\ub294 \uac83\ub3c4 \ubc88\uac70\ub85c\uc6cc\uc9d1\ub2c8\ub2e4.<br>\uc774\ub54c\ub294&nbsp;<strong>\ud544\ud130 \ubdf0<\/strong>\ub97c \ud65c\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc2dc\ud2b8 \uc0c1\ub2e8\uc758 \uae54\ub300\uae30 \uc544\uc774\ucf58(\ud544\ud130 \ub9cc\ub4e4\uae30)\uc744 \ub204\ub974\uace0, \uacbd\uacfc\uc77c\uc218 \uc5f4\uc5d0\uc11c &#8220;7 \uc774\uc0c1&#8221; \uc870\uac74\uc744 \uac78\uc5b4\uc11c \uc800\uc7a5\ud569\ub2c8\ub2e4.<br>\uc774 \ud544\ud130 \ubdf0\ub97c \uc800\uc7a5\ud574\ub450\uba74 \ud55c \ubc88 \ud074\ub9ad\ub9cc\uc73c\ub85c &#8220;\uc9c0\uae08 \uc5f0\ub77d\ud574\uc57c \ud560 \uace0\uac1d&#8221;\ub9cc \ucd94\ub824\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc544\uce68\uc5d0 \uc5c5\ubb34\ub97c \uc2dc\uc791\ud560 \ub54c \uc774 \ud544\ud130\ub9cc \ud55c \ubc88 \uc801\uc6a9\ud558\uba74, \uc624\ub298\uc758 \ud314\ub85c\uc5c5 \ub9ac\uc2a4\ud2b8\uac00 \uc644\uc131\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\ub354 \uace0\ub3c4\ud654\ud558\uace0 \uc2f6\ub2e4\uba74 \u2014 \uc790\ub3d9 \uc774\uba54\uc77c \uc54c\ub9bc<\/h2>\n\n\n\n<p>\uc5ec\uae30\uae4c\uc9c0\ub294 &#8220;\uc2dc\ud2b8\ub97c \uc5f4\uc5b4\uc57c \ubcf4\uc774\ub294&#8221; \uc218\ub3d9 \ud655\uc778 \ubc29\uc2dd\uc785\ub2c8\ub2e4.<br>\ud55c \ub2e8\uacc4 \ub354 \ub098\uc544\uac00\uace0 \uc2f6\ub2e4\uba74&nbsp;<strong>\ub9e4\uc77c \uc544\uce68 \uba54\uc77c\ub85c \ud314\ub85c\uc5c5 \ub9ac\uc2a4\ud2b8\ub97c \ubc1b\ub294<\/strong>&nbsp;\ubc29\uc2dd\ub3c4 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>Apps Script\ub85c \ub9e4\uc77c \uc624\uc804 8\uc2dc\uc5d0 \uc2e4\ud589\ub418\ub294 \ud2b8\ub9ac\uac70\ub97c \uac78\uc5b4\ub450\uace0, \uacbd\uacfc \uc77c\uc218\uac00 7 \uc774\uc0c1\uc778 \uace0\uac1d \ub9ac\uc2a4\ud2b8\ub97c \uc815\ub9ac\ud574 \ubcf8\uc778 \uc774\uba54\uc77c\ub85c \uc790\ub3d9 \ubc1c\uc1a1\ud558\ub294 \uac81\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>function sendFollowupAlert() {\n  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(\"\uace0\uac1dDB\");\n  var data = sheet.getDataRange().getValues();\n  var needFollowup = [];\n  \n  for (var i = 1; i &lt; data.length; i++) {\n    var stage = data&#91;i&#93;&#91;3&#93;;\n    var days = data&#91;i&#93;&#91;5&#93;;\n    \n    \/\/ \uacc4\uc57d\uc131\uc0ac\/\ubcf4\ub958\ub294 \uc81c\uc678, \uacbd\uacfc\uc77c\uc218 7 \uc774\uc0c1\ub9cc \ucd94\ucd9c\n    if (stage !== \"\uacc4\uc57d\uc131\uc0ac\" &amp;&amp; stage !== \"\ubcf4\ub958\" &amp;&amp; days >= 7) {\n      needFollowup.push(data&#91;i&#93;&#91;0&#93; + \"(\" + data&#91;i&#93;&#91;1&#93; + \") - \" + days + \"\uc77c \uacbd\uacfc\");\n    }\n  }\n  \n  if (needFollowup.length > 0) {\n    var body = \"\uc624\ub298 \ud314\ub85c\uc5c5\uc774 \ud544\uc694\ud55c \uace0\uac1d:\\n\\n\" + needFollowup.join(\"\\n\");\n    GmailApp.sendEmail(Session.getActiveUser().getEmail(), \"&#91;\ud314\ub85c\uc5c5 \uc54c\ub9bc&#93; \" + needFollowup.length + \"\uac74\", body);\n  }\n}<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D8DEE9FF\">function sendFollowupAlert<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  var sheet <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> SpreadsheetApp.getActiveSpreadsheet<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #D8DEE9FF\">.getSheetByName<\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\uace0\uac1dDB<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  var <\/span><span style=\"color: #8FBCBB\">data<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> sheet.getDataRange<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #D8DEE9FF\">.getValues<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  var needFollowup <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> [];<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">for<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #D8DEE9FF\">var i <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">; i <\/span><span style=\"color: #81A1C1\">&lt;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #8FBCBB\">data<\/span><span style=\"color: #D8DEE9FF\">.<\/span><span style=\"color: #88C0D0\">length<\/span><span style=\"color: #D8DEE9FF\">; i<\/span><span style=\"color: #81A1C1\">++<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    var stage <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #8FBCBB\">data<\/span><span style=\"color: #D8DEE9FF\">&#91;i&#93;&#91;<\/span><span style=\"color: #B48EAD\">3<\/span><span style=\"color: #D8DEE9FF\">&#93;;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    var <\/span><span style=\"color: #88C0D0\">days<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #8FBCBB\">data<\/span><span style=\"color: #D8DEE9FF\">&#91;i&#93;&#91;<\/span><span style=\"color: #B48EAD\">5<\/span><span style=\"color: #D8DEE9FF\">&#93;;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">\/\/<\/span><span style=\"color: #D8DEE9FF\"> \uacc4\uc57d\uc131\uc0ac<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">\ubcf4\ub958\ub294 \uc81c\uc678<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> \uacbd\uacfc\uc77c\uc218 <\/span><span style=\"color: #B48EAD\">7<\/span><span style=\"color: #D8DEE9FF\"> \uc774\uc0c1\ub9cc \ucd94\ucd9c<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">if<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #D8DEE9FF\">stage !<\/span><span style=\"color: #81A1C1\">==<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\uacc4\uc57d\uc131\uc0ac<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&amp;&amp;<\/span><span style=\"color: #D8DEE9FF\"> stage !<\/span><span style=\"color: #81A1C1\">==<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\ubcf4\ub958<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&amp;&amp;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">days<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&gt;=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">7<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">      needFollowup.push<\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #8FBCBB\">data<\/span><span style=\"color: #D8DEE9FF\">&#91;i&#93;&#91;<\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">&#93; <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">(<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #8FBCBB\">data<\/span><span style=\"color: #D8DEE9FF\">&#91;i&#93;&#91;<\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">&#93; <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">) - <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">days<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\uc77c \uacbd\uacfc<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #ECEFF4\">}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #ECEFF4\">}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">if<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #D8DEE9FF\">needFollowup.<\/span><span style=\"color: #88C0D0\">length<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&gt;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    var body <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\uc624\ub298 \ud314\ub85c\uc5c5\uc774 \ud544\uc694\ud55c \uace0\uac1d:<\/span><span style=\"color: #EBCB8B\">\\n\\n<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> needFollowup.join<\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #EBCB8B\">\\n<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    GmailApp.sendEmail<\/span><span style=\"color: #ECEFF4\">(<\/span><span style=\"color: #D8DEE9FF\">Session.getActiveUser<\/span><span style=\"color: #ECEFF4\">()<\/span><span style=\"color: #D8DEE9FF\">.getEmail<\/span><span style=\"color: #ECEFF4\">(),<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">&#91;\ud314\ub85c\uc5c5 \uc54c\ub9bc&#93; <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> needFollowup.<\/span><span style=\"color: #88C0D0\">length<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">+<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\uac74<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> body<\/span><span style=\"color: #ECEFF4\">)<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #ECEFF4\">}<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ECEFF4\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc800\uc7a5\ud558\uace0 \ud2b8\ub9ac\uac70 \uba54\ub274\uc5d0\uc11c &#8220;\ub9e4\uc77c \uc624\uc804 8\uc2dc&#8221; \uc2dc\uac04 \uae30\ubc18 \ud2b8\ub9ac\uac70\ub85c \uc124\uc815\ud574\ub450\uba74, \ub9e4\uc77c \uc544\uce68 \ucd9c\uadfc \uc804\uc5d0 \uc774\uba54\uc77c\ub85c \ud314\ub85c\uc5c5 \ub9ac\uc2a4\ud2b8\ub97c \ubc1b\uc544\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub2e8, \uc774 \ub2e8\uacc4\ub294 \uc790\ubc14\uc2a4\ud06c\ub9bd\ud2b8 \uae30\ubcf8 \uc9c0\uc2dd\uc774 \uc788\uc5b4\uc57c \ud3b8\ud558\uac8c \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br>\ucf54\ub529\uc774 \ubd80\ub2f4\ub418\uc2e0\ub2e4\uba74, \uc55e\uc11c \uc18c\uac1c\ud55c \uc870\uac74\ubd80 \uc11c\uc2dd + \ud544\ud130 \ubdf0 \uc870\ud569\ub9cc\uc73c\ub85c\ub3c4 \uc2e4\ubb34\uc5d0\uc11c\ub294 \ucda9\ubd84\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc81c\uac00 \uc4f0\uba74\uc11c \uae68\ub2ec\uc740 \uac83<\/h2>\n\n\n\n<p>\ud314\ub85c\uc5c5 \uc790\ub3d9\ud654\ub97c \uad6c\ud604\ud55c \ub4a4 \uac00\uc7a5 \ud06c\uac8c \ub2ec\ub77c\uc9c4 \uac74&nbsp;<strong>&#8220;\uae4c\uba39\uc5c8\ub2e4&#8221;\ub294 \ubcc0\uba85\uc774 \uc0ac\ub77c\uc9c4 \uac83<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc804\uc5d0\ub294 \uace0\uac1d\uc774 &#8220;\uc9c0\ub09c\ubc88\uc5d0 \uc5f0\ub77d \uc8fc\uc2e0\ub2e4\uace0 \ud558\uc168\ub294\ub370&#8230;&#8221;\ub77c\uace0 \ud560 \ub54c\ub9c8\ub2e4 \ub2f9\ud669\ud588\uc2b5\ub2c8\ub2e4.<br>\uc774\uc820 \uc2dc\ud2b8\ub9cc \uc5f4\uba74 \ub204\uad6c\uc5d0\uac8c \uc5b8\uc81c \uc5f0\ub77d\ud588\uace0, \uba70\uce60\uc774 \uc9c0\ub0ac\ub294\uc9c0\uac00 \ud55c\ub208\uc5d0 \ubcf4\uc774\ub2c8\uae4c \uadf8\ub7f0 \uc0c1\ud669\uc774 \uac70\uc758 \uc5c6\uc5b4\uc84c\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub9ac\uace0 \uc608\uc0c1 \ubabb \ud588\ub358 \ubd80\uc218 \ud6a8\uacfc\uac00 \ud558\ub098 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<br><strong>&#8220;\uba3c\uc800 \uc5f0\ub77d\ud558\uae30&#8221;\uac00 \uc2b5\uad00\uc774 \ub41c \uac83<\/strong>\uc785\ub2c8\ub2e4. \ube68\uac04\uc0c9\uc774 \uc2dc\ud2b8\uc5d0 \uc313\uc774\ub294 \uac8c \uc2dc\uac01\uc801\uc73c\ub85c \uac70\uc2ac\ub9ac\ub2e4 \ubcf4\ub2c8, \uc313\uc774\uae30 \uc804\uc5d0 \ubbf8\ub9ac \uc5f0\ub77d\ud558\uac8c \ub418\ub354\ub77c\uace0\uc694.<br>\uacb0\uacfc\uc801\uc73c\ub85c \uace0\uac1d\uc774 \uc5f0\ub77d\uc744 \uae30\ub2e4\ub9ac\uc9c0 \uc54a\uac8c \ub418\uace0, \uad00\uacc4\uc758 \uc8fc\ub3c4\uad8c\uc774 \uc790\uc5f0\uc2a4\ub7fd\uac8c \uc81c \ucabd\uc73c\ub85c \ub118\uc5b4\uc654\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\uc815\ub9ac\ud558\uba70<\/h2>\n\n\n\n<p>\ud314\ub85c\uc5c5 \uad00\ub9ac\uc758 \ud575\uc2ec\uc740 \ubcf5\uc7a1\ud55c \uc2dc\uc2a4\ud15c\uc774 \uc544\ub2d9\ub2c8\ub2e4.<br><strong>&#8220;\ub193\uce58\uc9c0 \uc54a\ub294 \uad6c\uc870&#8221;<\/strong>\ub97c \ud55c \ubc88 \ub9cc\ub4e4\uc5b4\ub450\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc624\ub298 \uc18c\uac1c\ud55c 3\ub2e8\uacc4(\ucd5c\uc885 \uc5f0\ub77d\uc77c \uae30\ub85d, \uacbd\uacfc \uc77c\uc218 \uc218\uc2dd, \uc870\uac74\ubd80 \uc11c\uc2dd \uc0c9\uc0c1 \uaddc\uce59) \ub9cc \uc124\uc815\ud574 \ub450\uba74, \ubcc4\ub3c4\uc758 \uc571\uc774\ub098 \uc54c\ub9bc \uc5c6\uc774\ub3c4 \ud314\ub85c\uc5c5\uc744 \ub193\uce58\uc9c0 \uc54a\ub294 \ud658\uacbd\uc774 \ub9cc\ub4e4\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc694\uc57d\ud558\uba74 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ucd5c\uc885 \uc5f0\ub77d\uc77c\uc744 \ubc18\ub4dc\uc2dc \uae30\ub85d\ud558\ub294 \uc2b5\uad00\uc774 \uc120\ud589\ub418\uc5b4\uc57c \ud568<\/li>\n\n\n\n<li><code>TODAY() - \ucd5c\uc885\uc5f0\ub77d\uc77c<\/code>&nbsp;\uc218\uc2dd\uc73c\ub85c \uacbd\uacfc \uc77c\uc218 \uc790\ub3d9 \uacc4\uc0b0<\/li>\n\n\n\n<li>\uc870\uac74\ubd80 \uc11c\uc2dd\uc73c\ub85c 7\uc77c\/3\uc77c \uae30\uc900 \uc0c9\uc0c1 \ucc28\ub4f1 \ud45c\uc2dc<\/li>\n\n\n\n<li>\ud544\ud130 \ubdf0\ub85c &#8220;\uc9c0\uae08 \uc5f0\ub77d\ud560 \uace0\uac1d&#8221;\ub9cc \ucd94\ucd9c<\/li>\n\n\n\n<li>\uc5ec\uc720\uac00 \uc788\uc73c\uba74 Apps Script\ub85c \ub9e4\uc77c \uc544\uce68 \uc790\ub3d9 \uc774\uba54\uc77c \ubc1c\uc1a1\uae4c\uc9c0<\/li>\n<\/ul>\n\n\n\n<p>\ub2e4\uc74c \uae00\uc5d0\uc11c\ub294 \uc601\uc5c5 \ud65c\ub3d9\uc758 \ud070 \uadf8\ub9bc\uc744 \uc7a1\uc544\uc8fc\ub294\u00a0<strong>&#8220;\uc601\uc5c5 \ud30c\uc774\ud504\ub77c\uc778&#8221;<\/strong>\u00a0\uac1c\ub150\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<br>\ubbf8\uc811\ucd09 \u2192 \uba54\uc77c\ubc1c\uc1a1 \u2192 \ud68c\uc2e0\ub300\uae30 \u2192 \ubbf8\ud305 \u2192 \uc81c\uc548 \u2192 \uacc4\uc57d \uc131\uc0ac\ub85c \uc774\uc5b4\uc9c0\ub294 6\ub2e8\uacc4 \ud750\ub984\uc744, \uad6c\uae00\uc2dc\ud2b8\uc5d0\uc11c \uc5b4\ub5bb\uac8c \uad6c\uc870\ud654\ud558\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\ub294\uc9c0 \uc815\ub9ac\ud560 \uc608\uc815\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\uc774 \uae00\uc5d0\uc11c \uc124\uba85\ud55c&nbsp;<strong>\ud314\ub85c\uc5c5 \uc790\ub3d9 \uc54c\ub9bc + \uc870\uac74\ubd80 \uc11c\uc2dd + \uc601\uc5c5 \ub2e8\uacc4 \uc5f0\ub3d9 + \uc790\ub3d9 \uba54\uc77c \uc54c\ub9bc<\/strong>\uc774 \ubaa8\ub450 \uc138\ud305\ub418\uc5b4 \uc788\ub294 \uad6c\uae00\uc2dc\ud2b8 CRM \ud15c\ud50c\ub9bf\uc774 \uc788\uc2b5\ub2c8\ub2e4.<br>\uc218\uc2dd \ud558\ub098\ud558\ub098 \uc9c1\uc811 \uc124\uc815\ud558\ub294 \uc2dc\uac04\uc744 \uc544\ub07c\uace0 \uc2f6\ub2e4\uba74&nbsp;<a href=\"https:\/\/kmong.com\/self-marketing\/750565\/JRxsBtHdtX\"><strong>SalesSheet<\/strong><\/a>\uc744 \ud655\uc778\ud574\ubcf4\uc138\uc694. \uace0\uac1d DB\uc5d0 \ucd5c\uc885 \uc5f0\ub77d\uc77c\ub9cc \uc785\ub825\ud558\uba74 \ud314\ub85c\uc5c5 \uc54c\ub9bc\uc774 \ubc14\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>\ub2e4\uc74c \uae00 \uc608\uace0:<\/strong>&nbsp;&#8220;\uc601\uc5c5 \ud30c\uc774\ud504\ub77c\uc778\uc774\ub780? \uc18c\uaddc\ubaa8 \uc0ac\uc5c5\uc790\ub3c4 \uaf2d \uad00\ub9ac\ud574\uc57c \ud558\ub294 \uc774\uc720&#8221;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc5f0\ub77d\ud55c\ub2e4\uace0 \ud55c \uac74\ub370 \uadf8 \uc0ac\uc774\uc5d0 \ub193\ucce4\ub2e4.&#8221; \ud314\ub85c\uc5c5 \ud0c0\uc774\ubc0d\uc740 \uacc4\uc57d \uc131\uc0ac\uc728\uc744 \uacb0\uc815\ud569\ub2c8\ub2e4. \uad6c\uae00\uc2dc\ud2b8 \uc870\uac74\ubd80 \uc11c\uc2dd\uacfc \uc218\uc2dd\ub9cc\uc73c\ub85c 7\uc77c \uc774\uc0c1 \uc5f0\ub77d \uc5c6\ub294 \uace0\uac1d\uc744 \uc790\ub3d9\uc73c\ub85c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc2e4\uc804 \uc608\uc2dc\uc640 \ud568\uaed8 \uc815\ub9ac\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[159,157],"tags":[179,183,184,180,181,182],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-crm","category-157","tag-179","tag-183","tag-184","tag-180","tag-181","tag-182"],"_links":{"self":[{"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=359"}],"version-history":[{"count":8,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions"}],"predecessor-version":[{"id":368,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions\/368"}],"wp:attachment":[{"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}