{"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-for-quotation-generation","status":"publish","type":"post","link":"https:\/\/www.jodoo.com\/blog\/th-th\/ai-for-quotation-generation","title":{"rendered":"AI for Quotation Generation: A Guide with Google Apps Script and 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>Abstract:<\/strong> In the digital age, automation is a key driver of efficiency and productivity. Today, we&#8217;re going to explore how you can use <a href=\"https:\/\/chat.openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ChatGPT<\/a>, an advanced language model developed by <a href=\"https:\/\/openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">OpenAI<\/a>, to automate business processes and workflow. We&#8217;ll use the generation of quotation sheets as an example. in the final part, we will also demonstrate why Jodoo is also a solid tool for you to generate business documents.<\/p><\/div>\n\n\n\n<p>Many businesses prefer to store data in Google Sheets and create documents in Google Docs. However, creating a sales quotation template manually in these applications can be a time-consuming and error-prone process, especially when dealing with large amounts of data.<\/p>\n\n\n\n<p>This is where&nbsp;<a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google Apps Script<\/a>&nbsp;comes in to elevate the efficiency.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"what-is-google-apps-script\"><\/span>What Is Google Apps Script?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Google Apps Script is a&nbsp;<a href=\"https:\/\/www.jodoo.com\/blog\/what-is-rapid-application-development\" target=\"_blank\" rel=\"noreferrer noopener\">rapid application development<\/a>&nbsp;platform that allows you to build web applications and automate tasks. Here are some key features:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Integration with Google Workspace<\/strong>: You can create business applications that integrate with Google Workspace.<\/li>\n\n\n\n<li><strong>Cloud-based JavaScript Platform<\/strong>: It&#8217;s a cloud-based JavaScript platform that lets you integrate with and automate tasks across Google products.<\/li>\n\n\n\n<li><strong>Automations<\/strong>: You can write code that programmatically performs tasks across Google products. These automations can be triggered by custom menus, buttons, user actions, or a time-based schedule.<\/li>\n\n\n\n<li><strong>Custom Functions<\/strong>: You can write Google Sheets functions in Apps Script and call them from your spreadsheet just like built-in functions.<\/li>\n\n\n\n<li><strong>Add-ons<\/strong>: You can build an app that automates tasks or connects to third-party services from within Google Workspace.<\/li>\n\n\n\n<li><strong>Chat App<\/strong>: You can provide a conversational interface that lets Google Chat users interact with services as if the service were a person.<\/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>How to Automate The Workflow of Creating a Sales Quotation from 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>Step 1: Preparing the Data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>First, we need to prepare our data. For this example, let\u2019s say we\u2019re a small business selling handmade crafts. We\u2019ll create a Google Sheet with the following columns: Company Name, Company ID, Contact Person, Contact Email, Item, Price, Quantity, Total Price.<\/p>\n\n\n\n<p>Here\u2019s a sample of what our data might look like:<\/p>\n\n\n\n<figure class=\"wp-block-table custom-table\"><table><thead><tr><th>Company Name<\/th><th>Company ID<\/th><th>Contact Person<\/th><th>Contact Email<\/th><th>Item<\/th><th>\u0e23\u0e32\u0e04\u0e32<\/th><th>Quantity<\/th><th>Total Price<\/th><\/tr><\/thead><tbody><tr><td>Craft Co.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>Candle<\/td><td>2<\/td><td>50<\/td><td>100<\/td><\/tr><tr><td>Craft Co.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>Soap<\/td><td>1<\/td><td>100<\/td><td>100<\/td><\/tr><tr><td>Craft Co.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>Bath Bomb<\/td><td>3<\/td><td>75<\/td><td>225<\/td><\/tr><tr><td>Acme Co.<\/td><td>78910<\/td><td>Emily Marks<\/td><td><a href=\"mailto:emily@acme.co\">emily@acme.co<\/a><\/td><td>Soap<\/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>Step 2: Generating the Apps Script with ChatGPT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Next, we\u2019ll use ChatGPT to generate a Google Apps Script that will read the data from our Google Sheet and generate a quotation sheet in a Google Document.<\/p>\n\n\n\n<p>To do this, we\u2019ll provide ChatGPT with a prompt that describes our task and requirements. For example:<\/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\">Can you please create a Google Apps Script that reads data from a Google Sheet and generates quotation documents in Google Docs? The script should do the following:<br><br>Read data from a Google Sheet containing the following columns: Company Name, Company ID, Contact Person, Contact Email, Item, Price, Quantity, and Total Price.<br><br>Create separate quotation documents for each company found in the sheet.<br><br>In each document, include the company information (Company Name, Company ID, Contact Person, Contact Email) once at the beginning.<br>Include the product data (Item, Price, Quantity, Total Price) in a table format within the document.<br><br>Process one row at a time and mark each processed row with &#8216;done&#8217; in a new column.<br><br>Make the script accessible from a custom menu in the Google Sheet for easy execution.<br><br>Please ensure that the script handles cases where multiple rows belong to the same company and creates a single quotation document for that company.<br><br>Additionally, make sure the script can be executed directly from the Google Sheet using a custom menu.<\/p><\/div>\n<\/div><\/div><\/blockquote>\n\n\n\n<p>ChatGPT will then generate a script based on our prompt. Here\u2019s the sample code:<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>function generateQuotation() {\n  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();\n  var dataRange = sheet.getDataRange();\n  var values = dataRange.getValues();\n  var numRows = values.length;\n  var headers = values&#91;0];\n  var doneColumn = headers.indexOf('Done');\n  if (doneColumn === -1) {\n    sheet.getRange(1, headers.length + 1).setValue('Done'); \/\/ Add 'Done' column if it doesn't exist\n    doneColumn = headers.length;\n  }\n\n  for (var i = 1; i &lt; numRows; i++) {\n    if (values&#91;i]&#91;doneColumn] !== 'done') { \/\/ Check if the row is not marked as 'done'\n      var companyData = {};\n      var companyName = values&#91;i]&#91;headers.indexOf('Company Name')];\n      var companyID = values&#91;i]&#91;headers.indexOf('Company ID')];\n      var contactPerson = values&#91;i]&#91;headers.indexOf('Contact Person')];\n      var contactEmail = values&#91;i]&#91;headers.indexOf('Contact Email')];\n      var products = &#91;];\n\n      \/\/ Create company data object\n      companyData&#91;'Company Name'] = companyName;\n      companyData&#91;'Company ID'] = companyID;\n      companyData&#91;'Contact Person'] = contactPerson;\n      companyData&#91;'Contact Email'] = contactEmail;\n\n      \/\/ Iterate through rows with the same company information\n      while (i &lt; numRows &amp;&amp; values&#91;i]&#91;headers.indexOf('Company Name')] === companyName) {\n        var item = values&#91;i]&#91;headers.indexOf('Item')];\n        var price = values&#91;i]&#91;headers.indexOf('Price')];\n        var quantity = values&#91;i]&#91;headers.indexOf('Quantity')];\n        var totalPrice = values&#91;i]&#91;headers.indexOf('Total Price')];\n\n        products.push(&#91;item, price, quantity, totalPrice]);\n        sheet.getRange(i + 1, doneColumn + 1).setValue('done'); \/\/ Mark the row as 'done'\n        i++;\n      }\n\n      \/\/ Create a new Google Document for the quotation\n      var doc = DocumentApp.create('Quotation for ' + companyName);\n      var document = DocumentApp.openById(doc.getId());\n      var body = document.getBody();\n\n      \/\/ Add company data to the document\n      body.appendParagraph('Company Name: ' + companyName);\n      body.appendParagraph('Company ID: ' + companyID);\n      body.appendParagraph('Contact Person: ' + contactPerson);\n      body.appendParagraph('Contact Email: ' + contactEmail);\n\n      \/\/ Add product data in a table format\n      var table = &#91;];\n      table.push(&#91;'Item', 'Price', 'Quantity', 'Total Price']);\n      table = table.concat(products);\n      body.appendTable(table);\n\n      document.saveAndClose();\n    }\n  }\n}\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"step-3-implementing-the-script\"><\/span>Step 3: Implementing the Script<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=\"tempalte 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>Once we have our script, we\u2019ll implement it in our Google Sheet. This involves copying the script into the script editor in Google Sheets (Extensions &gt; Apps Script) and running the script.<\/p>\n\n\n\n<p>To run this script, follow these steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open your Google Sheet and fill in the quotation data.<\/li>\n\n\n\n<li>Click on &#8220;Extensions&#8221; -&gt; &#8220;Apps Script&#8221; to open the script editor.&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=\"Google Sheet\" 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>3. Paste the sample code into the script editor.&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>4. the Apps Script editor, click the disk icon to save your changes.<\/p>\n\n\n\n<p>5. Run the&nbsp;<strong>generateQuotation<\/strong>&nbsp;function by clicking \u201cRun\u201d with the play button \u25b6\ufe0f.<\/p>\n\n\n\n<p>6. Complete the authorization process to let the App Script process your data.<\/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=\"Complete Script Implementation\" 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>Step 4: Reviewing the Results<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Finally, we\u2019ll review the results. Once the script is successfully executed, you&#8217;ll see a &#8220;Custom Menu&#8221; added to your Google Sheet menu bar. Click on the &#8220;Custom Menu,&#8221; and you&#8217;ll find the &#8220;Generate Quotation&#8221; option.<\/p>\n\n\n\n<p>If you click on &#8220;Generate Quotation&#8221; to execute the script, and it will create separate quotation documents for each company with the specified structure.<\/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=\"Google Document with quotation sheet\" 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>If everything has been set up correctly, we should now have a Google Document that contains a quotation sheet based on the data in our Google Sheet. Each processed row in the Google Sheet should be marked with \u2018done\u2019 in a new column.<\/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=\"Quotation Document\" 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>A More Efficient Way: Creating Quotation with Jodoo\u2019s Custom Print Template<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Creating a sales quotation is a crucial part of any business process. That\u2019s why\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>\u00a0has supported creating quotations or any BPM document by providing the\u00a0<a href=\"https:\/\/help.jodoo.com\/en\/articles\/10005821-print-templates\" target=\"_blank\" rel=\"noreferrer noopener\">custom print template<\/a>\u00a0function. With Jodoo, this process is streamlined and made more efficient.<\/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>How to create a custom print template in Jodoo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Here&#8217;s a step-by-step guide on how to generate a sales quotation using Jodoo:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select a form that collects your quotation data and click\u00a0<a href=\"https:\/\/help.jodoo.com\/doc\/17191#editingform\" target=\"_blank\" rel=\"noreferrer noopener\">Edit<\/a>. If you don&#8217;t have one, try our\u00a0<a href=\"https:\/\/www.jodoo.com\/template\/order-and-inventory-management-65b0bdde4c02dd632333a55a\" target=\"_blank\" rel=\"noreferrer noopener\">\u0e01\u0e32\u0e23\u0e08\u0e31\u0e14\u0e01\u0e32\u0e23\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07\u0e0b\u0e37\u0e49\u0e2d\u0e41\u0e25\u0e30\u0e2a\u0e34\u0e19\u0e04\u0e49\u0e32\u0e04\u0e07\u0e04\u0e25\u0e31\u0e07<\/a>\u00a0template.<\/li>\n\n\n\n<li>Go to Extension &gt; Print Templates and click New Print Template.&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=\"Print Template\" 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>3. On the template design page, customize the template name to something like &#8220;Sales Quotation Template.&#8221;<\/p>\n\n\n\n<p>4. <a href=\"https:\/\/help.jodoo.com\/doc\/9140#designingthetemplate\" target=\"_blank\" rel=\"noreferrer noopener\">Add the necessary fields<\/a>, such as product name, quantity, price, and total. These fields will be automatically filled with the data from your form.&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=\"Drag and Drop Fields\" 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>5. Once your template is ready, you can generate a sales quotation by simply selecting the data and clicking on the print button on&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/15008#permissionsetsandmanagedata\" target=\"_blank\" rel=\"noreferrer noopener\">PC<\/a>&nbsp;\u0e2b\u0e23\u0e37\u0e2d&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/12010\" target=\"_blank\" rel=\"noreferrer noopener\">mobile<\/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=\"Printing\" 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>What are the benefits of using Jodoo to create business documents like quotations and invoices?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Now, let&#8217;s compare this process with using Google Sheets and Google Docs. While these tools are versatile and widely used, they lack the automation and customization features offered by Jodoo.<\/p>\n\n\n\n<p>Google Apps Script indeed allows for automation within Google Workspace, making Google Sheets a more powerful tool. However, even with this automation, there are still areas where Jodoo stands out.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Ease of Use<\/strong>: While Google Apps Script is powerful, it requires coding knowledge to set up and maintain. This could be a barrier for non-technical users. On the other hand, Jodoo&#8217;s interface is intuitive and user-friendly, allowing anyone to create and manage sales quotations without needing to write a single line of code.<\/li>\n\n\n\n<li><strong>\u0e01\u0e32\u0e23\u0e1a\u0e39\u0e23\u0e13\u0e32\u0e01\u0e32\u0e23<\/strong>: Jodoo is designed to work seamlessly with other parts of your business process. Data from forms, databases, and other sources can be easily linked and updated in real time. While Google Apps Script can be used to create similar integrations, it requires more effort and technical expertise.<\/li>\n\n\n\n<li><strong>Customization<\/strong>: Jodoo&#8217;s custom print templates offer a high level of customization. You can easily adjust the layout, add images, and include custom fields. While Google Apps Script allows for customization, it&#8217;s often more complex and time-consuming to achieve the same level of detail.<\/li>\n\n\n\n<li><strong>Scalability<\/strong>: As your business grows, so does the complexity of your processes. Jodoo is built to handle this growth, allowing you to easily manage and automate large amounts of data. While Google Apps Script can be scaled, it often requires more maintenance and troubleshooting as the complexity increases.<\/li>\n<\/ol>\n\n\n\n<p>In conclusion, while Google Apps Script enhances the capabilities of Google Sheets and ChatGPT can help us to write the Apps Script, Jodoo still offers a more user-friendly, integrated, customizable, and scalable solution for generating sales quotations and other business documents.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>\u0e1a\u0e17\u0e2a\u0e23\u0e38\u0e1b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In conclusion, the advent of AI and its integration into business processes has revolutionized the way we work. The use of advanced language models like ChatGPT in conjunction with Google Apps Script has shown promising results in automating tasks such as generating quotation documents from Google Sheets data.<\/p>\n\n\n\n<p>However, platforms like <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> have taken this a step further, offering a more user-friendly, integrated, customizable, and scalable solution. The future of business process automation is here, and it&#8217;s clear that AI will play a pivotal role in shaping it. As we continue to explore and harness the potential of AI, we can look forward to even more efficient, streamlined, and innovative ways to conduct business.<\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Learn how to automate quotation generation with ChatGPT and Google Apps Script. Discover efficient workflows and compare with Jodoo&#8217;s custom print templates.<\/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 v27.5 - 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\/th-th\/ai-for-quotation-generation\/\" \/>\n<meta property=\"og:locale\" content=\"th_TH\" \/>\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\/th-th\/ai-for-quotation-generation\/\" \/>\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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jodoo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u0e19\u0e32\u0e17\u0e35\" \/>\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\":\"th\"},{\"@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\":\"th\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"th\",\"@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\":\"th\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#\\\/schema\\\/person\\\/b958cef486b1eb00d0f82e6f0a294481\",\"name\":\"Jodoo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"th\",\"@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\\\/th-th\\\/author\\\/wp-admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AI for Quotation Generation: A Guide with Google Apps Script and ChatGPT Prompt - Jodoo Blog","description":"Learn how to automate quotation generation with ChatGPT and Google Apps Script. Discover efficient workflows and compare with Jodoo's custom print templates.","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\/th-th\/ai-for-quotation-generation\/","og_locale":"th_TH","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\/th-th\/ai-for-quotation-generation\/","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":{"Written by":"Jodoo","Est. reading time":"8 \u0e19\u0e32\u0e17\u0e35"},"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":"th"},{"@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":"th","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation"]}]},{"@type":"ImageObject","inLanguage":"th","@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":"\u0e1a\u0e25\u0e47\u0e2d\u0e01\u0e02\u0e2d\u0e07\u0e42\u0e08\u0e14\u0e39","description":"\u0e23\u0e31\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e48\u0e32\u0e2a\u0e38\u0e14\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e41\u0e1a\u0e1a\u0e44\u0e21\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e40\u0e02\u0e35\u0e22\u0e19\u0e42\u0e04\u0e49\u0e14 \u0e01\u0e32\u0e23\u0e2d\u0e31\u0e1b\u0e40\u0e14\u0e15 \u0e01\u0e34\u0e08\u0e01\u0e23\u0e23\u0e21 \u0e41\u0e25\u0e30\u0e02\u0e48\u0e32\u0e27\u0e2a\u0e32\u0e23\u0e2d\u0e37\u0e48\u0e19\u0e46 \u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a 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":"th"},{"@type":"Person","@id":"https:\/\/www.jodoo.com\/blog\/#\/schema\/person\/b958cef486b1eb00d0f82e6f0a294481","name":"Jodoo","image":{"@type":"ImageObject","inLanguage":"th","@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\/th-th\/author\/wp-admin"}]}},"_links":{"self":[{"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/posts\/4885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/comments?post=4885"}],"version-history":[{"count":5,"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/posts\/4885\/revisions"}],"predecessor-version":[{"id":5290,"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/posts\/4885\/revisions\/5290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/media\/4707"}],"wp:attachment":[{"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/media?parent=4885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/categories?post=4885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/th-th\/wp-json\/wp\/v2\/tags?post=4885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}