{"id":4885,"date":"2024-02-23T20:20:00","date_gmt":"2024-02-23T12:20:00","guid":{"rendered":"https:\/\/www.jodoo.com\/blog\/?p=4885"},"modified":"2025-04-11T10:27:48","modified_gmt":"2025-04-11T02:27:48","slug":"%ea%b2%ac%ec%a0%81-%ec%83%9d%ec%84%b1%ec%9d%84-%ec%9c%84%ed%95%9c-ai","status":"publish","type":"post","link":"https:\/\/www.jodoo.com\/blog\/ko-kr\/ai-for-quotation-generation","title":{"rendered":"\uacac\uc801 \uc0dd\uc131\uc744 \uc704\ud55c AI \ud65c\uc6a9: Google Apps Script \ubc0f ChatGPT \ud504\ub86c\ud504\ud2b8\ub97c \uc0ac\uc6a9\ud55c \uac00\uc774\ub4dc"},"content":{"rendered":"<div class=\"wp-block-stackable-text stk-block-text stk-block stk-57201eb stk-block-background\" data-block-id=\"57201eb\"><style>.stk-57201eb {background-color:var(--theme-palette-color-15, #CDDED9) !important;border-top-left-radius:8px !important;border-top-right-radius:8px !important;border-bottom-right-radius:8px !important;border-bottom-left-radius:8px !important;overflow:hidden !important;}.stk-57201eb:before{background-color:var(--theme-palette-color-15, #CDDED9) !important;}<\/style><p class=\"stk-block-text__text\"><strong>\ucd94\uc0c1\uc801\uc778:<\/strong> \ub514\uc9c0\ud138 \uc2dc\ub300\uc5d0 \uc790\ub3d9\ud654\ub294 \ud6a8\uc728\uc131\uacfc \uc0dd\uc0b0\uc131\uc744 \ub192\uc774\ub294 \ud575\uc2ec \uc694\uc18c\uc785\ub2c8\ub2e4. \uc624\ub298\uc740 \uc790\ub3d9\ud654\ub97c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/chat.openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\ucc57GPT<\/a>, \ub294 \uac1c\ubc1c\ub41c \uace0\uae09 \uc5b8\uc5b4 \ubaa8\ub378\uc785\ub2c8\ub2e4. <a href=\"https:\/\/openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\uc624\ud508\uc544\uc774<\/a>, Jodoo\ub294 \ube44\uc988\ub2c8\uc2a4 \ud504\ub85c\uc138\uc2a4\uc640 \uc6cc\ud06c\ud50c\ub85c\uc6b0\ub97c \uc790\ub3d9\ud654\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uacac\uc801\uc11c \uc0dd\uc131 \uacfc\uc815\uc744 \uc608\uc2dc\ub85c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9 \ubd80\ubd84\uc5d0\uc11c\ub294 Jodoo\uac00 \ube44\uc988\ub2c8\uc2a4 \ubb38\uc11c \uc0dd\uc131\uc5d0\ub3c4 \uc720\uc6a9\ud55c \ub3c4\uad6c\uc778 \uc774\uc720\ub97c \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\ub9ce\uc740 \uae30\uc5c5\ub4e4\uc774 \ub370\uc774\ud130\ub97c \uad6c\uae00 \uc2dc\ud2b8\uc5d0 \uc800\uc7a5\ud558\uace0 \ubb38\uc11c\ub97c \uc791\uc131\ud560 \ub54c \uad6c\uae00 \ubb38\uc11c \uc791\uc131\uc744 \uc120\ud638\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub7ec\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc218\ub3d9\uc73c\ub85c \ud310\ub9e4 \uacac\uc801\uc11c \ud15c\ud50c\ub9bf\uc744 \ub9cc\ub4dc\ub294 \uac83\uc740 \ud2b9\ud788 \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \ub54c \uc2dc\uac04\uc774 \ub9ce\uc774 \uc18c\uc694\ub418\uace0 \uc624\ub958 \ubc1c\uc0dd \uac00\ub2a5\uc131\uc774 \ub192\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc5ec\uae30\uac00 \ubc14\ub85c \uadf8\uacf3\uc785\ub2c8\ub2e4&nbsp;<a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\uad6c\uae00 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8<\/a>&nbsp;\ud6a8\uc728\uc131\uc744 \ub192\uc774\uae30 \uc704\ud574 \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"what-is-google-apps-script\"><\/span>Google Apps Script\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Google Apps Script\ub294&nbsp;<a href=\"https:\/\/www.jodoo.com\/blog\/what-is-rapid-application-development\" target=\"_blank\" rel=\"noreferrer noopener\">\uc2e0\uc18d \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c<\/a>&nbsp;\uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uad6c\ucd95\ud558\uace0 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud560 \uc218 \uc788\ub294 \ud50c\ub7ab\ud3fc\uc785\ub2c8\ub2e4. \uc8fc\uc694 \uae30\ub2a5\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Google Workspace\uc640\uc758 \ud1b5\ud569<\/strong>Google Workspace\uc640 \uc5f0\ub3d9\ub418\ub294 \ube44\uc988\ub2c8\uc2a4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ud074\ub77c\uc6b0\ub4dc \uae30\ubc18 \uc790\ubc14\uc2a4\ud06c\ub9bd\ud2b8 \ud50c\ub7ab\ud3fc<\/strong>\uc774\ub294 Google \uc81c\ud488\uacfc \ud1b5\ud569\ud558\uace0 Google \uc81c\ud488 \uc804\ubc18\uc5d0 \uac78\uccd0 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc8fc\ub294 \ud074\ub77c\uc6b0\ub4dc \uae30\ubc18 JavaScript \ud50c\ub7ab\ud3fc\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc790\ub3d9\ud654<\/strong>Google \uc81c\ud488 \uc804\ubc18\uc5d0\uc11c \uc791\uc5c5\uc744 \ud504\ub85c\uadf8\ub798\ubc0d \ubc29\uc2dd\uc73c\ub85c \uc218\ud589\ud558\ub294 \ucf54\ub4dc\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc790\ub3d9\ud654\ub294 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \uba54\ub274, \ubc84\ud2bc, \uc0ac\uc6a9\uc790 \uc791\uc5c5 \ub610\ub294 \uc2dc\uac04 \uae30\ubc18 \uc77c\uc815\uc5d0 \ub530\ub77c \uc2e4\ud589\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218<\/strong>Google Sheets \ud568\uc218\ub97c Apps Script\ub85c \uc791\uc131\ud558\uace0 \ub0b4\uc7a5 \ud568\uc218\ucc98\ub7fc \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0\uc11c \ud638\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ucd94\uac00 \uae30\ub2a5<\/strong>Google Workspace \ub0b4\uc5d0\uc11c \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud558\uac70\ub098 \ud0c0\uc0ac \uc11c\ube44\uc2a4\uc5d0 \uc5f0\uacb0\ud558\ub294 \uc571\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ucc44\ud305 \uc571<\/strong>: \uad6c\uae00 \ucc57 \uc0ac\uc6a9\uc790\uac00 \ub9c8\uce58 \uc0ac\ub78c\uacfc \ub300\ud654\ud558\ub4ef\uc774 \uc11c\ube44\uc2a4\uc640 \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\ub294 \ub300\ud654\ud615 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how-to-automate-the-workflow-of-creating-a-sales-quotation-from-google-sheets\"><\/span>\uad6c\uae00 \uc2dc\ud2b8\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc601\uc5c5 \uacac\uc801\uc11c\ub97c \uc791\uc131\ud558\ub294 \uc6cc\ud06c\ud50c\ub85c\ub97c \uc790\ub3d9\ud654\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc77c\uae4c\uc694?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-1-preparing-the-data\"><\/span>1\ub2e8\uacc4: \ub370\uc774\ud130 \uc900\ube44<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uba3c\uc800 \ub370\uc774\ud130\ub97c \uc900\ube44\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774 \uc608\uc2dc\uc5d0\uc11c\ub294 \uc218\uacf5\uc608\ud488\uc744 \ud310\ub9e4\ud558\ub294 \uc18c\uaddc\ubaa8 \uc0ac\uc5c5\uccb4\ub77c\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc740 \uc5f4\uc774 \uc788\ub294 Google Sheets\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ud68c\uc0ac\uba85, \ud68c\uc0ac ID, \ub2f4\ub2f9\uc790, \ub2f4\ub2f9\uc790 \uc774\uba54\uc77c, \ud488\ubaa9, \uac00\uaca9, \uc218\ub7c9, \ucd1d \uac00\uaca9.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\uc74c\uc740 \uc800\ud76c \ub370\uc774\ud130\uc758 \uc608\uc2dc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-table custom-table\"><table><thead><tr><th>\ud68c\uc0ac\uba85<\/th><th>\ud68c\uc0ac ID<\/th><th>\ub2f4\ub2f9\uc790<\/th><th>\uc5f0\ub77d\ucc98 \uc774\uba54\uc77c<\/th><th>\ubaa9<\/th><th>\uac00\uaca9<\/th><th>\uc218\ub7c9<\/th><th>\ucd1d \uac00\uaca9<\/th><\/tr><\/thead><tbody><tr><td>\ud06c\ub798\ud504\ud2b8 \ucef4\ud37c\ub2c8.<\/td><td>123456<\/td><td>\uc874 \ub3c4<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>\uc591\ucd08<\/td><td>2<\/td><td>50<\/td><td>100<\/td><\/tr><tr><td>\ud06c\ub798\ud504\ud2b8 \ucef4\ud37c\ub2c8.<\/td><td>123456<\/td><td>\uc874 \ub3c4<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>\ube44\ub204<\/td><td>1<\/td><td>100<\/td><td>100<\/td><\/tr><tr><td>\ud06c\ub798\ud504\ud2b8 \ucef4\ud37c\ub2c8.<\/td><td>123456<\/td><td>\uc874 \ub3c4<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>\ubc30\uc2a4\ubc24<\/td><td>3<\/td><td>75<\/td><td>225<\/td><\/tr><tr><td>\uc544\ud06c\ubbf8 \uc8fc\uc2dd\ud68c\uc0ac.<\/td><td>78910<\/td><td>\uc5d0\ubc00\ub9ac \ub9c8\ud06c\uc2a4<\/td><td><a href=\"mailto:emily@acme.co\">emily@acme.co<\/a><\/td><td>\ube44\ub204<\/td><td>2<\/td><td>100<\/td><td>200<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-2-generating-the-apps-script-with-chatgpt\"><\/span>2\ub2e8\uacc4: ChatGPT\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc571\uc2a4\ud06c\ub9bd\ud2b8 \uc0dd\uc131<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\uc74c\uc73c\ub85c ChatGPT\ub97c \uc0ac\uc6a9\ud558\uc5ec Google Sheets\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc77d\uc5b4 Google \ubb38\uc11c\uc5d0 \uacac\uc801\uc11c\ub97c \uc0dd\uc131\ud558\ub294 Google Apps Script\ub97c \uc0dd\uc131\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub97c \uc704\ud574 ChatGPT\uc5d0 \uc791\uc5c5 \ubc0f \uc694\uad6c \uc0ac\ud56d\uc744 \uc124\uba85\ud558\ub294 \ud504\ub86c\ud504\ud2b8\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<blockquote class=\"wp-block-stackable-blockquote stk-block-blockquote stk-block stk-d071100 is-style-default\" data-v=\"2\" data-block-id=\"d071100\"><style>.stk-d071100-container{background-color:var(--theme-palette-color-6, #f2f5f7) !important;border-top-left-radius:4px !important;border-top-right-radius:4px !important;border-bottom-right-radius:4px !important;border-bottom-left-radius:4px !important;overflow:hidden !important;box-shadow:none !important;}.stk-d071100-container:before{background-color:var(--theme-palette-color-6, #f2f5f7) !important;}<\/style><div class=\"has-text-align-left stk-block-blockquote__content stk-container stk-d071100-container stk-hover-parent\"><div class=\"stk-block-content stk-inner-blocks\">\n<div class=\"wp-block-stackable-icon stk-block-icon stk-block stk-42c34b4\" data-block-id=\"42c34b4\"><\/div>\n\n\n\n<div class=\"wp-block-stackable-text stk-block-text stk-block stk-92b72b6\" data-block-id=\"92b72b6\"><style>.stk-92b72b6 .stk-block-text__text{font-style:italic !important;}<\/style><p class=\"stk-block-text__text\">Google Sheets\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc77d\uc5b4 Google Docs\uc5d0\uc11c \uacac\uc801\uc11c\ub97c \uc0dd\uc131\ud558\ub294 Google Apps Script\ub97c \ub9cc\ub4e4\uc5b4 \uc8fc\uc2dc\uaca0\uc2b5\ub2c8\uae4c? \uc2a4\ud06c\ub9bd\ud2b8\ub294 \ub2e4\uc74c \uae30\ub2a5\uc744 \uc218\ud589\ud574\uc57c \ud569\ub2c8\ub2e4.<br><br>\ub2e4\uc74c \uc5f4\uc774 \ud3ec\ud568\ub41c Google Sheets\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc624\uc138\uc694: \ud68c\uc0ac\uba85, \ud68c\uc0ac ID, \ub2f4\ub2f9\uc790, \ub2f4\ub2f9\uc790 \uc774\uba54\uc77c, \ud488\ubaa9, \uac00\uaca9, \uc218\ub7c9, \ucd1d \uac00\uaca9.<br><br>\uc2dc\ud2b8\uc5d0 \ub098\uc640 \uc788\ub294 \uac01 \ud68c\uc0ac\ubcc4\ub85c \uac1c\ubcc4 \uacac\uc801\uc11c\ub97c \uc791\uc131\ud558\uc2ed\uc2dc\uc624.<br><br>\uac01 \ubb38\uc11c\uc758 \uc2dc\uc791 \ubd80\ubd84\uc5d0 \ud68c\uc0ac \uc815\ubcf4(\ud68c\uc0ac\uba85, \ud68c\uc0ac ID, \ub2f4\ub2f9\uc790, \ub2f4\ub2f9\uc790 \uc774\uba54\uc77c)\ub97c \ud55c \ubc88\ub9cc \ud3ec\ud568\ud558\uc2ed\uc2dc\uc624.<br>\uc81c\ud488 \ub370\uc774\ud130(\ud488\ubaa9, \uac00\uaca9, \uc218\ub7c9, \ucd1d \uac00\uaca9)\ub97c \ubb38\uc11c \ub0b4\uc5d0 \ud45c \ud615\uc2dd\uc73c\ub85c \ud3ec\ud568\uc2dc\ud0a4\uc2ed\uc2dc\uc624.<br><br>\ud55c \ubc88\uc5d0 \ud55c \ud589\uc529 \ucc98\ub9ac\ud558\uace0, \ucc98\ub9ac\ub41c \uac01 \ud589\uc744 \uc0c8 \uc5f4\uc5d0 &#039;\uc644\ub8cc&#039;\ub85c \ud45c\uc2dc\ud569\ub2c8\ub2e4.<br><br>\uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc27d\uac8c \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d Google Sheets\uc758 \uc0ac\uc6a9\uc790 \uc9c0\uc815 \uba54\ub274\uc5d0\uc11c \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub3c4\ub85d \ub9cc\ub4dc\uc138\uc694.<br><br>\uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc5ec\ub7ec \ud589\uc774 \ub3d9\uc77c\ud55c \ud68c\uc0ac\uc5d0 \uc18d\ud558\ub294 \uacbd\uc6b0\ub97c \ucc98\ub9ac\ud558\uace0 \ud574\ub2f9 \ud68c\uc0ac\uc5d0 \ub300\ud55c \ub2e8\uc77c \uacac\uc801 \ubb38\uc11c\ub97c \uc0dd\uc131\ud558\ub294\uc9c0 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<br><br>\ub610\ud55c \uc0ac\uc6a9\uc790 \uc9c0\uc815 \uba54\ub274\ub97c \uc0ac\uc6a9\ud558\uc5ec Google Sheets\uc5d0\uc11c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc9c1\uc811 \uc2e4\ud589\ud560 \uc218 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/p><\/div>\n<\/div><\/div><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">ChatGPT\ub294 \uc6b0\ub9ac\uac00 \uc785\ub825\ud55c \ud504\ub86c\ud504\ud2b8\ub97c \uae30\ubc18\uc73c\ub85c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uc0d8\ud50c \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>function generateQuotation() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange = sheet.getDataRange(); var values = dataRange.getValues(); var numRows = values.length; var headers = values[0]; var doneColumn = headers.indexOf(&#039;Done&#039;); if (doneColumn === -1) { sheet.getRange(1, headers.length + 1).setValue(&#039;Done&#039;); \/\/ &#039;Done&#039; \uc5f4\uc774 \uc5c6\uc73c\uba74 \ucd94\uac00 doneColumn = headers.length; } for (var i = 1; i &lt; numRows; i++) { if (values[i][doneColumn] !== &#039;done&#039;) { \/\/ \ud589\uc774 &#039;done&#039;\uc73c\ub85c \ud45c\uc2dc\ub418\uc9c0 \uc54a\uc558\ub294\uc9c0 \ud655\uc778 var companyData = {}; var companyName = values[i][headers.indexOf(&#039;\ud68c\uc0ac\uba85&#039;)]; var companyID = values[i][headers.indexOf(&#039;\ud68c\uc0ac ID&#039;)]; var contactPerson = values[i][headers.indexOf(&#039;\ub2f4\ub2f9\uc790&#039;)]; var contactEmail = values[i][headers.indexOf(&#039;\uc5f0\ub77d\ucc98 \uc774\uba54\uc77c&#039;)]; var products = []; \/\/ \ud68c\uc0ac \ub370\uc774\ud130 \uac1d\uccb4 \uc0dd\uc131 companyData[&#039;\ud68c\uc0ac\uba85&#039;] = companyName; companyData[&#039;\ud68c\uc0ac ID&#039;] = companyID; companyData[&#039;\ub2f4\ub2f9\uc790&#039;] = contactPerson; companyData[&#039;\uc5f0\ub77d\ucc98 \uc774\uba54\uc77c&#039;] = contactEmail; \/\/ \ub3d9\uc77c\ud55c \ud68c\uc0ac \uc815\ubcf4\ub97c \uac00\uc9c4 \ud589\ub4e4\uc744 \ubc18\ubcf5 while (i &lt; numRows &amp;&amp; values[i][headers.indexOf(&#039;\ud68c\uc0ac\uba85&#039;)] === companyName) { var item = values[i][headers.indexOf(&#039;\ud488\ubaa9&#039;)]; var price = values[i][headers.indexOf(&#039;\uac00\uaca9&#039;)]; var quantity = values[i][headers.indexOf(&#039;\uc218\ub7c9&#039;)]; var totalPrice = values[i][headers.indexOf(&#039;\ucd1d \uac00\uaca9&#039;)]; products.push([item, price, quantity, totalPrice]); sheet.getRange(i + 1, doneColumn + 1).setValue(&#039;\uc644\ub8cc&#039;); \/\/ \ud589\uc744 &#039;\uc644\ub8cc&#039;\ub85c \ud45c\uc2dc i++; } \/\/ \uacac\uc801\uc11c\ub97c \uc704\ud55c \uc0c8 Google \ubb38\uc11c \uc0dd\uc131 var doc = DocumentApp.create(&#039;\uacac\uc801\uc11c: &#039; + companyName); var document = DocumentApp.openById(doc.getId()); var body = document.getBody(); \/\/ \ubb38\uc11c\uc5d0 \ud68c\uc0ac \ub370\uc774\ud130 \ucd94\uac00 body.appendParagraph(&#039;\ud68c\uc0ac\uba85: &#039; + companyName); body.appendParagraph(&#039;\ud68c\uc0ac ID: &#039; + companyID); body.appendParagraph(&#039;\ub2f4\ub2f9\uc790: &#039; + contactPerson); body.appendParagraph(&#039;\uc5f0\ub77d\ucc98 \uc774\uba54\uc77c: &#039; + contactEmail); \/\/ \uc81c\ud488 \ub370\uc774\ud130\ub97c \ud45c \ud615\uc2dd\uc73c\ub85c \ucd94\uac00 var table = []; table.push([&#039;\ud488\ubaa9&#039;, &#039;\uac00\uaca9&#039;, &#039;\uc218\ub7c9&#039;, &#039;\ucd1d \uac00\uaca9&#039;]); table = table.concat(products); body.appendTable(table); document.saveAndClose(); } } }\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-3-implementing-the-script\"><\/span>3\ub2e8\uacc4: \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"2000\" height=\"1274\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2023\/12\/image-5.png\" alt=\"\ud15c\ud50c\ub9bf pic2\" class=\"wp-image-4431\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2023\/12\/image-5.png 2000w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2023\/12\/image-5-300x191.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2023\/12\/image-5-1024x652.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2023\/12\/image-5-768x489.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2023\/12\/image-5-1536x978.png 1536w\" sizes=\"auto, (max-width: 2000px) 100vw, 2000px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc900\ube44\ud588\uc73c\uba74 \uc774\uc81c Google Sheets\uc5d0 \uc801\uc6a9\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. Google Sheets\uc758 \uc2a4\ud06c\ub9bd\ud2b8 \ud3b8\uc9d1\uae30(\ud655\uc7a5 \ud504\ub85c\uadf8\ub7a8 &gt; Apps Script)\uc5d0 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ubcf5\uc0ac\ud558\uace0 \uc2e4\ud589\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\ub824\uba74 \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub974\uc2ed\uc2dc\uc624.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \uc5f4\uace0 \uacac\uc801 \uc815\ubcf4\ub97c \uc785\ub825\ud558\uc138\uc694.<\/li>\n\n\n\n<li>&quot;\ud655\uc7a5 \ud504\ub85c\uadf8\ub7a8&quot; -&gt; &quot;\uc571\uc2a4\ud06c\ub9bd\ud2b8&quot;\ub97c \ud074\ub9ad\ud558\uc5ec \uc2a4\ud06c\ub9bd\ud2b8 \ud3b8\uc9d1\uae30\ub97c \uc5fd\ub2c8\ub2e4.&nbsp;<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"302\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-1024x302.png\" alt=\"\uad6c\uae00 \uc2dc\ud2b8\" class=\"wp-image-4886\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-1024x302.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-300x89.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-768x227.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-1536x453.png 1536w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation.png 1728w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. \uc0d8\ud50c \ucf54\ub4dc\ub97c \uc2a4\ud06c\ub9bd\ud2b8 \ud3b8\uc9d1\uae30\uc5d0 \ubd99\uc5ec\ub123\uc73c\uc138\uc694.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"641\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Apps-script-1024x641.png\" alt=\"\uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\" class=\"wp-image-4887\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Apps-script-1024x641.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Apps-script-300x188.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Apps-script-768x481.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Apps-script-1536x961.png 1536w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Apps-script-2048x1282.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4. Apps Script \ud3b8\uc9d1\uae30\uc5d0\uc11c \ub514\uc2a4\ud06c \uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud558\uc5ec \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. \uc2e4\ud589\ud558\uc138\uc694&nbsp;<strong>\uacac\uc801 \uc0dd\uc131<\/strong>&nbsp;\uc7ac\uc0dd \ubc84\ud2bc \u25b6\ufe0f\uc744 \ub20c\ub7ec &quot;\uc2e4\ud589&quot;\uc744 \ud074\ub9ad\ud558\uba74 \uae30\ub2a5\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6. \uc571 \uc2a4\ud06c\ub9bd\ud2b8\uac00 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \uc2b9\uc778 \uc808\ucc28\ub97c \uc644\ub8cc\ud558\uc2ed\uc2dc\uc624.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"641\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Authorization-1024x641.png\" alt=\"\uc2a4\ud06c\ub9bd\ud2b8 \uad6c\ud604 \uc644\ub8cc\" class=\"wp-image-4888\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Authorization-1024x641.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Authorization-300x188.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Authorization-768x481.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI-Quotation-Authorization.png 1176w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-4-reviewing-the-results\"><\/span>4\ub2e8\uacc4: \uacb0\uacfc \uac80\ud1a0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ub9c8\uc9c0\ub9c9\uc73c\ub85c \uacb0\uacfc\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc131\uacf5\uc801\uc73c\ub85c \uc2e4\ud589\ub418\uba74 Google Sheets \uba54\ub274 \ubaa8\uc74c\uc5d0 &quot;\uc0ac\uc6a9\uc790 \uc9c0\uc815 \uba54\ub274&quot;\uac00 \ucd94\uac00\ub429\ub2c8\ub2e4. &quot;\uc0ac\uc6a9\uc790 \uc9c0\uc815 \uba54\ub274&quot;\ub97c \ud074\ub9ad\ud558\uba74 &quot;\uacac\uc801 \uc0dd\uc131&quot; \uc635\uc158\uc744 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&quot;\uacac\uc801 \uc0dd\uc131&quot;\uc744 \ud074\ub9ad\ud558\uc5ec \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uba74 \uc9c0\uc815\ub41c \uad6c\uc870\ub85c \uac01 \ud68c\uc0ac\ubcc4\ub85c \uac1c\ubcc4 \uacac\uc801\uc11c\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"302\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Custom20menu-1024x302.png\" alt=\"\uacac\uc801\uc11c\uac00 \ud3ec\ud568\ub41c \uad6c\uae00 \ubb38\uc11c\" class=\"wp-image-4889\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Custom20menu-1024x302.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Custom20menu-300x88.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Custom20menu-768x226.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Custom20menu-1536x453.png 1536w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Custom20menu.png 1940w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\ubaa8\ub4e0 \uc124\uc815\uc774 \uc62c\ubc14\ub974\uac8c \uc644\ub8cc\ub418\uc5c8\ub2e4\uba74, \uc774\uc81c Google Sheets\uc758 \ub370\uc774\ud130\ub97c \uae30\ubc18\uc73c\ub85c \uc791\uc131\ub41c \uacac\uc801\uc11c\uac00 \ud3ec\ud568\ub41c Google \ubb38\uc11c\uac00 \uc0dd\uc131\ub418\uc5c8\uc744 \uac83\uc785\ub2c8\ub2e4. Google Sheets\uc5d0\uc11c \ucc98\ub9ac\uac00 \uc644\ub8cc\ub41c \uac01 \ud589\uc740 \uc0c8 \uc5f4\uc5d0 &#039;\uc644\ub8cc&#039;\ub85c \ud45c\uc2dc\ub418\uc5b4 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Google20Doc-1024x525.png\" alt=\"\uacac\uc801\uc11c\" class=\"wp-image-4890\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Google20Doc-1024x525.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Google20Doc-300x154.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Google20Doc-768x394.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Google20Doc-1536x788.png 1536w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/AI20Quotation20-20Google20Doc-2048x1050.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"a-more-efficient-way-creating-quotation-with-jodoos-custom-print-template\"><\/span>\ub354\uc6b1 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95: Jodoo\uc758 \ub9de\ucda4 \uc778\uc1c4 \ud15c\ud50c\ub9bf\uc744 \uc0ac\uc6a9\ud558\uc5ec \uacac\uc801\uc11c \uc791\uc131\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ud310\ub9e4 \uacac\uc801\uc11c \uc791\uc131\uc740 \ubaa8\ub4e0 \ube44\uc988\ub2c8\uc2a4 \ud504\ub85c\uc138\uc2a4\uc5d0\uc11c \ub9e4\uc6b0 \uc911\uc694\ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0\u00a0<a href=\"https:\/\/www.jodoo.com\/https:\/\/www.jodoo.com\/?utm_source=blog&amp;utm_medium=internal_link&amp;utm_campaign=digital-innovation&amp;utm_content=ai-for-quotation-generation\" target=\"_blank\" rel=\"noreferrer noopener\">Jodoo<\/a>\u00a0\uacac\uc801\uc11c \ub610\ub294 \uae30\ud0c0 BPM \ubb38\uc11c\ub97c \uc791\uc131\ud558\ub294 \ub370 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uc5ec \uc9c0\uc6d0\ud574 \uc654\uc2b5\ub2c8\ub2e4.\u00a0<a href=\"https:\/\/help.jodoo.com\/en\/articles\/10005821-print-templates\" target=\"_blank\" rel=\"noreferrer noopener\">\ub9de\ucda4\ud615 \uc778\uc1c4 \ud15c\ud50c\ub9bf<\/a>\u00a0Jodoo\ub97c \uc0ac\uc6a9\ud558\uba74 \uc774 \ud504\ub85c\uc138\uc2a4\uac00 \uac04\uc18c\ud654\ub418\uace0 \ub354\uc6b1 \ud6a8\uc728\uc801\uc73c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how-to-create-a-custom-print-template-in-jodoo\"><\/span>Jodoo\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uc9c0\uc815 \uc778\uc1c4 \ud15c\ud50c\ub9bf\uc744 \ub9cc\ub4dc\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Jodoo\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud310\ub9e4 \uacac\uc801\uc11c\ub97c \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud55c \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\uacac\uc801 \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub294 \uc591\uc2dd\uc744 \uc120\ud0dd\ud558\uace0 \ud074\ub9ad\ud558\uc138\uc694.\u00a0<a href=\"https:\/\/help.jodoo.com\/doc\/17191#editingform\" target=\"_blank\" rel=\"noreferrer noopener\">\ud3b8\uc9d1\ud558\ub2e4<\/a>. \ub9cc\uc57d \uc5c6\uc73c\uc2dc\ub2e4\uba74, \uc800\ud76c \uc81c\ud488\uc744 \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.\u00a0<a href=\"https:\/\/www.jodoo.com\/template\/order-and-inventory-management-65b0bdde4c02dd632333a55a\" target=\"_blank\" rel=\"noreferrer noopener\">\uc8fc\ubb38 \ubc0f \uc7ac\uace0 \uad00\ub9ac<\/a>\u00a0\uc8fc\ud615.<\/li>\n\n\n\n<li>\ud655\uc7a5 \ud504\ub85c\uadf8\ub7a8 &gt; \uc778\uc1c4 \ud15c\ud50c\ub9bf\uc73c\ub85c \uc774\ub3d9\ud558\uc5ec \uc0c8 \uc778\uc1c4 \ud15c\ud50c\ub9bf\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.&nbsp;<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"645\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/New20Print20Template-1024x645.png\" alt=\"\uc778\uc1c4\uc6a9 \ud15c\ud50c\ub9bf\" class=\"wp-image-4891\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/New20Print20Template-1024x645.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/New20Print20Template-300x189.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/New20Print20Template-768x484.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/New20Print20Template-1536x967.png 1536w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/New20Print20Template-2048x1290.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. \ud15c\ud50c\ub9bf \ub514\uc790\uc778 \ud398\uc774\uc9c0\uc5d0\uc11c \ud15c\ud50c\ub9bf \uc774\ub984\uc744 &quot;\uc601\uc5c5 \uacac\uc801\uc11c \ud15c\ud50c\ub9bf&quot;\uacfc \uac19\uc774 \uc6d0\ud558\ub294 \uc774\ub984\uc73c\ub85c \ubcc0\uacbd\ud558\uc138\uc694.\u201c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. <a href=\"https:\/\/help.jodoo.com\/doc\/9140#designingthetemplate\" target=\"_blank\" rel=\"noreferrer noopener\">\ud544\uc218 \ud544\ub4dc\ub97c \ucd94\uac00\ud558\uc138\uc694<\/a>, \uc81c\ud488\uba85, \uc218\ub7c9, \uac00\uaca9, \ud569\uacc4 \ub4f1\uc758 \uc815\ubcf4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ud544\ub4dc\ub294 \uc591\uc2dd\uc5d0 \uc785\ub825\ud55c \ub370\uc774\ud130\ub85c \uc790\ub3d9\uc73c\ub85c \ucc44\uc6cc\uc9d1\ub2c8\ub2e4.&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"695\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/dragging20field20in20template20design20tool-1024x695.gif\" alt=\"\ud544\ub4dc\ub97c \ub4dc\ub798\uadf8 \uc564 \ub4dc\ub86d\ud558\uc138\uc694\" class=\"wp-image-4892\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/dragging20field20in20template20design20tool-1024x695.gif 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/dragging20field20in20template20design20tool-300x204.gif 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/dragging20field20in20template20design20tool-768x522.gif 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">5. \ud15c\ud50c\ub9bf\uc774 \uc900\ube44\ub418\uba74 \ub370\uc774\ud130\ub97c \uc120\ud0dd\ud558\uace0 \uc778\uc1c4 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uae30\ub9cc \ud558\uba74 \ud310\ub9e4 \uacac\uc801\uc11c\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/15008#permissionsetsandmanagedata\" target=\"_blank\" rel=\"noreferrer noopener\">PC<\/a>&nbsp;\ub610\ub294&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/12010\" target=\"_blank\" rel=\"noreferrer noopener\">\uc774\ub3d9\ud558\ub294<\/a>.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large has-custom-border is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"508\" src=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/Printing20Document20on20Mobile-1024x508.png\" alt=\"\uc778\uc1c4\" class=\"wp-image-4893\" style=\"border-radius:8px;border-top-color:var(--theme-palette-color-9, #2A9073);border-top-width:24px;border-right-color:var(--theme-palette-color-9, #2A9073);border-right-width:24px;border-bottom-style:none;border-bottom-width:0px;border-left-color:var(--theme-palette-color-9, #2A9073);border-left-width:24px\" srcset=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/Printing20Document20on20Mobile-1024x508.png 1024w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/Printing20Document20on20Mobile-300x149.png 300w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/Printing20Document20on20Mobile-768x381.png 768w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/Printing20Document20on20Mobile-1536x761.png 1536w, https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/Printing20Document20on20Mobile-2048x1015.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"what-are-the-benefits-of-using-jodoo-to-create-business-documents-like-quotations-and-invoices\"><\/span>Jodoo\ub97c \uc0ac\uc6a9\ud558\uc5ec \uacac\uc801\uc11c \ubc0f \uc1a1\uc7a5\uacfc \uac19\uc740 \ube44\uc988\ub2c8\uc2a4 \ubb38\uc11c\ub97c \uc791\uc131\ud560 \ub54c\uc758 \uc774\uc810\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c \uc774 \uacfc\uc815\uc744 \uad6c\uae00 \uc2dc\ud2b8\uc640 \uad6c\uae00 \ubb38\uc11c\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc640 \ube44\uad50\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \ub3c4\uad6c\ub4e4\uc740 \ub2e4\uc7ac\ub2e4\ub2a5\ud558\uace0 \ub110\ub9ac \uc0ac\uc6a9\ub418\uc9c0\ub9cc, Jodoo\uac00 \uc81c\uacf5\ud558\ub294 \uc790\ub3d9\ud654 \ubc0f \ub9de\ucda4 \uc124\uc815 \uae30\ub2a5\uc740 \ubd80\uc871\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Google Apps Script\ub294 Google Workspace \ub0b4\uc5d0\uc11c \uc790\ub3d9\ud654\ub97c \uc9c0\uc6d0\ud558\uc5ec Google Sheets\ub97c \ub354\uc6b1 \uac15\ub825\ud55c \ub3c4\uad6c\ub85c \ub9cc\ub4e4\uc5b4 \uc90d\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub7ec\ud55c \uc790\ub3d9\ud654 \uae30\ub2a5\uc5d0\ub3c4 \ubd88\uad6c\ud558\uace0 Jodoo\uac00 \uc5ec\uc804\ud788 \ub6f0\uc5b4\ub09c \ubd80\ubd84\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\uc0ac\uc6a9 \ud3b8\uc758\uc131<\/strong>\uad6c\uae00 \uc571\uc2a4 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \uac15\ub825\ud558\uc9c0\ub9cc \uc124\uc815 \ubc0f \uc720\uc9c0 \uad00\ub9ac\uc5d0 \ucf54\ub529 \uc9c0\uc2dd\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc774\ub294 \uae30\uc220\uc801\uc778 \uc9c0\uc2dd\uc774 \ubd80\uc871\ud55c \uc0ac\uc6a9\uc790\uc5d0\uac8c\ub294 \uc7a5\ubcbd\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\uba74, \uc870\ub450(Jodoo)\uc758 \uc778\ud130\ud398\uc774\uc2a4\ub294 \uc9c1\uad00\uc801\uc774\uace0 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc774\uc5b4\uc11c \ub204\uad6c\ub098 \ub2e8 \ud55c \uc904\uc758 \ucf54\ub4dc\ub3c4 \uc791\uc131\ud558\uc9c0 \uc54a\uace0 \uc601\uc5c5 \uacac\uc801\uc11c\ub97c \uc0dd\uc131\ud558\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc644\uc131<\/strong>Jodoo\ub294 \ube44\uc988\ub2c8\uc2a4 \ud504\ub85c\uc138\uc2a4\uc758 \ub2e4\ub978 \ubd80\ubd84\uacfc \uc6d0\ud65c\ud558\uac8c \uc5f0\ub3d9\ub418\ub3c4\ub85d \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc591\uc2dd, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \uae30\ud0c0 \uc18c\uc2a4\uc758 \ub370\uc774\ud130\ub97c \uc27d\uac8c \uc5f0\uacb0\ud558\uace0 \uc2e4\uc2dc\uac04\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Google Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc720\uc0ac\ud55c \ud1b5\ud569 \uae30\ub2a5\uc744 \uad6c\ud604\ud560 \uc218\ub3c4 \uc788\uc9c0\ub9cc, \ub354 \ub9ce\uc740 \ub178\ub825\uacfc \uae30\uc220 \uc804\ubb38 \uc9c0\uc2dd\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ub9de\ucda4 \uc124\uc815<\/strong>Jodoo\uc758 \ub9de\ucda4 \uc778\uc1c4 \ud15c\ud50c\ub9bf\uc740 \ub192\uc740 \uc218\uc900\uc758 \ub9de\ucda4 \uc124\uc815 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub808\uc774\uc544\uc6c3\uc744 \uc27d\uac8c \uc870\uc815\ud558\uace0, \uc774\ubbf8\uc9c0\ub97c \ucd94\uac00\ud558\uace0, \uc0ac\uc6a9\uc790 \uc9c0\uc815 \ud544\ub4dc\ub97c \ud3ec\ud568\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Google Apps Script\ub97c \uc0ac\uc6a9\ud574\uc11c\ub3c4 \ub9de\ucda4 \uc124\uc815\uc774 \uac00\ub2a5\ud558\uc9c0\ub9cc, Jodoo\uc640 \uac19\uc740 \uc218\uc900\uc758 \uc138\ubd80\uc801\uc778 \uc124\uc815\uc744 \uad6c\ud604\ud558\ub824\uba74 \ub354 \ubcf5\uc7a1\ud558\uace0 \uc2dc\uac04\uc774 \ub9ce\uc774 \uc18c\uc694\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ud655\uc7a5\uc131<\/strong>\ube44\uc988\ub2c8\uc2a4 \uaddc\ubaa8\uac00 \ucee4\uc9d0\uc5d0 \ub530\ub77c \ud504\ub85c\uc138\uc2a4\uc758 \ubcf5\uc7a1\uc131\ub3c4 \uc99d\uac00\ud569\ub2c8\ub2e4. Jodoo\ub294 \uc774\ub7ec\ud55c \uc131\uc7a5\uc744 \uc9c0\uc6d0\ud558\ub3c4\ub85d \uc124\uacc4\ub418\uc5b4 \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc190\uc27d\uac8c \uad00\ub9ac\ud558\uace0 \uc790\ub3d9\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Google Apps Script\ub3c4 \ud655\uc7a5\uc774 \uac00\ub2a5\ud558\uc9c0\ub9cc, \ubcf5\uc7a1\uc131\uc774 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc720\uc9c0 \uad00\ub9ac \ubc0f \ubb38\uc81c \ud574\uacb0\uc5d0 \ub354 \ub9ce\uc740 \uc2dc\uac04\uc774 \uc18c\uc694\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\uacb0\ub860\uc801\uc73c\ub85c, Google Apps Script\ub294 Google Sheets\uc758 \uae30\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0 ChatGPT\ub294 Apps Script \uc791\uc131\uc5d0 \ub3c4\uc6c0\uc744 \uc904 \uc218 \uc788\uc9c0\ub9cc, Jodoo\ub294 \uc5ec\uc804\ud788 \uc601\uc5c5 \uacac\uc801\uc11c \ubc0f \uae30\ud0c0 \ube44\uc988\ub2c8\uc2a4 \ubb38\uc11c\ub97c \uc0dd\uc131\ud558\ub294 \ub370 \uc788\uc5b4 \ub354\uc6b1 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc774\uace0 \ud1b5\ud569\uc801\uc774\uba70 \ub9de\ucda4 \uc124\uc815 \ubc0f \ud655\uc7a5\uc774 \uac00\ub2a5\ud55c \uc194\ub8e8\uc158\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>\uacb0\ub860<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uacb0\ub860\uc801\uc73c\ub85c, \uc778\uacf5\uc9c0\ub2a5\uc758 \ub4f1\uc7a5\uacfc \ube44\uc988\ub2c8\uc2a4 \ud504\ub85c\uc138\uc2a4\uc640\uc758 \ud1b5\ud569\uc740 \uc6b0\ub9ac\uc758 \uc5c5\ubb34 \ubc29\uc2dd\uc744 \ud601\uc2e0\uc801\uc73c\ub85c \ubcc0\ud654\uc2dc\ucf30\uc2b5\ub2c8\ub2e4. ChatGPT\uc640 \uac19\uc740 \uace0\uae09 \uc5b8\uc5b4 \ubaa8\ub378\uc744 Google Apps Script\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud558\uba74 Google Sheets \ub370\uc774\ud130\ub97c \uae30\ubc18\uc73c\ub85c \uacac\uc801\uc11c\ub97c \uc0dd\uc131\ud558\ub294 \ub4f1\uc758 \uc791\uc5c5\uc744 \uc790\ub3d9\ud654\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc720\ub9dd\ud55c \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc8fc\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \ub2e4\uc74c\uacfc \uac19\uc740 \ud50c\ub7ab\ud3fc <a href=\"https:\/\/www.jodoo.com\/?utm_source=blog&amp;utm_medium=internal_link&amp;utm_campaign=digital-innovation&amp;utm_content=ai-for-quotation-generation\">Jodoo<\/a> \uc6b0\ub9ac\ub294 \uc5ec\uae30\uc11c \ud55c \ub2e8\uacc4 \ub354 \ub098\uc544\uac00 \ub354\uc6b1 \uc0ac\uc6a9\uc790 \uce5c\ud654\uc801\uc774\uace0, \ud1b5\ud569\uc801\uc774\uba70, \ub9de\ucda4 \uc124\uc815\uc774 \uac00\ub2a5\ud558\uace0, \ud655\uc7a5 \uac00\ub2a5\ud55c \uc194\ub8e8\uc158\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ube44\uc988\ub2c8\uc2a4 \ud504\ub85c\uc138\uc2a4 \uc790\ub3d9\ud654\uc758 \ubbf8\ub798\uac00 \ubc14\ub85c \uc5ec\uae30\uc5d0 \uc788\uc73c\uba70, \uc778\uacf5\uc9c0\ub2a5(AI)\uc774 \uadf8 \ubbf8\ub798\ub97c \ub9cc\ub4e4\uc5b4\uac00\ub294 \ub370 \ud575\uc2ec\uc801\uc778 \uc5ed\ud560\uc744 \ud560 \uac83\uc774 \ubd84\uba85\ud569\ub2c8\ub2e4. AI\uc758 \uc7a0\uc7ac\ub825\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \ud0d0\uad6c\ud558\uace0 \ud65c\uc6a9\ud568\uc5d0 \ub530\ub77c, \uc6b0\ub9ac\ub294 \ub354\uc6b1 \ud6a8\uc728\uc801\uc774\uace0, \uac04\uc18c\ud654\ub418\uace0, \ud601\uc2e0\uc801\uc778 \ube44\uc988\ub2c8\uc2a4 \ubc29\uc2dd\uc744 \uae30\ub300\ud560 \uc218 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>ChatGPT\uc640 Google Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uacac\uc801\uc11c \uc0dd\uc131\uc744 \uc790\ub3d9\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc138\uc694. \ud6a8\uc728\uc801\uc778 \uc6cc\ud06c\ud50c\ub85c\ub97c \uc0b4\ud3b4\ubcf4\uace0 Jodoo\uc758 \ub9de\ucda4\ud615 \uc778\uc1c4 \ud15c\ud50c\ub9bf\uacfc \ube44\uad50\ud574 \ubcf4\uc138\uc694.<\/p>","protected":false},"author":1,"featured_media":4707,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,19],"tags":[],"class_list":["post-4885","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-digital-innovation","category-features"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt - Jodoo Blog<\/title>\n<meta name=\"description\" content=\"Learn how to automate quotation generation with ChatGPT and Google Apps Script. Discover efficient workflows and compare with Jodoo&#039;s custom print templates.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.jodoo.com\/blog\/ko-kr\/\uacac\uc801-\uc0dd\uc131\uc744-\uc704\ud55c-ai\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt - Jodoo Blog\" \/>\n<meta property=\"og:description\" content=\"Learn how to automate quotation generation with ChatGPT and Google Apps Script. Discover efficient workflows and compare with Jodoo&#039;s custom print templates.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jodoo.com\/blog\/ko-kr\/\uacac\uc801-\uc0dd\uc131\uc744-\uc704\ud55c-ai\/\" \/>\n<meta property=\"og:site_name\" content=\"Jodoo Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/company.jodoo\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-23T12:20:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-11T02:27:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/\u4f01\u4e1a\u7ba1\u7406.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"464\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jodoo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JodooHQ\" \/>\n<meta name=\"twitter:site\" content=\"@JodooHQ\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jodoo\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\"},\"author\":{\"name\":\"Jodoo\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#\\\/schema\\\/person\\\/b958cef486b1eb00d0f82e6f0a294481\"},\"headline\":\"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt\",\"datePublished\":\"2024-02-23T12:20:00+00:00\",\"dateModified\":\"2025-04-11T02:27:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\"},\"wordCount\":1481,\"image\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/\u4f01\u4e1a\u7ba1\u7406.png\",\"articleSection\":[\"Digital Innovation\",\"Features\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\",\"url\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\",\"name\":\"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt - Jodoo Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/\u4f01\u4e1a\u7ba1\u7406.png\",\"datePublished\":\"2024-02-23T12:20:00+00:00\",\"dateModified\":\"2025-04-11T02:27:48+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#\\\/schema\\\/person\\\/b958cef486b1eb00d0f82e6f0a294481\"},\"description\":\"Learn how to automate quotation generation with ChatGPT and Google Apps Script. Discover efficient workflows and compare with Jodoo's custom print templates.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation#primaryimage\",\"url\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/\u4f01\u4e1a\u7ba1\u7406.png\",\"contentUrl\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/\u4f01\u4e1a\u7ba1\u7406.png\",\"width\":768,\"height\":464,\"caption\":\"blog cover\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\\\/\\\/www.jodoo.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/\",\"name\":\"Jodoo Blog\",\"description\":\"Get the latest information about no-code development, updates, events, and other news about Jodoo.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#\\\/schema\\\/person\\\/b958cef486b1eb00d0f82e6f0a294481\",\"name\":\"Jodoo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/250e0d43b77e764b8fd961bf41dc0e46963912235f6724430a4fdb771e857168?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/250e0d43b77e764b8fd961bf41dc0e46963912235f6724430a4fdb771e857168?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/250e0d43b77e764b8fd961bf41dc0e46963912235f6724430a4fdb771e857168?s=96&d=mm&r=g\",\"caption\":\"Jodoo\"},\"sameAs\":[\"http:\\\/\\\/wp.sre.jodoodevelop.com\"],\"url\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ko-kr\\\/author\\\/wp-admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\uacac\uc801 \uc0dd\uc131\uc744 \uc704\ud55c AI \ud65c\uc6a9: Google Apps Script \ubc0f ChatGPT \ud504\ub86c\ud504\ud2b8\ub97c \uc0ac\uc6a9\ud55c \uac00\uc774\ub4dc - Jodoo \ube14\ub85c\uadf8","description":"ChatGPT\uc640 Google Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uacac\uc801\uc11c \uc0dd\uc131\uc744 \uc790\ub3d9\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc138\uc694. \ud6a8\uc728\uc801\uc778 \uc6cc\ud06c\ud50c\ub85c\ub97c \uc0b4\ud3b4\ubcf4\uace0 Jodoo\uc758 \ub9de\ucda4\ud615 \uc778\uc1c4 \ud15c\ud50c\ub9bf\uacfc \ube44\uad50\ud574 \ubcf4\uc138\uc694.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.jodoo.com\/blog\/ko-kr\/\uacac\uc801-\uc0dd\uc131\uc744-\uc704\ud55c-ai\/","og_locale":"ko_KR","og_type":"article","og_title":"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt - Jodoo Blog","og_description":"Learn how to automate quotation generation with ChatGPT and Google Apps Script. Discover efficient workflows and compare with Jodoo's custom print templates.","og_url":"https:\/\/www.jodoo.com\/blog\/ko-kr\/\uacac\uc801-\uc0dd\uc131\uc744-\uc704\ud55c-ai\/","og_site_name":"Jodoo Blog","article_publisher":"https:\/\/www.facebook.com\/company.jodoo","article_published_time":"2024-02-23T12:20:00+00:00","article_modified_time":"2025-04-11T02:27:48+00:00","og_image":[{"width":768,"height":464,"url":"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/\u4f01\u4e1a\u7ba1\u7406.png","type":"image\/png"}],"author":"Jodoo","twitter_card":"summary_large_image","twitter_creator":"@JodooHQ","twitter_site":"@JodooHQ","twitter_misc":{"\uae00\uc4f4\uc774":"Jodoo","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"8\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#article","isPartOf":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation"},"author":{"name":"Jodoo","@id":"https:\/\/www.jodoo.com\/blog\/#\/schema\/person\/b958cef486b1eb00d0f82e6f0a294481"},"headline":"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt","datePublished":"2024-02-23T12:20:00+00:00","dateModified":"2025-04-11T02:27:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation"},"wordCount":1481,"image":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#primaryimage"},"thumbnailUrl":"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/\u4f01\u4e1a\u7ba1\u7406.png","articleSection":["Digital Innovation","Features"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation","url":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation","name":"\uacac\uc801 \uc0dd\uc131\uc744 \uc704\ud55c AI \ud65c\uc6a9: Google Apps Script \ubc0f ChatGPT \ud504\ub86c\ud504\ud2b8\ub97c \uc0ac\uc6a9\ud55c \uac00\uc774\ub4dc - Jodoo \ube14\ub85c\uadf8","isPartOf":{"@id":"https:\/\/www.jodoo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#primaryimage"},"image":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#primaryimage"},"thumbnailUrl":"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/\u4f01\u4e1a\u7ba1\u7406.png","datePublished":"2024-02-23T12:20:00+00:00","dateModified":"2025-04-11T02:27:48+00:00","author":{"@id":"https:\/\/www.jodoo.com\/blog\/#\/schema\/person\/b958cef486b1eb00d0f82e6f0a294481"},"description":"ChatGPT\uc640 Google Apps Script\ub97c \uc0ac\uc6a9\ud558\uc5ec \uacac\uc801\uc11c \uc0dd\uc131\uc744 \uc790\ub3d9\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uc138\uc694. \ud6a8\uc728\uc801\uc778 \uc6cc\ud06c\ud50c\ub85c\ub97c \uc0b4\ud3b4\ubcf4\uace0 Jodoo\uc758 \ub9de\ucda4\ud615 \uc778\uc1c4 \ud15c\ud50c\ub9bf\uacfc \ube44\uad50\ud574 \ubcf4\uc138\uc694.","breadcrumb":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#primaryimage","url":"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/\u4f01\u4e1a\u7ba1\u7406.png","contentUrl":"https:\/\/www.jodoo.com\/blog\/wp-content\/uploads\/2024\/12\/\u4f01\u4e1a\u7ba1\u7406.png","width":768,"height":464,"caption":"blog cover"},{"@type":"BreadcrumbList","@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.jodoo.com\/blog"},{"@type":"ListItem","position":2,"name":"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt"}]},{"@type":"WebSite","@id":"https:\/\/www.jodoo.com\/blog\/#website","url":"https:\/\/www.jodoo.com\/blog\/","name":"\uc870\ub450 \ube14\ub85c\uadf8","description":"Jodoo\uc758 \ub178\ucf54\ub4dc \uac1c\ubc1c, \uc5c5\ub370\uc774\ud2b8, \uc774\ubca4\ud2b8 \ubc0f \uae30\ud0c0 \uc18c\uc2dd\uc5d0 \ub300\ud55c \ucd5c\uc2e0 \uc815\ubcf4\ub97c \ubc1b\uc544\ubcf4\uc138\uc694.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jodoo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/www.jodoo.com\/blog\/#\/schema\/person\/b958cef486b1eb00d0f82e6f0a294481","name":"Jodoo","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/secure.gravatar.com\/avatar\/250e0d43b77e764b8fd961bf41dc0e46963912235f6724430a4fdb771e857168?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/250e0d43b77e764b8fd961bf41dc0e46963912235f6724430a4fdb771e857168?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/250e0d43b77e764b8fd961bf41dc0e46963912235f6724430a4fdb771e857168?s=96&d=mm&r=g","caption":"Jodoo"},"sameAs":["http:\/\/wp.sre.jodoodevelop.com"],"url":"https:\/\/www.jodoo.com\/blog\/ko-kr\/author\/wp-admin"}]}},"_links":{"self":[{"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/posts\/4885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/comments?post=4885"}],"version-history":[{"count":5,"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/posts\/4885\/revisions"}],"predecessor-version":[{"id":5290,"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/posts\/4885\/revisions\/5290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/media\/4707"}],"wp:attachment":[{"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/media?parent=4885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/categories?post=4885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/ko-kr\/wp-json\/wp\/v2\/tags?post=4885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}