{"id":352,"date":"2026-04-21T10:30:00","date_gmt":"2026-04-21T01:30:00","guid":{"rendered":"https:\/\/wizardofcode.kr\/?p=352"},"modified":"2026-04-20T15:17:17","modified_gmt":"2026-04-20T06:17:17","slug":"%ea%b5%ac%ea%b8%80%ec%8b%9c%ed%8a%b8-%eb%a9%94%ec%9d%bc%eb%a8%b8%ec%a7%80-%ec%99%84%ec%a0%84-%ea%b0%80%ec%9d%b4%eb%93%9c-%ea%b3%a0%ea%b0%9d-100%eb%aa%85%ec%97%90%ea%b2%8c-%eb%a7%9e%ec%b6%a4","status":"publish","type":"post","link":"https:\/\/wizardofcode.kr\/?p=352","title":{"rendered":"\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"},"content":{"rendered":"\n<p>\uc9c0\ub09c \uae00\uc5d0\uc11c \uad6c\uae00\uc2dc\ud2b8\uc5d0 600\uba85\uc758 \uace0\uac1d DB\ub97c \uc5b4\ub5bb\uac8c \uad6c\ucd95\ud588\ub294\uc9c0\ub97c \uacf5\uc720\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><a href=\"https:\/\/wizardofcode.kr\/?p=346\" data-type=\"post\" data-id=\"346\">\uad00\ub828 \uae00: [600\uba85 \uba85\ud568 DB\ub97c \uad6c\uae00\uc2dc\ud2b8\ub85c \uc815\ub9ac\ud558\uba70 \ubc30\uc6b4 \uac83\ub4e4]<\/a><\/p>\n<\/blockquote>\n\n\n\n<p>DB\ub97c \ub9cc\ub4e4\uc5c8\uc73c\uba74 \uc774\uc81c \uc368\uba39\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uace0\uac1d DB\uc758 \uac00\uce58\uac00 \uac00\uc7a5 \uadf9\uc801\uc73c\ub85c \ub4dc\ub7ec\ub098\ub294 \uc21c\uac04\uc774 \ubc14\ub85c&nbsp;<strong>\uba54\uc77c \ubc1c\uc1a1<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>&#8220;\ubd04 \uc2dc\uc98c\uc5d0 \ud589\uc0ac \ub2c8\uc988\uac00 \ub192\uc740 A\ub4f1\uae09 \uace0\uac1d 30\uba85\uc5d0\uac8c, \uac01\uc790\uc758 \uc774\ub984\uacfc \uc18c\uc18d\uc744 \ub123\uc740 \uac1c\uc778\ud654\ub41c \uc81c\uc548 \uba54\uc77c\uc744 \ub3d9\uc2dc\uc5d0 \ubcf4\ub0b8\ub2e4&#8221; \u2014 \uc774\uac8c \uc218\ub3d9\uc73c\ub85c\ub294 1~2\uc2dc\uac04\uc774 \uac78\ub9ac\uc9c0\ub9cc, \uba54\uc77c\uba38\uc9c0\ub85c\ub294 5\ubd84\uc774\uba74 \ub05d\ub0a9\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \uae00\uc740 \uad6c\uae00\uc2dc\ud2b8\uc5d0\uc11c \uba54\uc77c\uba38\uc9c0\ub97c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 3\uac00\uc9c0\ub85c \uc815\ub9ac\ud55c \uc2e4\ubb34 \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4.<br>\uac01 \ubc29\ubc95\uc758 \uc7a5\ub2e8\uc810\uacfc, \uc5b4\ub5a4 \uc0c1\ud669\uc5d0 \uc5b4\ub5a4 \ubc29\ubc95\uc774 \ub9de\ub294\uc9c0\ub97c \uc815\ub9ac\ud588\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\">\uba54\uc77c\uba38\uc9c0\ub780 \ubb34\uc5c7\uc778\uac00<\/h2>\n\n\n\n<p>\uba54\uc77c\uba38\uc9c0(Mail Merge)\ub294&nbsp;<strong>\ud558\ub098\uc758 \ud15c\ud50c\ub9bf\uc5d0 \uac01 \uc218\uc2e0\uc790\uc758 \uc815\ubcf4\ub97c \uc790\ub3d9\uc73c\ub85c \ub07c\uc6cc \ub123\uc5b4 \uac1c\ubcc4 \uba54\uc77c\ub85c \ubc1c\uc1a1\ud558\ub294<\/strong>&nbsp;\uae30\ub2a5\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4 \uc774\ub7f0 \ud15c\ud50c\ub9bf\uc774 \uc788\ub2e4\uace0 \ud574\ubd05\uc2dc\ub2e4.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\uc548\ub155\ud558\uc138\uc694, <strong>{\uc774\ub984}<\/strong>\ub2d8.<br><strong>{\uc18c\uc18d}<\/strong>\uc758 \ubc1c\uc804\uc744 \uae30\uc6d0\ud569\ub2c8\ub2e4.<br>\uc800\ud76c\uac00 <strong>{\uc774\ub984}<\/strong>\ub2d8\uaed8 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\ub294 \uc11c\ube44\uc2a4\ub97c \uc18c\uac1c\ub4dc\ub9ac\uace0 \uc2f6\uc5b4&#8230;<\/p>\n<\/blockquote>\n\n\n\n<p>\uc774 \ud15c\ud50c\ub9bf\uc5d0\uc11c\u00a0<code>{\uc774\ub984}<\/code>\uacfc\u00a0<code>{\uc18c\uc18d}<\/code>\u00a0\ubd80\ubd84\uc744 \uace0\uac1d DB\uc758 \uac01 \ud589\uc5d0 \uc788\ub294 \uac12\uc73c\ub85c \uce58\ud658\ud558\uba74, 30\uba85\uc5d0\uac8c \ubcf4\ub0b4\ub294 \uba54\uc77c\uc774 \ubaa8\ub450 &#8220;\uae40\ucca0\uc218\ub2d8 \/ \uc0bc\uc131\uc804\uc790&#8221;, &#8220;\uc774\uc601\ud76c\ub2d8 \/ LG\uc804\uc790&#8221;\ucc98\ub7fc \uac1c\uc778\ud654\ub429\ub2c8\ub2e4.<br>\ubc1b\ub294 \uc0ac\ub78c \uc785\uc7a5\uc5d0\uc11c\ub294 \uc790\uc2e0\ub9cc\uc744 \uc704\ud574 \uc4f4 \uba54\uc77c\ucc98\ub7fc \ub290\uaef4\uc9c0\uc8e0.<\/p>\n\n\n\n<p>\uc218\ub3d9\uc73c\ub85c \ud558\uc790\uba74, \uba54\uc77c\uc744 \uc5f4\uace0 \u2192 \uc774\ub984 \ubc14\uafb8\uace0 \u2192 \uc18c\uc18d \ubc14\uafb8\uace0 \u2192 \ubc1c\uc1a1\ud558\uace0 \u2192 \ub2e4\uc74c \uc0ac\ub78c \uba54\uc77c\uc744 \uc5f4\uace0 \u2192 \ubc18\ubcf5.<br>30\uba85\uc774\uba74 \ucd5c\uc18c 1\uc2dc\uac04\uc774 \uac78\ub9bd\ub2c8\ub2e4.<br>\uadf8\ub9ac\uace0 \uc911\uac04\uc5d0 \uc774\ub984\uc744 \uc798\ubabb \ubcf5\uc0ac\ud574\uc11c &#8220;\uc548\ub155\ud558\uc138\uc694, \uc774\uc601\ud76c\ub2d8 \/ \uc0bc\uc131\uc804\uc790&#8221;\ub77c\ub294 \uba54\uc77c\uc744 \ubcf4\ub0b4\uac8c \ub418\ub294 \uc0ac\uace0\ub3c4 \ud55c \ubc88\ucbe4\uc740 \uc77c\uc5b4\ub0a9\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uba54\uc77c\uba38\uc9c0\ub294 \uc774 \uacfc\uc815\uc744 \uc790\ub3d9\ud654\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:40px\" 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\">\ubc29\ubc95 1 \u2014 Gmail \uae30\ubcf8 \uae30\ub2a5 &#8216;\uc774\uba54\uc77c \ub300\ub7c9 \ubc1c\uc1a1&#8217; (\uac00\uc7a5 \uc26c\uc6c0)<\/h2>\n\n\n\n<p><strong>Google Workspace \uc720\ub8cc \ud50c\ub79c<\/strong>\u00a0\uc0ac\uc6a9\uc790\uc5d0\uac8c\ub9cc \uc81c\uacf5\ub418\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4.<br>2023\ub144\ubd80\ud130 Gmail\uc5d0 \uc815\uc2dd \ub0b4\uc7a5\ub410\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uc5b4\ub5bb\uac8c \uc4f0\ub098<\/h3>\n\n\n\n<p>Gmail\uc5d0\uc11c \uc0c8 \uba54\uc77c\uc744 \uc791\uc131\ud560 \ub54c, &#8216;\ubc1b\ub294 \uc0ac\ub78c&#8217; \uc606\uc758 &#8216;\uc774\uba54\uc77c \ub300\ub7c9 \ubc1c\uc1a1 \uc0ac\uc6a9&#8217; \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uace0, \uc218\uc2e0\uc790 \ub9ac\uc2a4\ud2b8\ub97c \uad6c\uae00\uc2dc\ud2b8\uc5d0\uc11c \ubd88\ub7ec\uc624\uba74 \ub429\ub2c8\ub2e4. \ubcf8\ubb38\uc5d0&nbsp;<code>@\uc774\ub984<\/code>,&nbsp;<code>@\uc131<\/code>&nbsp;\uac19\uc740&nbsp;<strong>\ubcd1\ud569 \ud0dc\uadf8<\/strong>\ub97c \ub123\uc73c\uba74 \uac01 \uc218\uc2e0\uc790\uc758 \uc815\ubcf4\ub85c \uc790\ub3d9 \uce58\ud658\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubc1c\uc1a1 \ud6c4 Gmail &#8216;\ubcf4\ub0b8\ud3b8\uc9c0\ud568&#8217;\uc744 \uc5f4\uba74 \uac01 \uc218\uc2e0\uc790\uc5d0\uac8c \uac1c\ubcc4 \ubc1c\uc1a1\ub41c \uba54\uc77c\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\uc7a5\uc810<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ucf54\ub4dc \ubd88\ud544\uc694<\/strong>\u00a0\u2014 \uc124\uce58\ud560 \uac83\ub3c4, \uc791\uc131\ud560 \uc2a4\ud06c\ub9bd\ud2b8\ub3c4 \uc5c6\uc2b5\ub2c8\ub2e4<\/li>\n\n\n\n<li><strong>Gmail \uc778\ud130\ud398\uc774\uc2a4 \uadf8\ub300\ub85c<\/strong>\u00a0\u2014 \ud3c9\uc18c \uba54\uc77c \uc4f0\ub358 \ubc29\uc2dd\uacfc \ub3d9\uc77c<\/li>\n\n\n\n<li><strong>\uc218\uc2e0 \uac70\ubd80 \ub9c1\ud06c \uc790\ub3d9 \uc0bd\uc785<\/strong>\u00a0\u2014 \uba54\uc77c \ud558\ub2e8\uc5d0 \uc790\ub3d9\uc73c\ub85c \ubd99\uc5b4 CAN-SPAM \uc900\uc218<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ub2e8\uc810<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc720\ub8cc \uc804\uc6a9<\/strong>\u00a0\u2014 \ubb34\ub8cc Gmail \uacc4\uc815\uc5d0\uc11c\ub294 \uc0ac\uc6a9 \ubd88\uac00<\/li>\n\n\n\n<li><strong>\ubc1c\uc1a1 \uc774\ub825 \uad00\ub9ac \uc548 \ub428<\/strong>\u00a0\u2014 \ub204\uad6c\uc5d0\uac8c \uc5b8\uc81c \uc5b4\ub5a4 \uba54\uc77c\uc744 \ubcf4\ub0c8\ub294\uc9c0 \uc2dc\ud2b8\uc5d0 \uae30\ub85d\ub418\uc9c0 \uc54a\uc74c<\/li>\n\n\n\n<li><strong>\uc601\uc5c5 \ub2e8\uacc4 \uc790\ub3d9 \uc5c5\ub370\uc774\ud2b8 \uc548 \ub428<\/strong>\u00a0\u2014 \ubc1c\uc1a1 \ud6c4 \uace0\uac1d DB\uc758 &#8220;\uc601\uc5c5 \ub2e8\uacc4&#8221;\ub97c \uc218\ub3d9\uc73c\ub85c \ubc14\uafd4\uc57c \ud568<\/li>\n<\/ul>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\ub204\uad6c\uc5d0\uac8c \uc801\ud569\ud55c\uac00<\/h3>\n\n\n\n<p>\uc774\ubbf8 Google Workspace\ub97c \uc4f0\uace0 \uc788\uace0, \uac00\ub054\uc529 \uac04\ub2e8\ud55c \uacf5\uc9c0 \uba54\uc77c\uc744 \ub300\ub7c9 \ubc1c\uc1a1\ud558\ub294 \uc815\ub3c4\ub77c\uba74 \uc774 \ubc29\ubc95\uc774 \uac00\uc7a5 \uac04\ud3b8\ud569\ub2c8\ub2e4.<br>\ub2e4\ub9cc\u00a0<strong>\uc601\uc5c5 \uad00\ub9ac\uc640 \uc5f0\ub3d9\ub418\uc9c0 \uc54a\ub294\ub2e4<\/strong>\ub294 \uce58\uba85\uc801 \uc57d\uc810\uc774 \uc788\uc5b4\uc11c, \uace0\uac1d \uad00\uacc4 \uad00\ub9ac\uac00 \ubaa9\uc801\uc774\ub77c\uba74 \ubd80\uc871\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\ubc29\ubc95 2 \u2014 Apps Script\ub85c \uc9c1\uc811 \uad6c\ud604 (\ubb34\ub8cc, \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5 \uc790\uc720)<\/h2>\n\n\n\n<p>\uad6c\uae00\uc2dc\ud2b8\uc758 \ub0b4\uc7a5 \uc2a4\ud06c\ub9bd\ud2b8 \ub3c4\uad6c\uc778&nbsp;<strong>Apps Script<\/strong>\ub97c \uc774\uc6a9\ud574 \uba54\uc77c\uba38\uc9c0\ub97c \uc9c1\uc811 \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ubb34\ub8cc Gmail \uacc4\uc815\uc5d0\uc11c\ub3c4 \uc791\ub3d9\ud569\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\">\uae30\ubcf8 \uc6d0\ub9ac<\/h3>\n\n\n\n<p>\uad6c\uae00\uc2dc\ud2b8\uc758 \uace0\uac1d DB\uc5d0\uc11c \uc218\uc2e0\uc790 \ubaa9\ub85d\uc744 \uc77d\uc5b4\uc624\uace0, \uac01 \ud589\uc758 \uc815\ubcf4\ub85c \ud15c\ud50c\ub9bf\uc744 \uce58\ud658\ud55c \ub4a4,&nbsp;<code>GmailApp.sendEmail()<\/code>&nbsp;\ud568\uc218\ub85c \ubc1c\uc1a1\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uac04\ub2e8\ud55c \uc608\uc2dc \ucf54\ub4dc\ub294 \uc774\ub807\uc2b5\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 sendMailMerge() {\n  var sheet = SpreadsheetApp.getActiveSheet();\n  var data = sheet.getDataRange().getValues();\n  var template = \"\uc548\ub155\ud558\uc138\uc694, {\uc774\ub984}\ub2d8.\\n{\uc18c\uc18d}\uc758 \ubc1c\uc804\uc744 \uae30\uc6d0\ud569\ub2c8\ub2e4.\";\n  \n  for (var i = 1; i &lt; data.length; i++) {\n    var name = data&#91;i&#93;&#91;0&#93;;      \/\/ A\uc5f4: \uc774\ub984\n    var company = data&#91;i&#93;&#91;1&#93;;   \/\/ B\uc5f4: \uc18c\uc18d\n    var email = data&#91;i&#93;&#91;2&#93;;     \/\/ C\uc5f4: \uc774\uba54\uc77c\n    \n    var body = template\n      .replace(\"{\uc774\ub984}\", name)\n      .replace(\"{\uc18c\uc18d}\", company);\n    \n    GmailApp.sendEmail(email, \"\uc548\ub0b4 \uba54\uc77c\", 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: #81A1C1\">function<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">sendMailMerge<\/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\">  <\/span><span style=\"color: #81A1C1\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">sheet<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">SpreadsheetApp<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">getActiveSheet<\/span><span style=\"color: #D8DEE9FF\">()<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">data<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">sheet<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">getDataRange<\/span><span style=\"color: #D8DEE9FF\">()<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">getValues<\/span><span style=\"color: #D8DEE9FF\">()<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  <\/span><span style=\"color: #81A1C1\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">template<\/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\">\uc548\ub155\ud558\uc138\uc694, {\uc774\ub984}\ub2d8.<\/span><span style=\"color: #EBCB8B\">\\n<\/span><span style=\"color: #A3BE8C\">{\uc18c\uc18d}\uc758 \ubc1c\uc804\uc744 \uae30\uc6d0\ud569\ub2c8\ub2e4.<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #81A1C1\">;<\/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: #81A1C1\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">i<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #81A1C1\">;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">i<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">&lt;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">data<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #D8DEE9FF\">length<\/span><span style=\"color: #81A1C1\">;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">i<\/span><span style=\"color: #81A1C1\">++<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #ECEFF4\">{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">name<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">data<\/span><span style=\"color: #D8DEE9FF\">&#91;<\/span><span style=\"color: #D8DEE9\">i<\/span><span style=\"color: #D8DEE9FF\">&#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: #616E88\">\/\/ A\uc5f4: \uc774\ub984<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">company<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">data<\/span><span style=\"color: #D8DEE9FF\">&#91;<\/span><span style=\"color: #D8DEE9\">i<\/span><span style=\"color: #D8DEE9FF\">&#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: #616E88\">\/\/ B\uc5f4: \uc18c\uc18d<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #81A1C1\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">email<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">data<\/span><span style=\"color: #D8DEE9FF\">&#91;<\/span><span style=\"color: #D8DEE9\">i<\/span><span style=\"color: #D8DEE9FF\">&#93;&#91;<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">&#93;<\/span><span style=\"color: #81A1C1\">;<\/span><span style=\"color: #D8DEE9FF\">     <\/span><span style=\"color: #616E88\">\/\/ C\uc5f4: \uc774\uba54\uc77c<\/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\">var<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">body<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">template<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">      <\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">replace<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">{\uc774\ub984}<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">name<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">      <\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">replace<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">{\uc18c\uc18d}<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">company<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">GmailApp<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">sendEmail<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">email<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">\uc548\ub0b4 \uba54\uc77c<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">body<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/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>\uc2a4\ud06c\ub9bd\ud2b8 \ud3b8\uc9d1\uae30\uc5d0\uc11c \uc774 \ucf54\ub4dc\ub97c \uc800\uc7a5\ud558\uace0 \uc2e4\ud589 \uad8c\ud55c\uc744 \uc2b9\uc778\ud558\uba74, \uc2dc\ud2b8\uc5d0\uc11c \uc9c1\uc811 \uba54\uc77c\uc774 \ubc1c\uc1a1\ub429\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\">\uc7a5\uc810<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ubb34\ub8cc<\/strong>\u00a0\u2014 \uc77c\ubc18 Gmail \uacc4\uc815\uc5d0\uc11c\ub3c4 \uc0ac\uc6a9 \uac00\ub2a5<\/li>\n\n\n\n<li><strong>\uc644\uc804\ud55c \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5<\/strong>\u00a0\u2014 \ubc1c\uc1a1 \uc774\ub825 \uae30\ub85d, \uc601\uc5c5 \ub2e8\uacc4 \uc5c5\ub370\uc774\ud2b8, \uc870\uac74\ubd80 \ubc1c\uc1a1 \ub4f1 \uc6d0\ud558\ub294 \ub300\ub85c \ud655\uc7a5 \uac00\ub2a5<\/li>\n\n\n\n<li><strong>HTML \uba54\uc77c \uc9c0\uc6d0<\/strong>\u00a0\u2014\u00a0<code>htmlBody<\/code>\u00a0\uc635\uc158\uc73c\ub85c \ub514\uc790\uc778 \uba54\uc77c \ubc1c\uc1a1 \uac00\ub2a5<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ub2e8\uc810<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ucf54\ub4dc \uc791\uc131 \ud544\uc694<\/strong>\u00a0\u2014 \uc790\ubc14\uc2a4\ud06c\ub9bd\ud2b8\ub97c \ubaa8\ub974\uba74 \uc9c4\uc785 \uc7a5\ubcbd\uc774 \uc788\uc2b5\ub2c8\ub2e4<\/li>\n\n\n\n<li><strong>\ub514\ubc84\uae45 \ud544\uc694<\/strong>\u00a0\u2014 \ucc98\uc74c \uc2e4\ud589 \uc2dc \uad8c\ud55c \uc2b9\uc778, \uc624\ub958 \ud574\uacb0 \ub4f1 \uc2dc\ud589\ucc29\uc624 \ubc1c\uc0dd<\/li>\n\n\n\n<li><strong>\uc720\uc9c0\ubcf4\uc218 \ubd80\ub2f4<\/strong>\u00a0\u2014 \ud544\ub4dc\uac00 \ubc14\ub00c\uac70\ub098 \uae30\ub2a5\uc744 \ucd94\uac00\ud560 \ub54c\ub9c8\ub2e4 \ucf54\ub4dc\ub97c \uc218\uc815\ud574\uc57c \ud568<\/li>\n<\/ul>\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\">\ubc1c\uc1a1 \ud55c\ub3c4\ub97c \uaf2d \ud655\uc778\ud558\uc138\uc694<\/h3>\n\n\n\n<p>Gmail\uc758 \uc77c\uc77c \ubc1c\uc1a1 \ud55c\ub3c4\ub294 \ubc18\ub4dc\uc2dc \uc54c\uace0 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uacc4\uc815 \uc885\ub958<\/th><th>\uc77c\uc77c \ubc1c\uc1a1 \ud55c\ub3c4<\/th><\/tr><\/thead><tbody><tr><td>\ubb34\ub8cc Gmail<\/td><td><strong>100\ud1b5\/\uc77c<\/strong>(\uc548\uc815\uc801)<\/td><\/tr><tr><td>Google Workspace (\uc720\ub8cc)<\/td><td><strong>2,000\ud1b5\/\uc77c<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Apps Script\ub85c \ubc1c\uc1a1\ud574\ub3c4 \uc774 \ud55c\ub3c4\ub294 \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ub429\ub2c8\ub2e4.<br>\ud55c\ub3c4\ub97c \ucd08\uacfc\ud558\uba74 \uacc4\uc815\uc774 \uc77c\uc2dc \uc815\uc9c0\ub418\uac70\ub098 \ucd5c\uc545\uc758 \uacbd\uc6b0 \uc601\uad6c \uc81c\ud55c\ub420 \uc218 \uc788\uc73c\ub2c8, \uc218\ubc31 \uba85 \ub2e8\uc704\uc758 \ubc1c\uc1a1\uc744 \uacc4\ud68d\ud55c\ub2e4\uba74 \uc720\ub8cc Workspace \uc804\ud658\uc744 \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubb34\ub8cc Gmail\uc5d0 \uacbd\uc6b0 \uc815\ud655\ud55c \ubc1c\uc1a1 \ud55c\ub3c4\uac00 \uacf5\uac1c\ub418\uc5b4\uc788\uc9c0 \uc54a\uc73c\ub098 100\ud1b5\uc774 \ub118\uc5b4\uac00\uba74 \uc77c\uc2dc \uc911\ub2e8\uc774 \ub418\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\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\">\ub204\uad6c\uc5d0\uac8c \uc801\ud569\ud55c\uac00<\/h3>\n\n\n\n<p>\uac1c\ubc1c \uacbd\ud5d8\uc774 \uc788\uace0, \uc790\uc2e0\uc758 \uc5c5\ubb34\uc5d0 \uc644\ubcbd\ud558\uac8c \ub9de\ub294 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud558\uace0 \uc2f6\uc740 \ubd84\uc774\ub77c\uba74 \uc774 \ubc29\ubc95\uc774 \uac00\uc7a5 \uc720\uc5f0\ud569\ub2c8\ub2e4.<br>\ub2e4\ub9cc \uad6c\ud604\uacfc \uc720\uc9c0\ubcf4\uc218\uc5d0 \uc2dc\uac04\uc774 \uaf64 \ub4ed\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\ubc29\ubc95 3 \u2014 \uc644\uc131\ub41c \uba54\uc77c\uba38\uc9c0 \uc2dc\uc2a4\ud15c \uc0ac\uc6a9 (\uc2dc\uac04 \uc808\uc57d)<\/h2>\n\n\n\n<p>\uc9c1\uc811 \ucf54\ub4dc\ub97c \uc9dc\uc9c0 \uc54a\uace0, \uc774\ubbf8 \uad6c\ucd95\ub41c \uc2dc\uc2a4\ud15c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<br>\ud06c\uac8c \ub450 \uac00\uc9c0 \uc120\ud0dd\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3-1. \ubb34\ub8cc \uc560\ub4dc\uc628 \ud65c\uc6a9<\/h3>\n\n\n\n<p>\uad6c\uae00\uc2dc\ud2b8 \ub9c8\ucf13\ud50c\ub808\uc774\uc2a4\uc5d0\uc11c &#8216;Mail Merge&#8217; \ud0a4\uc6cc\ub4dc\ub85c \uac80\uc0c9\ud558\uba74 \uc5ec\ub7ec \ubb34\ub8cc \uc560\ub4dc\uc628\uc774 \ub098\uc635\ub2c8\ub2e4. \ub300\ud45c\uc801\uc73c\ub85c&nbsp;<strong>Yet Another Mail Merge (YAMM)<\/strong>,&nbsp;<strong>Mailmeteor<\/strong>&nbsp;\ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\uc7a5\uc810<\/strong>: \ubb34\ub8cc \ubc84\uc804 \uc81c\uacf5, \uc124\uce58\ub9cc \ud558\uba74 \ubc14\ub85c \uc0ac\uc6a9 \uac00\ub2a5<br><strong>\ub2e8\uc810<\/strong>: \ubb34\ub8cc \ubc84\uc804\uc740 \uc77c\uc77c \ubc1c\uc1a1 \uc218 \uc81c\ud55c(\ubcf4\ud1b5 50~75\ud1b5), \ud55c\uad6d\uc5b4 \uc9c0\uc6d0 \ubd80\uc871, \uc720\ub8cc \uc804\ud658 \uc555\ubc15, \uc601\uc5c5 \uad00\ub9ac \uae30\ub2a5\uc740 \uc5c6\uc74c<\/p>\n\n\n\n<p>\uc560\ub4dc\uc628\uc740&nbsp;<strong>\uba54\uc77c \ubc1c\uc1a1<\/strong>\ub9cc \ud574\uacb0\ud569\ub2c8\ub2e4. &#8220;\ub204\uad6c\uc5d0\uac8c \uc5b8\uc81c \uc5b4\ub5a4 \uba54\uc77c\uc744 \ubcf4\ub0c8\ub294\uc9c0&#8221; \uae30\ub85d\ud558\uace0, &#8220;\uc601\uc5c5 \ub2e8\uacc4\ub97c \uc790\ub3d9\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud558\ub294&#8221; \uae30\ub2a5\uc740 \uc81c\uacf5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774 \ubd80\ubd84\uc740 \uc5ec\uc804\ud788 \uc218\ub3d9\uc73c\ub85c \uad00\ub9ac\ud574\uc57c \ud558\uc8e0.<\/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\">3-2. CRM \uae30\ub2a5\uc774 \ub0b4\uc7a5\ub41c \ud15c\ud50c\ub9bf \uc0ac\uc6a9<\/h3>\n\n\n\n<p>\uba54\uc77c\uba38\uc9c0\ubfd0\ub9cc \uc544\ub2c8\ub77c&nbsp;<strong>\ubc1c\uc1a1 \uc774\ub825 \uc790\ub3d9 \uae30\ub85d, \uc601\uc5c5 \ub2e8\uacc4 \uc5c5\ub370\uc774\ud2b8, \ub300\uc2dc\ubcf4\ub4dc \uc5f0\ub3d9<\/strong>\uae4c\uc9c0 \ubaa8\ub450 \ud3ec\ud568\ub41c \ud15c\ud50c\ub9bf\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4 \uc81c\uac00 \uc9c1\uc811 \ub9cc\ub4e4\uc5b4 \uc4f0\uace0 \uc788\ub294 SalesSheet\uc758 \uacbd\uc6b0, \uc0ac\uc6a9 \ud750\ub984\uc774 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\uace0\uac1d DB \uc2dc\ud2b8\uc5d0\uc11c \ubc1c\uc1a1\ud560 \ub300\uc0c1\uc744\u00a0<strong>\uccb4\ud06c\ubc15\uc2a4\ub85c \uc120\ud0dd<\/strong><\/li>\n\n\n\n<li>\uba54\ub274\uc5d0\uc11c\u00a0<strong>\ubc1c\uc1a1\ud560 \ud15c\ud50c\ub9bf\uc744 \uc120\ud0dd<\/strong>\u00a0(\ucd08\uae30 \uc548\ub0b4 \/ \uc11c\ube44\uc2a4 \uc81c\uc548 \/ \ud314\ub85c\uc5c5 \uc911)<\/li>\n\n\n\n<li>\ubbf8\ub9ac\ubcf4\uae30 \ud655\uc778 \ud6c4\u00a0<strong>\ubc1c\uc1a1 \ubc84\ud2bc \ud074\ub9ad<\/strong><\/li>\n\n\n\n<li>\ubc1c\uc1a1 \uc644\ub8cc \uc2dc \uc790\ub3d9\uc73c\ub85c:\n<ul class=\"wp-block-list\">\n<li>\ud574\ub2f9 \uace0\uac1d\uc758\u00a0<strong>\uc601\uc5c5 \ub2e8\uacc4<\/strong>\uac00 &#8220;\uba54\uc77c\ubc1c\uc1a1&#8221;\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8<\/li>\n\n\n\n<li><strong>\ucd5c\uc885 \uc5f0\ub77d\uc77c<\/strong>\uc774 \uc624\ub298 \ub0a0\uc9dc\ub85c \uae30\ub85d<\/li>\n\n\n\n<li><strong>\ubc1c\uc1a1 \uc774\ub825 \uc2dc\ud2b8<\/strong>\uc5d0 \ub204\uad6c\uc5d0\uac8c \uc5b8\uc81c \uc5b4\ub5a4 \ud15c\ud50c\ub9bf\uc73c\ub85c \ubcf4\ub0c8\ub294\uc9c0 \uae30\ub85d<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>30\uba85\uc5d0\uac8c \ubc1c\uc1a1\ud560 \ub54c \uc2e4\uc81c \uc18c\uc694 \uc2dc\uac04\uc774&nbsp;<strong>5\ubd84 \ubbf8\ub9cc<\/strong>\uc785\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\">\ub204\uad6c\uc5d0\uac8c \uc801\ud569\ud55c\uac00<\/h3>\n\n\n\n<p>\ucf54\ub4dc\ub97c \uc9dc\uace0 \uc2f6\uc9c0 \uc54a\uace0, \ub2e8\uc21c \uba54\uc77c \ubc1c\uc1a1\uc744 \ub118\uc5b4\u00a0<strong>\uc601\uc5c5 \uad00\ub9ac\uc640 \uc5f0\ub3d9\ub41c \uc2dc\uc2a4\ud15c<\/strong>\uc774 \ud544\uc694\ud55c \ubd84.<br>\ub300\ubd80\ubd84\uc758 \uc18c\uaddc\ubaa8 \uc0ac\uc5c5\uc790\uac00 \uc5ec\uae30 \ud574\ub2f9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uc138 \uac00\uc9c0 \ubc29\ubc95 \ube44\uad50\ud45c<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\uad6c\ubd84<\/th><th>Gmail \ub300\ub7c9 \ubc1c\uc1a1<\/th><th>Apps Script \uc9c1\uc811<\/th><th>\uc644\uc131\ub41c \ud15c\ud50c\ub9bf<\/th><\/tr><\/thead><tbody><tr><td>\ube44\uc6a9<\/td><td>Workspace \uc720\ub8cc \ud544\uc694<\/td><td>\ubb34\ub8cc<\/td><td>\ud15c\ud50c\ub9bf \uad6c\ub9e4\ube44<\/td><\/tr><tr><td>\ucf54\ub529<\/td><td>\ubd88\ud544\uc694<\/td><td>\ud544\uc694<\/td><td>\ubd88\ud544\uc694<\/td><\/tr><tr><td>\uad6c\ud604 \uc2dc\uac04<\/td><td>\uc989\uc2dc<\/td><td>\uc218 \uc2dc\uac04~\uc218 \uc77c<\/td><td>\uc989\uc2dc<\/td><\/tr><tr><td>\ubc1c\uc1a1 \uc774\ub825 \uae30\ub85d<\/td><td>\u2717<\/td><td>\uad6c\ud604 \uac00\ub2a5<\/td><td>\u2713<\/td><\/tr><tr><td>\uc601\uc5c5 \ub2e8\uacc4 \uc790\ub3d9 \uc5c5\ub370\uc774\ud2b8<\/td><td>\u2717<\/td><td>\uad6c\ud604 \uac00\ub2a5<\/td><td>\u2713<\/td><\/tr><tr><td>HTML \ub514\uc790\uc778 \uba54\uc77c<\/td><td>\u25b3<\/td><td>\uad6c\ud604 \uac00\ub2a5<\/td><td>\u2713<\/td><\/tr><tr><td>\ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5<\/td><td>\uc81c\ud55c\uc801<\/td><td>\uc644\uc804 \uc790\uc720<\/td><td>\uc635\uc158 \uc218\uc815 \uac00\ub2a5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uba54\uc77c\uba38\uc9c0 \uc0ac\uc6a9 \uc2dc \uc8fc\uc758\uc0ac\ud56d 3\uac00\uc9c0<\/h2>\n\n\n\n<p>\uc5b4\ub5a4 \ubc29\ubc95\uc744 \uc120\ud0dd\ud558\ub4e0, \uba54\uc77c\uba38\uc9c0\ub97c \uc2e4\ubb34\uc5d0\uc11c \uc4f8 \ub54c\ub294 \uc544\ub798 3\uac00\uc9c0\ub97c \ubc18\ub4dc\uc2dc \ud655\uc778\ud574\uc57c \ud569\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\">1. \uc77c\uc77c \ubc1c\uc1a1 \ud55c\ub3c4\ub97c \ubc18\ub4dc\uc2dc \ud655\uc778<\/h3>\n\n\n\n<p>\uc55e\uc11c \ub9d0\uc500\ub4dc\ub9b0 \ub300\ub85c \ubb34\ub8cc Gmail\uc740 100\ud1b5, Workspace\ub294 2,000\ud1b5\uc785\ub2c8\ub2e4.<br>\uc774 \ud55c\ub3c4\ub294 24\uc2dc\uac04 \ub3d9\uc548 \uade0\ub4f1 \uc801\uc6a9\ub418\ub2c8 &#8220;\uc624\uc804\uc5d0 \ubab0\uc544 \ubcf4\ub0b4\uace0 \uc624\ud6c4\uc5d0 \ub610 \ubcf4\ub0b4\uae30&#8221;\ub294 \ubd88\uac00\ub2a5\ud569\ub2c8\ub2e4.<br>\ud55c\ub3c4 \ucd08\uacfc \uc2dc \uacc4\uc815\uc774 \uc77c\uc2dc \uc815\uc9c0\ub420 \uc218 \uc788\uc73c\ub2c8, \ubc1c\uc1a1 \uc218\uac00 \ub9ce\uc740 \ub0a0\uc740 \uacc4\ud68d\uc801\uc73c\ub85c \ubd84\uc0b0\ud574\uc57c \ud569\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\">2. \ubcc0\uc218 \uce58\ud658 \uc624\ub958 \ud655\uc778<\/h3>\n\n\n\n<p><code>{\uc774\ub984}<\/code>&nbsp;\ubcc0\uc218\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uce58\ud658\ub418\uc9c0 \uc54a\uc73c\uba74, \uc218\uc2e0\uc790\uac00 &#8220;\uc548\ub155\ud558\uc138\uc694, {\uc774\ub984}\ub2d8&#8221;\uc774\ub77c\ub294 \uba54\uc77c\uc744 \ubc1b\uac8c \ub429\ub2c8\ub2e4. \uc774\uac74 \uc2e0\ub8b0\ub3c4\uc5d0 \uce58\uba85\uc801\uc785\ub2c8\ub2e4. \ubcf8 \ubc1c\uc1a1 \uc804\uc5d0&nbsp;<strong>\ubc18\ub4dc\uc2dc \ubcf8\uc778 \uc774\uba54\uc77c\ub85c \ud14c\uc2a4\ud2b8 \ubc1c\uc1a1\uc744 \uba3c\uc800<\/strong>&nbsp;\ud558\uc138\uc694.<\/p>\n\n\n\n<p>\uadf8\ub9ac\uace0 \uace0\uac1d DB\uc5d0&nbsp;<strong>\uc774\uba54\uc77c \uc8fc\uc18c\uac00 \ube44\uc5b4\uc788\ub294 \uace0\uac1d\uc740 \uc790\ub3d9\uc73c\ub85c \uac74\ub108\ub6f0\ub294 \ub85c\uc9c1<\/strong>\uc774 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc548 \uadf8\ub7ec\uba74 \ube48 \uc8fc\uc18c\ub85c \ubc1c\uc1a1 \uc2dc\ub3c4\uac00 \uc774\ub8e8\uc5b4\uc838 \uc624\ub958\uac00 \ubc1c\uc0dd\ud569\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\">3. \uc2a4\ud338 \ubc29\uc9c0<\/h3>\n\n\n\n<p>\uac19\uc740 \ub0b4\uc6a9\uc758 \uba54\uc77c\uc744 \ud55c\uaebc\ubc88\uc5d0 \uc218\ubc31 \ud1b5 \ubcf4\ub0b4\uba74 Gmail\uc774 \uc2a4\ud338\uc73c\ub85c \ubd84\ub958\ud558\uac70\ub098, \uc218\uc2e0\uc790 \ucabd\uc5d0\uc11c \uc2a4\ud338 \ud544\ud130\uc5d0 \uac78\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc904\uc774\ub824\uba74:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc218\uc2e0\uc790\ub9c8\ub2e4 \ub0b4\uc6a9\uc774 \ub2e4\ub974\uac8c \ubcf4\uc774\ub3c4\ub85d<\/strong>\u00a0\ubcc0\uc218\ub97c \ucd5c\uc18c 2~3\uac1c \ud3ec\ud568 (\uc774\ub984, \uc18c\uc18d, \uc9c1\ud568 \ub4f1)<\/li>\n\n\n\n<li><strong>\ud55c \ubc88\uc5d0 \ub108\ubb34 \ub9ce\uc774 \ubcf4\ub0b4\uc9c0 \ub9d0\uace0<\/strong>\u00a050~100\ud1b5\uc529 \ub098\ub220 \ubc1c\uc1a1<\/li>\n\n\n\n<li><strong>\uc218\uc2e0 \uac70\ubd80 \ub9c1\ud06c \ud3ec\ud568<\/strong>\u00a0(\ubc95\uc801\uc73c\ub85c\ub3c4 \uad8c\uc7a5)<\/li>\n\n\n\n<li><strong>\ubc1c\uc2e0 \uc8fc\uc18c\ub294 \uc2e4\uba85 + \uc2e4\uc81c \uc11c\uba85 \ud3ec\ud568<\/strong>\ud558\uc5ec \uc5c5\ubb34 \uba54\uc77c \ud615\uc2dd \uc720\uc9c0<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uc815\ub9ac\ud558\uba70<\/h2>\n\n\n\n<p>\uba54\uc77c\uba38\uc9c0\ub294 \uace0\uac1d DB\uc758 \uac00\uce58\ub97c \uc2e4\uc81c \ub9e4\ucd9c\ub85c \ubc14\uafb8\ub294 \uac00\uc7a5 \uac15\ub825\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4.<br>30\uba85\uc5d0\uac8c \uac1c\uc778\ud654\ub41c \uba54\uc77c\uc744 5\ubd84 \ub9cc\uc5d0 \ubcf4\ub0bc \uc218 \uc788\uac8c \ub418\uba74, \uc601\uc5c5\uc758 \uc591\uacfc \uc9c8\uc774 \ub3d9\uc2dc\uc5d0 \uc62c\ub77c\uac11\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubc29\ubc95 \uc120\ud0dd \uae30\uc900\uc744 \uc694\uc57d\ud558\uba74 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Workspace \uc774\ubbf8 \uc4f0\uace0, \ub2e8\uc21c \uacf5\uc9c0\ub9cc \ubcf4\ub0b8\ub2e4\uba74<\/strong>\u00a0\u2192 Gmail \uc774\uba54\uc77c \ub300\ub7c9 \ubc1c\uc1a1<\/li>\n\n\n\n<li><strong>\uac1c\ubc1c \uacbd\ud5d8 \uc788\uace0, \uc644\ubcbd\ud55c \ub9de\ucda4 \uc2dc\uc2a4\ud15c\uc774 \ud544\uc694\ud558\ub2e4\uba74<\/strong>\u00a0\u2192 Apps Script \uc9c1\uc811 \uad6c\ud604<\/li>\n\n\n\n<li><strong>\uc2dc\uac04 \uc808\uc57d\ud558\uace0, \uc601\uc5c5 \uad00\ub9ac\uae4c\uc9c0 \uc5f0\ub3d9\ud558\ub824\uba74<\/strong>\u00a0\u2192 \uc644\uc131\ub41c CRM \ud15c\ud50c\ub9bf<\/li>\n<\/ul>\n\n\n\n<p>\ub2e4\uc74c \uae00\uc5d0\uc11c\ub294 \uad6c\uae00\uc2dc\ud2b8\uc5d0\uc11c\u00a0<strong>\ud314\ub85c\uc5c5 \ud0c0\uc774\ubc0d\uc744 \ub193\uce58\uc9c0 \uc54a\ub294 \uc790\ub3d9 \uc54c\ub9bc<\/strong>\u00a0\ub9cc\ub4dc\ub294 \ubc95\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<br>DATEDIF \uc218\uc2dd\uacfc \uc870\uac74\ubd80 \uc11c\uc2dd\ub9cc\uc73c\ub85c &#8220;7\uc77c \uc774\uc0c1 \uc5f0\ub77d \uc5c6\ub294 \uace0\uac1d&#8221;\uc744 \ube68\uac04\uc0c9\uc73c\ub85c \uc790\ub3d9 \ud45c\uc2dc\ud558\ub294 \uc2e4\uc804 \ud301\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 \uc18c\uac1c\ud55c &#8216;\ubc29\ubc95 3 \u2014 CRM \uae30\ub2a5\uc774 \ub0b4\uc7a5\ub41c \ud15c\ud50c\ub9bf&#8217;\uc774 \ud544\uc694\ud558\uc2dc\ub2e4\uba74, \uc81c\uac00 \uc2e4\uc81c \uc601\uc5c5 \ud604\uc7a5\uc5d0\uc11c \uc0ac\uc6a9\ud558\uba70 \ub9cc\ub4e0&nbsp;<a href=\"https:\/\/kmong.com\/self-marketing\/750565\/JRxsBtHdtX\"><strong>SalesSheet<\/strong><\/a>\uc744 \ud655\uc778\ud574\ubcf4\uc138\uc694.<br>\uccb4\ud06c\ubc15\uc2a4\ub85c \ub300\uc0c1 \uc120\ud0dd \u2192 \ud15c\ud50c\ub9bf \uc120\ud0dd \u2192 \ud074\ub9ad \ud55c \ubc88\uc73c\ub85c \ubc1c\uc1a1\uc774 \uc644\ub8cc\ub418\uace0, \uc601\uc5c5 \ub2e8\uacc4\uc640 \ubc1c\uc1a1 \uc774\ub825\uc774 \uc790\ub3d9 \uae30\ub85d\ub429\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>\ub2e4\uc74c \uae00 \uc608\uace0:<\/strong>&nbsp;&#8220;\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&#8221;<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uac19\uc740 \ub0b4\uc6a9\uc758 \uba54\uc77c\uc744 \uc5ec\ub7ec \uba85\uc5d0\uac8c \uac01\uac01 \uc774\ub984\uc744 \ubc14\uafd4 \ubcf4\ub0b4\ub294 \ubc29\ubc95, \uba54\uc77c\uba38\uc9c0. \uad6c\uae00\uc2dc\ud2b8\uc640 Gmail\uc744 \uc774\uc6a9\ud574 \ucf54\ub4dc \uc791\uc131\ubd80\ud130 \uc720\ub8cc \ud50c\ub7ec\uadf8\uc778, \ubc14\ub85c \uc4f0\ub294 \ud15c\ud50c\ub9bf\uae4c\uc9c0 3\uac00\uc9c0 \ubc29\ubc95\uc744 \uc2e4\ubb34 \uad00\uc810\uc5d0\uc11c \ube44\uad50\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":[174,176,177,173,175,178],"class_list":["post-352","post","type-post","status-publish","format-standard","hentry","category-crm","category-157","tag-apps-script-","tag-gmail-","tag-177","tag-173","tag-175","tag-178"],"_links":{"self":[{"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/posts\/352","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=352"}],"version-history":[{"count":6,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/posts\/352\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=\/wp\/v2\/posts\/352\/revisions\/358"}],"wp:attachment":[{"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wizardofcode.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}