{"id":53,"date":"2023-02-22T21:09:01","date_gmt":"2023-02-22T14:09:01","guid":{"rendered":"https:\/\/onesender.net\/docs\/?page_id=53"},"modified":"2023-02-22T21:09:02","modified_gmt":"2023-02-22T14:09:02","slug":"google-spreadsheet","status":"publish","type":"page","link":"https:\/\/onesender.net\/docs\/integrasi\/google-spreadsheet\/","title":{"rendered":"Google Spreadsheet"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">OneSender dapat digunakan untuk mengirim pesan dari Google Spreadsheet. Integrasi ini menggunakan script yang dapat diunduh di memberarea.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Skrip integrasi akan menambahkan menu <strong>OneSender<\/strong> di daftar menu.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Template pengiriman dan sheet pengaturan akan dibuat otomatis oleh menu ini.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Info penting<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Harap tidak mengubah lokasi cell\/row sheet <strong>onesender_setting<\/strong>.<\/li>\n\n\n\n<li>Kolom whatsapp berada di kolom ke-3. Harap tidak menubah urutan ini.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Berikut ini langkah-langkah integrasi:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1\">1. Unduh file script integrasi<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Silahkan masuk ke <a href=\"https:\/\/onesender.net\/my-account\/\">member area<\/a>.<\/li>\n\n\n\n<li>Unduh file integrasi GoogleSpreadsheet<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-1.png\" alt=\"Member Area\" title=\"File integrasi\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2\">2. Buat dokumen Spreadsheet kosong<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-2.png\" alt=\"Google Spreadsheet\" title=\"Google Spreadsheet\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3\">3. Masukkan skrip integrasi ke SpreadSheet<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Klik menu <code>Ekstensi<\/code> -&gt; <code>App Script<\/code>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-3.png\" alt=\"Google Spreadsheet\" title=\"Google Spreadsheet\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Setelah dialog AppScript muncul masukkan kode integrasi di file <code>google_spreadsheet_v4_1.js<\/code>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-4.png\" alt=\"Google Spreadsheet\" title=\"Dialog app script\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Simpan scipt integrasi dengan klik tombol <code>save<\/code>.<\/li>\n\n\n\n<li>Kembali ke tab Spreadsheet lalu refresh halaman. Silahkan tunggu sekitar 1 menit. Menu baru <code>OneSender<\/code> akan muncul.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-5.png\" alt=\"Google Spreadsheet\" title=\"Menu OneSender\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ketika refresh halaman, kadang muncul permintaan untuk otorisasi script. Silahkan izinkan akses script seperti contoh di video berikut:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-embed-handler wp-block-embed-embed-handler wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"onesender 2022 07 08 10 48 58\" width=\"1200\" height=\"900\" src=\"https:\/\/www.youtube.com\/embed\/whUU5wqMB-c?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-4\">4. Buat sheet pengiriman dan setting<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Menu OneSender menyediakan beberapa pilihan.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>Kirim Pesan<\/code> untuk mengirim pesan.<\/li>\n\n\n\n<li><code>Create setting text<\/code> utuk membuat template pengiriman dan setting pengiriman secara otomatis.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-6.png\" alt=\"Google Spreadsheet\" title=\"Tab\/sheet pengiriman dan setting muncul\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-5\">5. Isi sheet pengaturan<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Silahkan Isi setting di sheet <code>onesender_setting<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-7.png\" alt=\"Google Spreadsheet\" title=\"Sheet Pengaturan\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Silahkan isi bagian setting yang diperlukan. Dalam contoh di atas, diwarnai dengan warna merah. Untuk pesan text dan gambar, setting lebih sederhana.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-5\">6. Kirim Pesan<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Isi data pengiriman. Tiga kolom paling depan tidak boleh dihapus atau diubah.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-9.png\" alt=\"Google Spreadsheet\" title=\"Tiga kolom pertama diperlukan oleh system\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Klik menu <code>OneSender<\/code> -&gt; <code>Kirim Pesan<\/code>.<\/li>\n\n\n\n<li>Skrip akan membaca baris demi baris. Setiap pesan yang berhasil dikirim akan ditandai dengan status pengiriman <code>done<\/code>.<\/li>\n\n\n\n<li>Anda dapat menggunakan shortcode yang bisa dimasukkan ke pesan dengan tag <code>{column_4}<\/code>. Ganti nomor empat dengan urutan kolom cell.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Contoh template pesan<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Hello, {column_1}\n\nIni adalah contoh pesan Gambar dan link.\n\nIni data di kolom:\nNama: {column_4}\nAlamat: {column_5}\n\nSelesai\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Contoh hasil pengiriman pesan<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/onesender.net\/docs-v1\/uploads\/spreadsheet\/google-spreadsheet-8.png\" alt=\"Google Spreadsheet\" title=\"Hasil pengiriman pesan\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>OneSender dapat digunakan untuk mengirim pesan dari Google Spreadsheet. Integrasi ini menggunakan script yang dapat diunduh di memberarea. Skrip integrasi akan menambahkan menu OneSender di daftar menu. Template pengiriman dan sheet pengaturan akan dibuat otomatis oleh menu ini. Info penting Berikut ini langkah-langkah integrasi: 1. Unduh file script integrasi 2. Buat dokumen Spreadsheet kosong 3. &#8230; <a title=\"Google Spreadsheet\" class=\"read-more\" href=\"https:\/\/onesender.net\/docs\/integrasi\/google-spreadsheet\/\" aria-label=\"Read more about Google Spreadsheet\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":33,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-53","page","type-page","status-publish"],"_links":{"self":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/53","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/comments?post=53"}],"version-history":[{"count":2,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/53\/revisions"}],"predecessor-version":[{"id":56,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/53\/revisions\/56"}],"up":[{"embeddable":true,"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/pages\/33"}],"wp:attachment":[{"href":"https:\/\/onesender.net\/docs\/wp-json\/wp\/v2\/media?parent=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}