{"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":"ai-de-tao-bao-gia","status":"publish","type":"post","link":"https:\/\/www.jodoo.com\/blog\/vi-vn\/ai-for-quotation-generation","title":{"rendered":"\u1ee8ng d\u1ee5ng Tr\u00ed tu\u1ec7 Nh\u00e2n t\u1ea1o trong T\u1ea1o B\u00e1o Gi\u00e1: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Apps Script v\u00e0 ChatGPT Prompt"},"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>T\u00f3m t\u1eaft:<\/strong> Trong th\u1eddi \u0111\u1ea1i k\u1ef9 thu\u1eadt s\u1ed1, t\u1ef1 \u0111\u1ed9ng h\u00f3a l\u00e0 \u0111\u1ed9ng l\u1ef1c ch\u00ednh th\u00fac \u0111\u1ea9y hi\u1ec7u qu\u1ea3 v\u00e0 n\u0103ng su\u1ea5t. H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3. <a href=\"https:\/\/chat.openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ChatGPT<\/a>, m\u1ed9t m\u00f4 h\u00ecnh ng\u00f4n ng\u1eef ti\u00ean ti\u1ebfn \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n b\u1edfi <a href=\"https:\/\/openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">OpenAI<\/a>, \u0110\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c quy tr\u00ecnh kinh doanh v\u00e0 lu\u1ed3ng c\u00f4ng vi\u1ec7c. Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng vi\u1ec7c t\u1ea1o b\u1ea3ng b\u00e1o gi\u00e1 l\u00e0m v\u00ed d\u1ee5. \u1ede ph\u1ea7n cu\u1ed1i, ch\u00fang ta c\u0169ng s\u1ebd ch\u1ee9ng minh t\u1ea1i sao Jodoo c\u0169ng l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 b\u1ea1n t\u1ea1o ra c\u00e1c t\u00e0i li\u1ec7u kinh doanh.<\/p><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Nhi\u1ec1u doanh nghi\u1ec7p th\u00edch l\u01b0u tr\u1eef d\u1eef li\u1ec7u trong Google Sheets v\u00e0 t\u1ea1o t\u00e0i li\u1ec7u trong Google Docs. Tuy nhi\u00ean, vi\u1ec7c t\u1ea1o m\u1eabu b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng th\u1ee7 c\u00f4ng trong c\u00e1c \u1ee9ng d\u1ee5ng n\u00e0y c\u00f3 th\u1ec3 t\u1ed1n th\u1eddi gian v\u00e0 d\u1ec5 x\u1ea3y ra l\u1ed7i, \u0111\u1eb7c bi\u1ec7t khi x\u1eed l\u00fd l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u00e2y l\u00e0 n\u01a1i&nbsp;<a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google Apps Script<\/a>&nbsp;Gi\u00fap n\u00e2ng cao hi\u1ec7u qu\u1ea3.<\/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 l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Google Apps Script l\u00e0 m\u1ed9t&nbsp;<a href=\"https:\/\/www.jodoo.com\/blog\/what-is-rapid-application-development\" target=\"_blank\" rel=\"noreferrer noopener\">ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng nhanh ch\u00f3ng<\/a>&nbsp;N\u1ec1n t\u1ea3ng cho ph\u00e9p b\u1ea1n x\u00e2y d\u1ef1ng c\u00e1c \u1ee9ng d\u1ee5ng web v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c t\u00e1c v\u1ee5. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng ch\u00ednh:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>T\u00edch h\u1ee3p v\u1edbi Google Workspace<\/strong>B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c \u1ee9ng d\u1ee5ng kinh doanh t\u00edch h\u1ee3p v\u1edbi Google Workspace.<\/li>\n\n\n\n<li><strong>N\u1ec1n t\u1ea3ng JavaScript d\u1ef1a tr\u00ean \u0111\u00e1m m\u00e2y<\/strong>\u0110\u00e2y l\u00e0 m\u1ed9t n\u1ec1n t\u1ea3ng JavaScript d\u1ef1a tr\u00ean \u0111i\u1ec7n to\u00e1n \u0111\u00e1m m\u00e2y cho ph\u00e9p b\u1ea1n t\u00edch h\u1ee3p v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c t\u00e1c v\u1ee5 tr\u00ean nhi\u1ec1u s\u1ea3n ph\u1ea9m c\u1ee7a Google.<\/li>\n\n\n\n<li><strong>T\u1ef1 \u0111\u1ed9ng h\u00f3a<\/strong>B\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft m\u00e3 \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 tr\u00ean nhi\u1ec1u s\u1ea3n ph\u1ea9m c\u1ee7a Google. C\u00e1c quy tr\u00ecnh t\u1ef1 \u0111\u1ed9ng h\u00f3a n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t b\u1edfi c\u00e1c menu t\u00f9y ch\u1ec9nh, n\u00fat b\u1ea5m, h\u00e0nh \u0111\u1ed9ng c\u1ee7a ng\u01b0\u1eddi d\u00f9ng ho\u1eb7c l\u1ecbch tr\u00ecnh d\u1ef1a tr\u00ean th\u1eddi gian.<\/li>\n\n\n\n<li><strong>Ch\u1ee9c n\u0103ng t\u00f9y ch\u1ec9nh<\/strong>B\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft c\u00e1c h\u00e0m Google Sheets b\u1eb1ng Apps Script v\u00e0 g\u1ecdi ch\u00fang t\u1eeb b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m t\u00edch h\u1ee3p s\u1eb5n.<\/li>\n\n\n\n<li><strong>C\u00e1c ti\u1ec7n \u00edch b\u1ed5 sung<\/strong>B\u1ea1n c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng m\u1ed9t \u1ee9ng d\u1ee5ng t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c t\u00e1c v\u1ee5 ho\u1eb7c k\u1ebft n\u1ed1i v\u1edbi c\u00e1c d\u1ecbch v\u1ee5 c\u1ee7a b\u00ean th\u1ee9 ba ngay trong Google Workspace.<\/li>\n\n\n\n<li><strong>\u1ee8ng d\u1ee5ng tr\u00f2 chuy\u1ec7n<\/strong>B\u1ea1n c\u00f3 th\u1ec3 cung c\u1ea5p giao di\u1ec7n h\u1ed9i tho\u1ea1i cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng Google Chat t\u01b0\u01a1ng t\u00e1c v\u1edbi c\u00e1c d\u1ecbch v\u1ee5 nh\u01b0 th\u1ec3 d\u1ecbch v\u1ee5 \u0111\u00f3 l\u00e0 m\u1ed9t ng\u01b0\u1eddi.<\/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>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh t\u1ea1o b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng t\u1eeb Google Sheets?<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>B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u1ea7u ti\u00ean, ch\u00fang ta c\u1ea7n chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u. V\u00ed d\u1ee5, gi\u1ea3 s\u1eed ch\u00fang ta l\u00e0 m\u1ed9t doanh nghi\u1ec7p nh\u1ecf b\u00e1n \u0111\u1ed3 th\u1ee7 c\u00f4ng m\u1ef9 ngh\u1ec7. Ch\u00fang ta s\u1ebd t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh Google Sheet v\u1edbi c\u00e1c c\u1ed9t sau: T\u00ean c\u00f4ng ty, M\u00e3 s\u1ed1 c\u00f4ng ty, Ng\u01b0\u1eddi li\u00ean h\u1ec7, Email li\u00ean h\u1ec7, M\u1eb7t h\u00e0ng, Gi\u00e1, S\u1ed1 l\u01b0\u1ee3ng, T\u1ed5ng gi\u00e1.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta:<\/p>\n\n\n\n<figure class=\"wp-block-table custom-table\"><table><thead><tr><th>T\u00ean c\u00f4ng ty<\/th><th>M\u00e3 s\u1ed1 c\u00f4ng ty<\/th><th>Ng\u01b0\u1eddi li\u00ean h\u1ec7<\/th><th>Email li\u00ean h\u1ec7<\/th><th>M\u1ee5c<\/th><th>Gi\u00e1<\/th><th>S\u1ed1 l\u01b0\u1ee3ng<\/th><th>T\u1ed5ng gi\u00e1<\/th><\/tr><\/thead><tbody><tr><td>C\u00f4ng ty th\u1ee7 c\u00f4ng.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>N\u1ebfn<\/td><td>2<\/td><td>50<\/td><td>100<\/td><\/tr><tr><td>C\u00f4ng ty th\u1ee7 c\u00f4ng.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>X\u00e0 ph\u00f2ng<\/td><td>1<\/td><td>100<\/td><td>100<\/td><\/tr><tr><td>C\u00f4ng ty th\u1ee7 c\u00f4ng.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>Bom t\u1eafm<\/td><td>3<\/td><td>75<\/td><td>225<\/td><\/tr><tr><td>C\u00f4ng ty Acme.<\/td><td>78910<\/td><td>Emily Marks<\/td><td><a href=\"mailto:emily@acme.co\">emily@acme.co<\/a><\/td><td>X\u00e0 ph\u00f2ng<\/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>B\u01b0\u1edbc 2: T\u1ea1o t\u1eadp l\u1ec7nh Apps Script b\u1eb1ng ChatGPT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ti\u1ebfp theo, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng ChatGPT \u0111\u1ec3 t\u1ea1o m\u1ed9t t\u1eadp l\u1ec7nh Google Apps Script \u0111\u1ecdc d\u1eef li\u1ec7u t\u1eeb Google Sheet v\u00e0 t\u1ea1o m\u1ed9t b\u1ea3ng b\u00e1o gi\u00e1 trong Google Document.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ch\u00fang ta s\u1ebd cung c\u1ea5p cho ChatGPT m\u1ed9t l\u1eddi nh\u1eafc m\u00f4 t\u1ea3 nhi\u1ec7m v\u1ee5 v\u00e0 y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta. V\u00ed d\u1ee5:<\/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\">Vui l\u00f2ng t\u1ea1o m\u1ed9t t\u1eadp l\u1ec7nh Google Apps Script \u0111\u1ec3 \u0111\u1ecdc d\u1eef li\u1ec7u t\u1eeb Google Sheet v\u00e0 t\u1ea1o t\u00e0i li\u1ec7u b\u00e1o gi\u00e1 trong Google Docs. T\u1eadp l\u1ec7nh c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<br><br>\u0110\u1ecdc d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh Google Sheet ch\u1ee9a c\u00e1c c\u1ed9t sau: T\u00ean c\u00f4ng ty, M\u00e3 c\u00f4ng ty, Ng\u01b0\u1eddi li\u00ean h\u1ec7, Email li\u00ean h\u1ec7, M\u1eb7t h\u00e0ng, Gi\u00e1, S\u1ed1 l\u01b0\u1ee3ng v\u00e0 T\u1ed5ng gi\u00e1.<br><br>T\u1ea1o c\u00e1c t\u00e0i li\u1ec7u b\u00e1o gi\u00e1 ri\u00eang bi\u1ec7t cho m\u1ed7i c\u00f4ng ty c\u00f3 trong b\u1ea3ng t\u00ednh.<br><br>Trong m\u1ed7i t\u00e0i li\u1ec7u, h\u00e3y ghi th\u00f4ng tin c\u00f4ng ty (T\u00ean c\u00f4ng ty, M\u00e3 s\u1ed1 c\u00f4ng ty, Ng\u01b0\u1eddi li\u00ean h\u1ec7, Email li\u00ean h\u1ec7) m\u1ed9t l\u1ea7n \u1edf \u0111\u1ea7u.<br>Bao g\u1ed3m d\u1eef li\u1ec7u s\u1ea3n ph\u1ea9m (M\u1eb7t h\u00e0ng, Gi\u00e1, S\u1ed1 l\u01b0\u1ee3ng, T\u1ed5ng gi\u00e1) d\u01b0\u1edbi d\u1ea1ng b\u1ea3ng trong t\u00e0i li\u1ec7u.<br><br>X\u1eed l\u00fd t\u1eebng h\u00e0ng m\u1ed9t v\u00e0 \u0111\u00e1nh d\u1ea5u m\u1ed7i h\u00e0ng \u0111\u00e3 x\u1eed l\u00fd b\u1eb1ng ch\u1eef &#039;done&#039; trong m\u1ed9t c\u1ed9t m\u1edbi.<br><br>H\u00e3y t\u1ea1o m\u1ed9t menu t\u00f9y ch\u1ec9nh trong Google Sheet \u0111\u1ec3 d\u1ec5 d\u00e0ng th\u1ef1c thi \u0111o\u1ea1n m\u00e3.<br><br>Vui l\u00f2ng \u0111\u1ea3m b\u1ea3o r\u1eb1ng k\u1ecbch b\u1ea3n x\u1eed l\u00fd \u0111\u01b0\u1ee3c c\u00e1c tr\u01b0\u1eddng h\u1ee3p nhi\u1ec1u h\u00e0ng thu\u1ed9c c\u00f9ng m\u1ed9t c\u00f4ng ty v\u00e0 t\u1ea1o m\u1ed9t t\u00e0i li\u1ec7u b\u00e1o gi\u00e1 duy nh\u1ea5t cho c\u00f4ng ty \u0111\u00f3.<br><br>Ngo\u00e0i ra, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng t\u1eadp l\u1ec7nh c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c thi tr\u1ef1c ti\u1ebfp t\u1eeb Google Sheet b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng menu t\u00f9y ch\u1ec9nh.<\/p><\/div>\n<\/div><\/div><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">ChatGPT sau \u0111\u00f3 s\u1ebd t\u1ea1o ra m\u1ed9t \u0111o\u1ea1n m\u00e3 d\u1ef1a tr\u00ean y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta. \u0110\u00e2y l\u00e0 \u0111o\u1ea1n m\u00e3 m\u1eabu:<\/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;); \/\/ Th\u00eam c\u1ed9t &#039;Done&#039; n\u1ebfu ch\u01b0a t\u1ed3n t\u1ea1i doneColumn = headers.length; } for (var i = 1; i &lt; numRows; i++) { if (values[i][doneColumn] !== &#039;done&#039;) { \/\/ Ki\u1ec3m tra xem h\u00e0ng c\u00f3 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 &#039;\u0111\u00e3 ho\u00e0n th\u00e0nh&#039; hay kh\u00f4ng var companyData = {}; var companyName = values[i][headers.indexOf(&#039;Company Name&#039;)]; var companyID = values[i][headers.indexOf(&#039;Company ID&#039;)]; var contactPerson = values[i][headers.indexOf(&#039;Contact Person&#039;)]; var contactEmail = values[i][headers.indexOf(&#039;Contact Email&#039;)]; var products = []; \/\/ T\u1ea1o \u0111\u1ed1i t\u01b0\u1ee3ng d\u1eef li\u1ec7u c\u00f4ng ty companyData[&#039;Company Name&#039;] = companyName; companyData[&#039;Company ID&#039;] = companyID; companyData[&#039;Contact Person&#039;] = contactPerson; companyData[&#039;Contact Email&#039;] = contactEmail; \/\/ L\u1eb7p qua c\u00e1c h\u00e0ng c\u00f3 c\u00f9ng th\u00f4ng tin c\u00f4ng ty while (i &lt; numRows &amp;&amp; values[i][headers.indexOf(&#039;Company Name&#039;)] === companyName) { var item = values[i][headers.indexOf(&#039;Item&#039;)]; var price = values[i][headers.indexOf(&#039;Price&#039;)]; var quantity = values[i][headers.indexOf(&#039;Quantity&#039;)]; var totalPrice = values[i][headers.indexOf(&#039;Total Price&#039;)]; products.push([item, price, quantity, totalPrice]); sheet.getRange(i + 1, doneColumn + 1).setValue(&#039;done&#039;); \/\/ \u0110\u00e1nh d\u1ea5u h\u00e0ng l\u00e0 &#039;\u0111\u00e3 ho\u00e0n th\u00e0nh&#039; i++; } \/\/ T\u1ea1o m\u1ed9t t\u00e0i li\u1ec7u Google m\u1edbi cho b\u00e1o gi\u00e1 var doc = DocumentApp.create(&#039;B\u00e1o gi\u00e1 cho &#039; + companyName); var document = DocumentApp.openById(doc.getId()); var body = document.getBody(); \/\/ Th\u00eam d\u1eef li\u1ec7u c\u00f4ng ty v\u00e0o t\u00e0i li\u1ec7u body.appendParagraph(&#039;T\u00ean c\u00f4ng ty: &#039; + companyName); body.appendParagraph(&#039;M\u00e3 c\u00f4ng ty: &#039; + companyID); body.appendParagraph(&#039;Ng\u01b0\u1eddi li\u00ean h\u1ec7: &#039; + contactPerson); body.appendParagraph(&#039;Email li\u00ean h\u1ec7: &#039; + contactEmail); \/\/ Th\u00eam d\u1eef li\u1ec7u s\u1ea3n ph\u1ea9m \u1edf \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng var table = []; table.push([&#039;M\u1eb7t h\u00e0ng&#039;, &#039;Gi\u00e1&#039;, &#039;S\u1ed1 l\u01b0\u1ee3ng&#039;, &#039;T\u1ed5ng gi\u00e1&#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>B\u01b0\u1edbc 3: Tri\u1ec3n khai k\u1ecbch b\u1ea3n<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=\"m\u1eabu 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\">Sau khi c\u00f3 k\u1ecbch b\u1ea3n, ch\u00fang ta s\u1ebd t\u00edch h\u1ee3p n\u00f3 v\u00e0o Google Sheet. Vi\u1ec7c n\u00e0y bao g\u1ed3m sao ch\u00e9p k\u1ecbch b\u1ea3n v\u00e0o tr\u00ecnh ch\u1ec9nh s\u1eeda k\u1ecbch b\u1ea3n trong Google Sheets (Ti\u1ec7n \u00edch m\u1edf r\u1ed9ng &gt; Apps Script) v\u00e0 ch\u1ea1y k\u1ecbch b\u1ea3n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u1ec3 ch\u1ea1y \u0111o\u1ea1n m\u00e3 n\u00e0y, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>M\u1edf Google Sheet c\u1ee7a b\u1ea1n v\u00e0 \u0111i\u1ec1n th\u00f4ng tin b\u00e1o gi\u00e1.<\/li>\n\n\n\n<li>Nh\u1ea5p v\u00e0o \u201cTi\u1ec7n \u00edch m\u1edf r\u1ed9ng\u201d -&gt; \u201cApps Script\u201d \u0111\u1ec3 m\u1edf tr\u00ecnh ch\u1ec9nh s\u1eeda t\u1eadp l\u1ec7nh.&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=\"B\u1ea3ng t\u00ednh Google\" 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. D\u00e1n \u0111o\u1ea1n m\u00e3 m\u1eabu v\u00e0o tr\u00ecnh so\u1ea1n th\u1ea3o k\u1ecbch b\u1ea3n.&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=\"Apps Script\" 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. Trong tr\u00ecnh ch\u1ec9nh s\u1eeda Apps Script, nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u0111\u0129a \u0111\u1ec3 l\u01b0u c\u00e1c thay \u0111\u1ed5i c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. Ch\u1ea1y&nbsp;<strong>t\u1ea1o b\u00e1o gi\u00e1<\/strong>&nbsp;Ch\u1ee9c n\u0103ng \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o \u201cCh\u1ea1y\u201d c\u00f9ng v\u1edbi n\u00fat ph\u00e1t \u25b6\ufe0f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6. Ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh \u1ee7y quy\u1ec1n \u0111\u1ec3 cho ph\u00e9p App Script x\u1eed l\u00fd d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/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=\"Ho\u00e0n th\u00e0nh vi\u1ec7c tri\u1ec3n khai k\u1ecbch b\u1ea3n\" 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>B\u01b0\u1edbc 4: Xem x\u00e9t k\u1ebft qu\u1ea3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Cu\u1ed1i c\u00f9ng, ch\u00fang ta s\u1ebd xem l\u1ea1i k\u1ebft qu\u1ea3. Sau khi k\u1ecbch b\u1ea3n \u0111\u01b0\u1ee3c th\u1ef1c thi th\u00e0nh c\u00f4ng, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t \u201cMenu T\u00f9y Ch\u1ec9nh\u201d \u0111\u01b0\u1ee3c th\u00eam v\u00e0o thanh menu c\u1ee7a Google Sheet. Nh\u1ea5p v\u00e0o \u201cMenu T\u00f9y Ch\u1ec9nh\u201d, v\u00e0 b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y t\u00f9y ch\u1ecdn \u201cT\u1ea1o B\u00e1o Gi\u00e1\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">N\u1ebfu b\u1ea1n nh\u1ea5p v\u00e0o \u201cT\u1ea1o b\u00e1o gi\u00e1\u201d \u0111\u1ec3 ch\u1ea1y t\u1eadp l\u1ec7nh, n\u00f3 s\u1ebd t\u1ea1o c\u00e1c t\u00e0i li\u1ec7u b\u00e1o gi\u00e1 ri\u00eang bi\u1ec7t cho m\u1ed7i c\u00f4ng ty v\u1edbi c\u1ea5u tr\u00fac \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/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=\"T\u00e0i li\u1ec7u Google Docs k\u00e8m b\u1ea3ng b\u00e1o gi\u00e1\" 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\">N\u1ebfu m\u1ecdi th\u1ee9 \u0111\u00e3 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp \u0111\u00fang c\u00e1ch, gi\u1edd \u0111\u00e2y ch\u00fang ta s\u1ebd c\u00f3 m\u1ed9t t\u00e0i li\u1ec7u Google ch\u1ee9a b\u1ea3ng b\u00e1o gi\u00e1 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Google c\u1ee7a ch\u00fang ta. M\u1ed7i h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd trong b\u1ea3ng t\u00ednh Google s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 &#039;\u0111\u00e3 ho\u00e0n th\u00e0nh&#039; trong m\u1ed9t c\u1ed9t m\u1edbi.<\/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=\"T\u00e0i li\u1ec7u b\u00e1o gi\u00e1\" 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>C\u00e1ch hi\u1ec7u qu\u1ea3 h\u01a1n: T\u1ea1o b\u00e1o gi\u00e1 b\u1eb1ng m\u1eabu in t\u00f9y ch\u1ec9nh c\u1ee7a Jodoo<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Vi\u1ec7c l\u1eadp b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng l\u00e0 m\u1ed9t ph\u1ea7n quan tr\u1ecdng trong b\u1ea5t k\u1ef3 quy tr\u00ecnh kinh doanh n\u00e0o. \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao\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\u0111\u00e3 h\u1ed7 tr\u1ee3 vi\u1ec7c t\u1ea1o b\u00e1o gi\u00e1 ho\u1eb7c b\u1ea5t k\u1ef3 t\u00e0i li\u1ec7u BPM n\u00e0o b\u1eb1ng c\u00e1ch cung c\u1ea5p\u00a0<a href=\"https:\/\/help.jodoo.com\/en\/articles\/10005821-print-templates\" target=\"_blank\" rel=\"noreferrer noopener\">m\u1eabu in t\u00f9y ch\u1ec9nh<\/a>\u00a0V\u1edbi Jodoo, quy tr\u00ecnh n\u00e0y \u0111\u01b0\u1ee3c \u0111\u01a1n gi\u1ea3n h\u00f3a v\u00e0 th\u1ef1c hi\u1ec7n hi\u1ec7u qu\u1ea3 h\u01a1n.<\/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>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1eabu in t\u00f9y ch\u1ec9nh trong Jodoo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc v\u1ec1 c\u00e1ch t\u1ea1o b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng b\u1eb1ng Jodoo:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ch\u1ecdn bi\u1ec3u m\u1eabu thu th\u1eadp d\u1eef li\u1ec7u b\u00e1o gi\u00e1 c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5p v\u00e0o\u00a0<a href=\"https:\/\/help.jodoo.com\/doc\/17191#editingform\" target=\"_blank\" rel=\"noreferrer noopener\">Bi\u00ean t\u1eadp<\/a>. N\u1ebfu b\u1ea1n ch\u01b0a c\u00f3, h\u00e3y th\u1eed s\u1ea3n ph\u1ea9m c\u1ee7a ch\u00fang t\u00f4i.\u00a0<a href=\"https:\/\/www.jodoo.com\/template\/order-and-inventory-management-65b0bdde4c02dd632333a55a\" target=\"_blank\" rel=\"noreferrer noopener\">Qu\u1ea3n l\u00fd \u0111\u01a1n h\u00e0ng v\u00e0 t\u1ed3n kho<\/a>\u00a0b\u1ea3n m\u1eabu.<\/li>\n\n\n\n<li>V\u00e0o m\u1ee5c Ti\u1ec7n \u00edch m\u1edf r\u1ed9ng &gt; M\u1eabu in v\u00e0 nh\u1ea5p v\u00e0o T\u1ea1o m\u1eabu in m\u1edbi.&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=\"M\u1eabu in\" 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. Tr\u00ean trang thi\u1ebft k\u1ebf m\u1eabu, h\u00e3y t\u00f9y ch\u1ec9nh t\u00ean m\u1eabu th\u00e0nh m\u1ed9t c\u00e1i t\u00ean n\u00e0o \u0111\u00f3, v\u00ed d\u1ee5 nh\u01b0 \u201cM\u1eabu b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng\u201d.\u201d<\/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\">Th\u00eam c\u00e1c tr\u01b0\u1eddng c\u1ea7n thi\u1ebft<\/a>, V\u00ed d\u1ee5 nh\u01b0 t\u00ean s\u1ea3n ph\u1ea9m, s\u1ed1 l\u01b0\u1ee3ng, gi\u00e1 c\u1ea3 v\u00e0 t\u1ed5ng c\u1ed9ng. C\u00e1c tr\u01b0\u1eddng n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u t\u1eeb bi\u1ec3u m\u1eabu c\u1ee7a b\u1ea1n.&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=\"K\u00e9o v\u00e0 th\u1ea3 c\u00e1c tr\u01b0\u1eddng\" 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. Sau khi m\u1eabu \u0111\u00e3 s\u1eb5n s\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng b\u1eb1ng c\u00e1ch ch\u1ecdn d\u1eef li\u1ec7u v\u00e0 nh\u1ea5p v\u00e0o n\u00fat in.&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/15008#permissionsetsandmanagedata\" target=\"_blank\" rel=\"noreferrer noopener\">M\u00e1y t\u00ednh c\u00e1 nh\u00e2n<\/a>&nbsp;ho\u1eb7c&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/12010\" target=\"_blank\" rel=\"noreferrer noopener\">\u0111i\u1ec7n tho\u1ea1i di \u0111\u1ed9ng<\/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=\"In \u1ea5n\" 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>Vi\u1ec7c s\u1eed d\u1ee5ng Jodoo \u0111\u1ec3 t\u1ea1o c\u00e1c t\u00e0i li\u1ec7u kinh doanh nh\u01b0 b\u00e1o gi\u00e1 v\u00e0 h\u00f3a \u0111\u01a1n mang l\u1ea1i nh\u1eefng l\u1ee3i \u00edch g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Gi\u1edd h\u00e3y so s\u00e1nh quy tr\u00ecnh n\u00e0y v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng Google Sheets v\u00e0 Google Docs. M\u1eb7c d\u00f9 nh\u1eefng c\u00f4ng c\u1ee5 n\u00e0y r\u1ea5t \u0111a n\u0103ng v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i, nh\u01b0ng ch\u00fang thi\u1ebfu c\u00e1c t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 t\u00f9y ch\u1ec9nh m\u00e0 Jodoo cung c\u1ea5p.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Google Apps Script th\u1ef1c s\u1ef1 cho ph\u00e9p t\u1ef1 \u0111\u1ed9ng h\u00f3a trong Google Workspace, gi\u00fap Google Sheets tr\u1edf th\u00e0nh m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd h\u01a1n. Tuy nhi\u00ean, ngay c\u1ea3 v\u1edbi t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng h\u00f3a n\u00e0y, Jodoo v\u1eabn c\u00f3 nh\u1eefng \u0111i\u1ec3m n\u1ed5i b\u1eadt.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>D\u1ec5 s\u1eed d\u1ee5ng<\/strong>M\u1eb7c d\u00f9 Google Apps Script r\u1ea5t m\u1ea1nh m\u1ebd, nh\u01b0ng n\u00f3 y\u00eau c\u1ea7u ki\u1ebfn th\u1ee9c l\u1eadp tr\u00ecnh \u0111\u1ec3 thi\u1ebft l\u1eadp v\u00e0 b\u1ea3o tr\u00ec. \u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 l\u00e0 r\u00e0o c\u1ea3n \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng chuy\u00ean v\u1ec1 k\u1ef9 thu\u1eadt. M\u1eb7t kh\u00e1c, giao di\u1ec7n c\u1ee7a Jodoo tr\u1ef1c quan v\u00e0 th\u00e2n thi\u1ec7n v\u1edbi ng\u01b0\u1eddi d\u00f9ng, cho ph\u00e9p b\u1ea5t k\u1ef3 ai c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i vi\u1ebft m\u1ed9t d\u00f2ng m\u00e3 n\u00e0o.<\/li>\n\n\n\n<li><strong>T\u00edch h\u1ee3p<\/strong>Jodoo \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 ho\u1ea1t \u0111\u1ed9ng li\u1ec1n m\u1ea1ch v\u1edbi c\u00e1c ph\u1ea7n kh\u00e1c trong quy tr\u00ecnh kinh doanh c\u1ee7a b\u1ea1n. D\u1eef li\u1ec7u t\u1eeb c\u00e1c bi\u1ec3u m\u1eabu, c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u00e0 c\u00e1c ngu\u1ed3n kh\u00e1c c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u00e0 c\u1eadp nh\u1eadt theo th\u1eddi gian th\u1ef1c. M\u1eb7c d\u00f9 Google Apps Script c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o c\u00e1c t\u00edch h\u1ee3p t\u01b0\u01a1ng t\u1ef1, nh\u01b0ng n\u00f3 \u0111\u00f2i h\u1ecfi nhi\u1ec1u n\u1ed7 l\u1ef1c v\u00e0 chuy\u00ean m\u00f4n k\u1ef9 thu\u1eadt h\u01a1n.<\/li>\n\n\n\n<li><strong>T\u00f9y ch\u1ec9nh<\/strong>C\u00e1c m\u1eabu in t\u00f9y ch\u1ec9nh c\u1ee7a Jodoo cung c\u1ea5p kh\u1ea3 n\u0103ng t\u00f9y ch\u1ec9nh cao. B\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u0111i\u1ec1u ch\u1ec9nh b\u1ed1 c\u1ee5c, th\u00eam h\u00ecnh \u1ea3nh v\u00e0 bao g\u1ed3m c\u00e1c tr\u01b0\u1eddng t\u00f9y ch\u1ec9nh. M\u1eb7c d\u00f9 Google Apps Script c\u0169ng cho ph\u00e9p t\u00f9y ch\u1ec9nh, nh\u01b0ng vi\u1ec7c \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee9c \u0111\u1ed9 chi ti\u1ebft t\u01b0\u01a1ng t\u1ef1 th\u01b0\u1eddng ph\u1ee9c t\u1ea1p v\u00e0 t\u1ed1n th\u1eddi gian h\u01a1n.<\/li>\n\n\n\n<li><strong>Kh\u1ea3 n\u0103ng m\u1edf r\u1ed9ng<\/strong>Khi doanh nghi\u1ec7p c\u1ee7a b\u1ea1n ph\u00e1t tri\u1ec3n, \u0111\u1ed9 ph\u1ee9c t\u1ea1p c\u1ee7a c\u00e1c quy tr\u00ecnh c\u0169ng t\u0103ng l\u00ean. Jodoo \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng \u0111\u1ec3 x\u1eed l\u00fd s\u1ef1 ph\u00e1t tri\u1ec3n n\u00e0y, cho ph\u00e9p b\u1ea1n d\u1ec5 d\u00e0ng qu\u1ea3n l\u00fd v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u. M\u1eb7c d\u00f9 Google Apps Script c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng quy m\u00f4, nh\u01b0ng n\u00f3 th\u01b0\u1eddng y\u00eau c\u1ea7u b\u1ea3o tr\u00ec v\u00e0 kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 nhi\u1ec1u h\u01a1n khi \u0111\u1ed9 ph\u1ee9c t\u1ea1p t\u0103ng l\u00ean.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00f3m l\u1ea1i, m\u1eb7c d\u00f9 Google Apps Script t\u0103ng c\u01b0\u1eddng kh\u1ea3 n\u0103ng c\u1ee7a Google Sheets v\u00e0 ChatGPT c\u00f3 th\u1ec3 gi\u00fap ch\u00fang ta vi\u1ebft Apps Script, Jodoo v\u1eabn cung c\u1ea5p m\u1ed9t gi\u1ea3i ph\u00e1p th\u00e2n thi\u1ec7n v\u1edbi ng\u01b0\u1eddi d\u00f9ng h\u01a1n, t\u00edch h\u1ee3p h\u01a1n, c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh v\u00e0 m\u1edf r\u1ed9ng h\u01a1n \u0111\u1ec3 t\u1ea1o b\u00e1o gi\u00e1 b\u00e1n h\u00e0ng v\u00e0 c\u00e1c t\u00e0i li\u1ec7u kinh doanh kh\u00e1c.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Ph\u1ea7n k\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00f3m l\u1ea1i, s\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a tr\u00ed tu\u1ec7 nh\u00e2n t\u1ea1o (AI) v\u00e0 vi\u1ec7c t\u00edch h\u1ee3p n\u00f3 v\u00e0o c\u00e1c quy tr\u00ecnh kinh doanh \u0111\u00e3 c\u00e1ch m\u1ea1ng h\u00f3a c\u00e1ch ch\u00fang ta l\u00e0m vi\u1ec7c. Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c m\u00f4 h\u00ecnh ng\u00f4n ng\u1eef ti\u00ean ti\u1ebfn nh\u01b0 ChatGPT k\u1ebft h\u1ee3p v\u1edbi Google Apps Script \u0111\u00e3 cho th\u1ea5y nh\u1eefng k\u1ebft qu\u1ea3 \u0111\u1ea7y h\u1ee9a h\u1eb9n trong vi\u1ec7c t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c t\u00e1c v\u1ee5 nh\u01b0 t\u1ea1o b\u00e1o gi\u00e1 t\u1eeb d\u1eef li\u1ec7u Google Sheets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tuy nhi\u00ean, c\u00e1c n\u1ec1n t\u1ea3ng nh\u01b0 <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> H\u1ecd \u0111\u00e3 ti\u1ebfn th\u00eam m\u1ed9t b\u01b0\u1edbc n\u1eefa, cung c\u1ea5p m\u1ed9t gi\u1ea3i ph\u00e1p th\u00e2n thi\u1ec7n v\u1edbi ng\u01b0\u1eddi d\u00f9ng h\u01a1n, t\u00edch h\u1ee3p h\u01a1n, c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh v\u00e0 m\u1edf r\u1ed9ng h\u01a1n. T\u01b0\u01a1ng lai c\u1ee7a t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh kinh doanh \u0111\u00e3 \u0111\u1ebfn, v\u00e0 r\u00f5 r\u00e0ng l\u00e0 tr\u00ed tu\u1ec7 nh\u00e2n t\u1ea1o (AI) s\u1ebd \u0111\u00f3ng vai tr\u00f2 then ch\u1ed1t trong vi\u1ec7c \u0111\u1ecbnh h\u00ecnh n\u00f3. Khi ch\u00fang ta ti\u1ebfp t\u1ee5c kh\u00e1m ph\u00e1 v\u00e0 khai th\u00e1c ti\u1ec1m n\u0103ng c\u1ee7a AI, ch\u00fang ta c\u00f3 th\u1ec3 mong ch\u1edd nh\u1eefng c\u00e1ch th\u1ee9c kinh doanh hi\u1ec7u qu\u1ea3 h\u01a1n, tinh g\u1ecdn h\u01a1n v\u00e0 s\u00e1ng t\u1ea1o h\u01a1n n\u1eefa.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>T\u00ecm hi\u1ec3u c\u00e1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c t\u1ea1o b\u00e1o gi\u00e1 v\u1edbi ChatGPT v\u00e0 Google Apps Script. Kh\u00e1m ph\u00e1 c\u00e1c quy tr\u00ecnh l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 so s\u00e1nh v\u1edbi c\u00e1c m\u1eabu in t\u00f9y ch\u1ec9nh c\u1ee7a Jodoo.<\/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\/vi-vn\/ai-de-tao-bao-gia\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\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\/vi-vn\/ai-de-tao-bao-gia\/\" \/>\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=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jodoo\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 ph\u00fat\" \/>\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\":\"vi\"},{\"@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\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@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\":\"vi\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#\\\/schema\\\/person\\\/b958cef486b1eb00d0f82e6f0a294481\",\"name\":\"Jodoo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@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\\\/vi-vn\\\/author\\\/wp-admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u1ee8ng d\u1ee5ng Tr\u00ed tu\u1ec7 Nh\u00e2n t\u1ea1o trong T\u1ea1o B\u00e1o Gi\u00e1: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Apps Script v\u00e0 ChatGPT Prompt - Blog Jodoo","description":"T\u00ecm hi\u1ec3u c\u00e1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c t\u1ea1o b\u00e1o gi\u00e1 v\u1edbi ChatGPT v\u00e0 Google Apps Script. Kh\u00e1m ph\u00e1 c\u00e1c quy tr\u00ecnh l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 so s\u00e1nh v\u1edbi c\u00e1c m\u1eabu in t\u00f9y ch\u1ec9nh c\u1ee7a Jodoo.","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\/vi-vn\/ai-de-tao-bao-gia\/","og_locale":"vi_VN","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\/vi-vn\/ai-de-tao-bao-gia\/","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":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Jodoo","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"8 ph\u00fat"},"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":"vi"},{"@type":"WebPage","@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation","url":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation","name":"\u1ee8ng d\u1ee5ng Tr\u00ed tu\u1ec7 Nh\u00e2n t\u1ea1o trong T\u1ea1o B\u00e1o Gi\u00e1: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Google Apps Script v\u00e0 ChatGPT Prompt - Blog Jodoo","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":"T\u00ecm hi\u1ec3u c\u00e1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c t\u1ea1o b\u00e1o gi\u00e1 v\u1edbi ChatGPT v\u00e0 Google Apps Script. Kh\u00e1m ph\u00e1 c\u00e1c quy tr\u00ecnh l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 so s\u00e1nh v\u1edbi c\u00e1c m\u1eabu in t\u00f9y ch\u1ec9nh c\u1ee7a Jodoo.","breadcrumb":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation"]}]},{"@type":"ImageObject","inLanguage":"vi","@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":"Blog Jodoo","description":"Nh\u1eadn th\u00f4ng tin m\u1edbi nh\u1ea5t v\u1ec1 ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng kh\u00f4ng c\u1ea7n l\u1eadp tr\u00ecnh, c\u00e1c b\u1ea3n c\u1eadp nh\u1eadt, s\u1ef1 ki\u1ec7n v\u00e0 c\u00e1c tin t\u1ee9c kh\u00e1c v\u1ec1 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":"vi"},{"@type":"Person","@id":"https:\/\/www.jodoo.com\/blog\/#\/schema\/person\/b958cef486b1eb00d0f82e6f0a294481","name":"Jodoo","image":{"@type":"ImageObject","inLanguage":"vi","@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\/vi-vn\/author\/wp-admin"}]}},"_links":{"self":[{"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/posts\/4885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/comments?post=4885"}],"version-history":[{"count":5,"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/posts\/4885\/revisions"}],"predecessor-version":[{"id":5290,"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/posts\/4885\/revisions\/5290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/media\/4707"}],"wp:attachment":[{"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/media?parent=4885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/categories?post=4885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/vi-vn\/wp-json\/wp\/v2\/tags?post=4885"}],"curies":[{"name":"trang web","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}