{"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-untuk-pembuatan-penawaran-harga","status":"publish","type":"post","link":"https:\/\/www.jodoo.com\/blog\/id-id\/ai-for-quotation-generation","title":{"rendered":"AI untuk Pembuatan Penawaran Harga: Panduan dengan Google Apps Script dan Prompt ChatGPT"},"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>Abstrak:<\/strong> Di era digital, otomatisasi merupakan pendorong utama efisiensi dan produktivitas. Hari ini, kita akan mengeksplorasi bagaimana Anda dapat menggunakan <a href=\"https:\/\/chat.openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ChatGPT<\/a>, sebuah model bahasa tingkat lanjut yang dikembangkan oleh <a href=\"https:\/\/openai.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">OpenAI<\/a>, untuk mengotomatiskan proses bisnis dan alur kerja. Kita akan menggunakan pembuatan lembar penawaran sebagai contoh. Pada bagian akhir, kita juga akan menunjukkan mengapa Jodoo juga merupakan alat yang andal bagi Anda untuk membuat dokumen bisnis.<\/p><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Banyak bisnis lebih memilih menyimpan data di Google Sheets dan membuat dokumen di Google Docs. Namun, membuat templat penawaran penjualan secara manual di aplikasi ini dapat memakan waktu dan rawan kesalahan, terutama saat berurusan dengan data dalam jumlah besar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Di sinilah tempatnya&nbsp;<a href=\"https:\/\/developers.google.com\/apps-script\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google Apps Script<\/a>&nbsp;hadir untuk meningkatkan efisiensi.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"what-is-google-apps-script\"><\/span>Apa itu Google Apps Script?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Google Apps Script adalah sebuah&nbsp;<a href=\"https:\/\/www.jodoo.com\/blog\/what-is-rapid-application-development\" target=\"_blank\" rel=\"noreferrer noopener\">pengembangan aplikasi cepat<\/a>&nbsp;Platform yang memungkinkan Anda membangun aplikasi web dan mengotomatiskan tugas. Berikut beberapa fitur utamanya:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Integrasi dengan Google Workspace<\/strong>Anda dapat membuat aplikasi bisnis yang terintegrasi dengan Google Workspace.<\/li>\n\n\n\n<li><strong>Platform JavaScript berbasis cloud<\/strong>Ini adalah platform JavaScript berbasis cloud yang memungkinkan Anda berintegrasi dengan dan mengotomatiskan tugas di seluruh produk Google.<\/li>\n\n\n\n<li><strong>Otomatisasi<\/strong>Anda dapat menulis kode yang secara terprogram menjalankan tugas di seluruh produk Google. Otomatisasi ini dapat dipicu oleh menu khusus, tombol, tindakan pengguna, atau jadwal berbasis waktu.<\/li>\n\n\n\n<li><strong>Fungsi Kustom<\/strong>Anda dapat menulis fungsi Google Sheets di Apps Script dan memanggilnya dari spreadsheet Anda seperti halnya fungsi bawaan.<\/li>\n\n\n\n<li><strong>Tambahan<\/strong>Anda dapat membuat aplikasi yang mengotomatiskan tugas atau terhubung ke layanan pihak ketiga dari dalam Google Workspace.<\/li>\n\n\n\n<li><strong>Aplikasi Obrolan<\/strong>Anda dapat menyediakan antarmuka percakapan yang memungkinkan pengguna Google Chat berinteraksi dengan layanan seolah-olah layanan tersebut adalah seseorang.<\/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>Bagaimana cara mengotomatiskan alur kerja pembuatan penawaran penjualan dari 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>Langkah 1: Mempersiapkan Data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Pertama, kita perlu mempersiapkan data kita. Untuk contoh ini, anggaplah kita adalah bisnis kecil yang menjual kerajinan tangan. Kita akan membuat Google Sheet dengan kolom-kolom berikut: Nama Perusahaan, ID Perusahaan, Kontak Person, Email Kontak, Item, Harga, Kuantitas, Total Harga.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Berikut contoh tampilan data kami:<\/p>\n\n\n\n<figure class=\"wp-block-table custom-table\"><table><thead><tr><th>Nama perusahaan<\/th><th>ID Perusahaan<\/th><th>Kontak person<\/th><th>Email Kontak<\/th><th>Barang<\/th><th>Harga<\/th><th>Kuantitas<\/th><th>Harga Total<\/th><\/tr><\/thead><tbody><tr><td>Perusahaan Kerajinan.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>Lilin<\/td><td>2<\/td><td>50<\/td><td>100<\/td><\/tr><tr><td>Perusahaan Kerajinan.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>Sabun<\/td><td>1<\/td><td>100<\/td><td>100<\/td><\/tr><tr><td>Perusahaan Kerajinan.<\/td><td>123456<\/td><td>John Doe<\/td><td><a href=\"mailto:john@craft.co\">john@craft.co<\/a><\/td><td>Bom Mandi<\/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>Sabun<\/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>Langkah 2: Membuat Apps Script dengan ChatGPT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Selanjutnya, kita akan menggunakan ChatGPT untuk membuat Google Apps Script yang akan membaca data dari Google Sheet kita dan membuat lembar penawaran harga dalam Google Document.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk melakukan ini, kami akan memberikan perintah kepada ChatGPT yang menjelaskan tugas dan persyaratan kami. Misalnya:<\/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\">Bisakah Anda membuat Google Apps Script yang membaca data dari Google Sheet dan menghasilkan dokumen penawaran harga di Google Docs? Skrip tersebut harus melakukan hal berikut:<br><br>Baca data dari Google Sheet yang berisi kolom-kolom berikut: Nama Perusahaan, ID Perusahaan, Kontak Person, Email Kontak, Item, Harga, Kuantitas, dan Total Harga.<br><br>Buat dokumen penawaran terpisah untuk setiap perusahaan yang terdapat dalam lembar kerja.<br><br>Pada setiap dokumen, sertakan informasi perusahaan (Nama Perusahaan, ID Perusahaan, Nama Kontak, Email Kontak) satu kali di bagian awal.<br>Sertakan data produk (Item, Harga, Kuantitas, Harga Total) dalam format tabel di dalam dokumen.<br><br>Proses satu baris demi satu baris dan tandai setiap baris yang telah diproses dengan &#039;selesai&#039; di kolom baru.<br><br>Buat skrip dapat diakses dari menu khusus di Google Sheet agar mudah dijalankan.<br><br>Pastikan skrip menangani kasus di mana beberapa baris data berasal dari perusahaan yang sama dan membuat satu dokumen penawaran harga untuk perusahaan tersebut.<br><br>Selain itu, pastikan skrip dapat dieksekusi langsung dari Google Sheet menggunakan menu khusus.<\/p><\/div>\n<\/div><\/div><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">ChatGPT kemudian akan menghasilkan skrip berdasarkan perintah kita. Berikut contoh kodenya:<\/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;); \/\/ Tambahkan kolom &#039;Done&#039; jika belum ada doneColumn = headers.length; } for (var i = 1; i &lt; numRows; i++) { if (values[i][doneColumn] !== &#039;done&#039;) { \/\/ Periksa apakah baris belum ditandai sebagai &#039;selesai&#039; var companyData = {}; var companyName = values[i][headers.indexOf(&#039;Nama Perusahaan&#039;)]; var companyID = values[i][headers.indexOf(&#039;ID Perusahaan&#039;)]; var contactPerson = values[i][headers.indexOf(&#039;Kontak Person&#039;)]; var contactEmail = values[i][headers.indexOf(&#039;Email Kontak&#039;)]; var products = []; \/\/ Buat objek data perusahaan companyData[&#039;Nama Perusahaan&#039;] = companyName; companyData[&#039;ID Perusahaan&#039;] = companyID; companyData[&#039;Kontak Person&#039;] = contactPerson; companyData[&#039;Email Kontak&#039;] = contactEmail; \/\/ Iterasi melalui baris dengan informasi perusahaan yang sama while (i &lt; numRows &amp;&amp; values[i][headers.indexOf(&#039;Nama Perusahaan&#039;)] === companyName) { var item = values[i][headers.indexOf(&#039;Item&#039;)]; var price = values[i][headers.indexOf(&#039;Harga&#039;)]; var quantity = values[i][headers.indexOf(&#039;Kuantitas&#039;)]; var totalPrice = values[i][headers.indexOf(&#039;Total Harga&#039;)]; products.push([item, price, quantity, totalPrice]); sheet.getRange(i + 1, doneColumn + 1).setValue(&#039;done&#039;); \/\/ Tandai baris sebagai &#039;selesai&#039; i++; } \/\/ Buat Google Document baru untuk penawaran var doc = DocumentApp.create(&#039;Penawaran untuk &#039; + companyName); var document = DocumentApp.openById(doc.getId()); var body = document.getBody(); \/\/ Tambahkan data perusahaan ke dokumen body.appendParagraph(&#039;Nama Perusahaan: &#039; + companyName); body.appendParagraph(&#039;ID Perusahaan: &#039; + companyID); body.appendParagraph(&#039;Kontak Person: &#039; + contactPerson); body.appendParagraph(&#039;Email Kontak: &#039; + contactEmail); \/\/ Tambahkan data produk dalam format tabel var table = []; table.push([&#039;Item&#039;, &#039;Harga&#039;, &#039;Jumlah&#039;, &#039;Total Harga&#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>Langkah 3: Menerapkan Skrip<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=\"templat 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\">Setelah kita memiliki skrip, kita akan mengimplementasikannya di Google Sheet kita. Ini melibatkan menyalin skrip ke editor skrip di Google Sheets (Ekstensi &gt; Apps Script) dan menjalankan skrip tersebut.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk menjalankan skrip ini, ikuti langkah-langkah berikut:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Buka Google Sheet Anda dan isi data penawaran harga.<\/li>\n\n\n\n<li>Klik \u201cEkstensi\u201d -&gt; \u201cApps Script\u201d untuk membuka editor skrip.&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 class=\"wp-block-paragraph\">3. Tempelkan kode contoh ke dalam editor skrip.&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. Di editor Apps Script, klik ikon disket untuk menyimpan perubahan Anda.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. Jalankan&nbsp;<strong>Buat Kutipan<\/strong>&nbsp;jalankan fungsi dengan mengklik \u201cJalankan\u201d dengan tombol putar \u25b6\ufe0f.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6. Selesaikan proses otorisasi agar App Script dapat memproses data Anda.<\/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=\"Implementasi Skrip Lengkap\" 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>Langkah 4: Meninjau Hasil<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Terakhir, kita akan meninjau hasilnya. Setelah skrip berhasil dijalankan, Anda akan melihat &quot;Menu Kustom&quot; ditambahkan ke bilah menu Google Sheet Anda. Klik &quot;Menu Kustom,&quot; dan Anda akan menemukan opsi &quot;Buat Penawaran&quot;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Jika Anda mengklik \u201cBuat Penawaran\u201d untuk menjalankan skrip, maka skrip tersebut akan membuat dokumen penawaran terpisah untuk setiap perusahaan dengan struktur yang ditentukan.<\/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=\"Dokumen Google berisi lembar penawaran harga\" 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\">Jika semuanya telah disiapkan dengan benar, kita seharusnya sekarang memiliki Dokumen Google yang berisi lembar penawaran berdasarkan data di Google Sheet kita. Setiap baris yang diproses di Google Sheet akan ditandai dengan &#039;selesai&#039; di kolom baru.<\/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=\"Dokumen Penawaran\" 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>Cara yang Lebih Efisien: Membuat Penawaran Harga dengan Templat Cetak Kustom Jodoo<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Membuat penawaran penjualan adalah bagian penting dari setiap proses bisnis. Karena itulah\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>\u00a0telah mendukung pembuatan penawaran harga atau dokumen BPM lainnya dengan menyediakan\u00a0<a href=\"https:\/\/help.jodoo.com\/en\/articles\/10005821-print-templates\" target=\"_blank\" rel=\"noreferrer noopener\">templat cetak khusus<\/a>\u00a0fungsi. Dengan Jodoo, proses ini disederhanakan dan dibuat lebih efisien.<\/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>Bagaimana cara membuat template cetak kustom di Jodoo?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Berikut panduan langkah demi langkah tentang cara membuat penawaran penjualan menggunakan Jodoo:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Pilih formulir yang mengumpulkan data penawaran Anda dan klik\u00a0<a href=\"https:\/\/help.jodoo.com\/doc\/17191#editingform\" target=\"_blank\" rel=\"noreferrer noopener\">Edit<\/a>. Jika Anda belum memilikinya, coba milik kami.\u00a0<a href=\"https:\/\/www.jodoo.com\/template\/order-and-inventory-management-65b0bdde4c02dd632333a55a\" target=\"_blank\" rel=\"noreferrer noopener\">Manajemen Pesanan dan Inventaris<\/a>\u00a0templat.<\/li>\n\n\n\n<li>Buka Ekstensi &gt; Templat Cetak dan klik Templat Cetak Baru.&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=\"Templat Cetak\" 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. Pada halaman desain templat, sesuaikan nama templat menjadi sesuatu seperti \u201cTemplat Penawaran Penjualan.\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\">Tambahkan kolom yang diperlukan<\/a>, seperti nama produk, kuantitas, harga, dan total. Kolom-kolom ini akan terisi secara otomatis dengan data dari formulir Anda.&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=\"Seret dan Lepas Bidang\" 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. Setelah templat Anda siap, Anda dapat membuat penawaran penjualan hanya dengan memilih data dan mengklik tombol cetak.&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/15008#permissionsetsandmanagedata\" target=\"_blank\" rel=\"noreferrer noopener\">Komputer<\/a>&nbsp;atau&nbsp;<a href=\"https:\/\/help.jodoo.com\/doc\/12010\" target=\"_blank\" rel=\"noreferrer noopener\">ponsel<\/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=\"Pencetakan\" 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>Apa saja manfaat menggunakan Jodoo untuk membuat dokumen bisnis seperti penawaran harga dan faktur?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Sekarang, mari kita bandingkan proses ini dengan menggunakan Google Sheets dan Google Docs. Meskipun alat-alat ini serbaguna dan banyak digunakan, mereka kurang memiliki fitur otomatisasi dan kustomisasi yang ditawarkan oleh Jodoo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Google Apps Script memang memungkinkan otomatisasi di dalam Google Workspace, menjadikan Google Sheets sebagai alat yang lebih ampuh. Namun, bahkan dengan otomatisasi ini, masih ada beberapa area di mana Jodoo unggul.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Kemudahan Penggunaan<\/strong>Meskipun Google Apps Script sangat ampuh, ia membutuhkan pengetahuan pemrograman untuk pengaturan dan pemeliharaannya. Hal ini dapat menjadi kendala bagi pengguna non-teknis. Di sisi lain, antarmuka Jodoo intuitif dan ramah pengguna, memungkinkan siapa pun untuk membuat dan mengelola penawaran penjualan tanpa perlu menulis satu baris kode pun.<\/li>\n\n\n\n<li><strong>Integrasi<\/strong>Jodoo dirancang untuk bekerja secara mulus dengan bagian lain dari proses bisnis Anda. Data dari formulir, basis data, dan sumber lain dapat dengan mudah dihubungkan dan diperbarui secara real-time. Meskipun Google Apps Script dapat digunakan untuk membuat integrasi serupa, hal itu membutuhkan lebih banyak upaya dan keahlian teknis.<\/li>\n\n\n\n<li><strong>Kustomisasi<\/strong>Templat cetak khusus Jodoo menawarkan tingkat kustomisasi yang tinggi. Anda dapat dengan mudah menyesuaikan tata letak, menambahkan gambar, dan menyertakan bidang khusus. Meskipun Google Apps Script memungkinkan kustomisasi, seringkali lebih kompleks dan memakan waktu untuk mencapai tingkat detail yang sama.<\/li>\n\n\n\n<li><strong>Skalabilitas<\/strong>Seiring pertumbuhan bisnis Anda, kompleksitas proses Anda juga meningkat. Jodoo dirancang untuk menangani pertumbuhan ini, memungkinkan Anda untuk dengan mudah mengelola dan mengotomatiskan sejumlah besar data. Meskipun Google Apps Script dapat diskalakan, seringkali membutuhkan lebih banyak pemeliharaan dan pemecahan masalah seiring meningkatnya kompleksitas.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Kesimpulannya, meskipun Google Apps Script meningkatkan kemampuan Google Sheets dan ChatGPT dapat membantu kita menulis Apps Script, Jodoo tetap menawarkan solusi yang lebih ramah pengguna, terintegrasi, dapat disesuaikan, dan terukur untuk menghasilkan penawaran penjualan dan dokumen bisnis lainnya.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Kesimpulan<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kesimpulannya, munculnya AI dan integrasinya ke dalam proses bisnis telah merevolusi cara kita bekerja. Penggunaan model bahasa tingkat lanjut seperti ChatGPT bersamaan dengan Google Apps Script telah menunjukkan hasil yang menjanjikan dalam mengotomatisasi tugas-tugas seperti menghasilkan dokumen penawaran harga dari data Google Sheets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Namun, platform seperti <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> Telah melangkah lebih jauh, menawarkan solusi yang lebih ramah pengguna, terintegrasi, dapat disesuaikan, dan dapat diskalakan. Masa depan otomatisasi proses bisnis telah tiba, dan jelas bahwa AI akan memainkan peran penting dalam membentuknya. Seiring kita terus mengeksplorasi dan memanfaatkan potensi AI, kita dapat menantikan cara-cara yang lebih efisien, ramping, dan inovatif untuk menjalankan bisnis.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Pelajari cara mengotomatiskan pembuatan penawaran harga dengan ChatGPT dan Google Apps Script. Temukan alur kerja yang efisien dan bandingkan dengan templat cetak khusus 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 v27.6 - 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\/id-id\/ai-untuk-pembuatan-penawaran-harga\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\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\/id-id\/ai-untuk-pembuatan-penawaran-harga\/\" \/>\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=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jodoo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 menit\" \/>\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\":\"id\"},{\"@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\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/ai-for-quotation-generation\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@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\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.jodoo.com\\\/blog\\\/#\\\/schema\\\/person\\\/b958cef486b1eb00d0f82e6f0a294481\",\"name\":\"Jodoo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@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\\\/id-id\\\/author\\\/wp-admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AI untuk Pembuatan Penawaran Harga: Panduan dengan Google Apps Script dan ChatGPT Prompt - Blog Jodoo","description":"Pelajari cara mengotomatiskan pembuatan penawaran harga dengan ChatGPT dan Google Apps Script. Temukan alur kerja yang efisien dan bandingkan dengan templat cetak khusus 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\/id-id\/ai-untuk-pembuatan-penawaran-harga\/","og_locale":"id_ID","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\/id-id\/ai-untuk-pembuatan-penawaran-harga\/","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":{"Ditulis oleh":"Jodoo","Estimasi waktu membaca":"8 menit"},"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":"id"},{"@type":"WebPage","@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation","url":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation","name":"AI untuk Pembuatan Penawaran Harga: Panduan dengan Google Apps Script dan 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":"Pelajari cara mengotomatiskan pembuatan penawaran harga dengan ChatGPT dan Google Apps Script. Temukan alur kerja yang efisien dan bandingkan dengan templat cetak khusus Jodoo.","breadcrumb":{"@id":"https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jodoo.com\/blog\/ai-for-quotation-generation"]}]},{"@type":"ImageObject","inLanguage":"id","@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":"Dapatkan informasi terbaru tentang pengembangan tanpa kode, pembaruan, acara, dan berita lainnya tentang 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":"id"},{"@type":"Person","@id":"https:\/\/www.jodoo.com\/blog\/#\/schema\/person\/b958cef486b1eb00d0f82e6f0a294481","name":"Jodoo","image":{"@type":"ImageObject","inLanguage":"id","@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\/id-id\/author\/wp-admin"}]}},"_links":{"self":[{"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/posts\/4885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/comments?post=4885"}],"version-history":[{"count":5,"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/posts\/4885\/revisions"}],"predecessor-version":[{"id":5290,"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/posts\/4885\/revisions\/5290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/media\/4707"}],"wp:attachment":[{"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/media?parent=4885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/categories?post=4885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jodoo.com\/blog\/id-id\/wp-json\/wp\/v2\/tags?post=4885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}