Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah<\/title><br \/>\n<\/head><br \/>\n<body><\/p>\n<h1 id=\"google-sheets-automation-cod-confirmation-whatsapp-cara-langkah-demi-langkah\">Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah<\/h1>\n<ul class=\"key-takeaways\">\n<li>Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual.<\/li>\n<li>Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update status & tracking.<\/li>\n<li>Gunakan provider WhatsApp API (Twilio \/ 360dialog \/ WATI) dan perhatikan template yang harus disetujui.<\/li>\n<\/ul>\n<nav class=\"toc\" aria-label=\"Daftar isi\">\n <strong>Daftar isi<\/strong><\/p>\n<ul>\n<li><a href=\"#untuk-siapa-artikel-ini\">Untuk siapa artikel ini<\/a><\/li>\n<li><a href=\"#gambaran-teknis-arsitektur-alur-cod-confirmation-flow\">Gambaran teknis & arsitektur alur<\/a><\/li>\n<li><a href=\"#pra-syarat-bahan-yang-perlu-disiapkan\">Pra\u2011syarat & bahan yang perlu disiapkan<\/a><\/li>\n<li><a href=\"#langkah-0-siapkan-google-sheets-template-kolom\">Langkah 0 \u2014 Siapkan Google Sheets (template & kolom)<\/a><\/li>\n<li><a href=\"#langkah-1-buat-webhook-di-shopify-woocommerce\">Langkah 1 \u2014 Buat webhook di Shopify \/ WooCommerce<\/a><\/li>\n<li><a href=\"#langkah-2-siapkan-google-sheets-apps-script-sebagai-penerima-webhook\">Langkah 2 \u2014 Siapkan Google Sheets & Apps Script sebagai penerima webhook<\/a><\/li>\n<li><a href=\"#langkah-3-deteksi-order-cod-enqueue-pengiriman\">Langkah 3 \u2014 Deteksi order COD & enqueue pengiriman pesan<\/a><\/li>\n<li><a href=\"#langkah-4-kirim-cod-confirmation-via-whatsapp-api\">Langkah 4 \u2014 Kirim COD confirmation via WhatsApp API<\/a><\/li>\n<li><a href=\"#langkah-5-menangani-inbound-replies-confirmation-flow\">Langkah 5 \u2014 Menangani inbound replies<\/a><\/li>\n<li><a href=\"#langkah-6-update-tracking-sinkronisasi-order-status\">Langkah 6 \u2014 Update tracking & sinkronisasi order status<\/a><\/li>\n<li><a href=\"#langkah-7-otomatisasi-lanjutan-best-practices\">Langkah 7 \u2014 Otomatisasi lanjutan & best practices teknis<\/a><\/li>\n<li><a href=\"#contoh-kode-payload\">Contoh kode & payload<\/a><\/li>\n<li><a href=\"#contoh-payloads-template-pesan\">Contoh payloads & template pesan<\/a><\/li>\n<li><a href=\"#error-handling-troubleshooting-umum\">Error handling & troubleshooting umum<\/a><\/li>\n<li><a href=\"#keamanan-privasi-data\">Keamanan & privasi data<\/a><\/li>\n<li><a href=\"#monitoring-reporting-scaling-operasional\">Monitoring, reporting & scaling operasional<\/a><\/li>\n<li><a href=\"#checklist-implementasi\">Checklist implementasi<\/a><\/li>\n<li><a href=\"#contoh-skenario-end-to-end\">Contoh skenario end\u2011to\u2011end<\/a><\/li>\n<li><a href=\"#faq\">FAQ singkat<\/a><\/li>\n<li><a href=\"#best-practices-rekomendasi-operasional\">Best practices & rekomendasi operasional<\/a><\/li>\n<li><a href=\"#resources-pembelajaran-tambahan\">Resources & pembelajaran tambahan<\/a><\/li>\n<li><a href=\"#mengapa-inreality-solutions-cocok-untuk-proyek-otomasi-ini\">Mengapa InReality Solutions cocok untuk proyek Otomasi ini<\/a><\/li>\n<li><a href=\"#call-to-action-konsultasi-demo-implementasi\">Call to Action \u2014 Konsultasi & Demo Implementasi<\/a><\/li>\n<\/ul>\n<\/nav>\n<h2 id=\"untuk-siapa-artikel-ini\">Untuk siapa artikel ini (cara google sheets workflow)<\/h2>\n<p>Artikel ini ditujukan untuk pemilik toko online (Shopify\/WooCommerce), head of operations, marketing manager, dan developer ringan\/IT ops. Hasil yang diharapkan: konfirmasi COD otomatis via WhatsApp, update order status (Siap Kirim \/ Dibatalkan), dan pengiriman notifikasi tracking. Use case: e\u2011commerce retail, showroom, marketplace lokal; catatan pasar Indonesia: COD masih populer dan pastikan format nomor +62.<\/p>\n<h2 id=\"gambaran-teknis-arsitektur-alur-cod-confirmation-flow\">Gambaran teknis & arsitektur alur (cod confirmation flow)<\/h2>\n<p>Diagram alur (sertakan PNG\/SVG saat publish):<\/p>\n<p><img decoding=\"async\" data-src=\"path-to-diagram.png\" alt=\"Diagram alur COD confirmation flow\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" class=\"lazyload\"><noscript><img decoding=\"async\" src=\"path-to-diagram.png\" alt=\"Diagram alur COD confirmation flow\"><\/noscript><\/p>\n<ul>\n<li>Shopify\/WooCommerce webhook \u2192 Google Apps Script (doPost) \u2192 tulis ke Google Sheets (queue)<\/li>\n<li>Apps Script memfilter payment_method == “COD” \u2192 kirim pesan via WhatsApp API (Twilio\/360dialog\/WATI). Lihat dokumentasi provider seperti <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio WhatsApp<\/a>, <a href=\"https:\/\/docs.360dialog.com\/\">360dialog<\/a>, atau <a href=\"https:\/\/docs.wati.io\/\">WATI<\/a>.<\/li>\n<li>Inbound webhook dari provider WA \u2192 Apps Script \u2192 update Sheet \u2192 optional call API ke Shopify\/WooCommerce untuk update order<\/li>\n<\/ul>\n<p>Referensi webhook Shopify: <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\">Shopify webhooks<\/a>. Referensi webhook WooCommerce: <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">WooCommerce webhooks<\/a>. Panduan Apps Script Web Apps: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/web\">Apps Script Web Apps<\/a>. WhatsApp Business API docs: <a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\">WhatsApp Business API<\/a>.<\/p>\n<h2 id=\"pra-syarat-bahan-yang-perlu-disipkan\">Pra\u2011syarat & bahan yang perlu disiapkan (google sheets tutorial)<\/h2>\n<ul>\n<li>Admin Shopify \/ WooCommerce dengan akses buat webhook (lihat <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\">Shopify<\/a> \/ <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">WooCommerce<\/a>).<\/li>\n<li>Google Account & Google Sheets; akses Apps Script (lihat <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/sheets\">Apps Script Sheets guide<\/a>).<\/li>\n<li>Akun provider WhatsApp API: <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio<\/a>, <a href=\"https:\/\/docs.360dialog.com\/\">360dialog<\/a>, atau <a href=\"https:\/\/docs.wati.io\/\">WATI<\/a>. Pastikan template pesan WA sudah disetujui (<a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\/message-templates\">WA message templates<\/a>).<\/li>\n<li>Kredensial API dan URL inbound webhook untuk menerima reply.<\/li>\n<li>Opsional: middleware\/no\u2011code \u2014 Zapier (<a href=\"https:\/\/zapier.com\/apps\/google-sheets\/integrations\">Zapier Google Sheets integrations<\/a>) atau Make (<a href=\"https:\/\/www.make.com\/en\/compare\">Make comparison<\/a>).<\/li>\n<\/ul>\n<p>Catatan: nomor Indonesia gunakan format +62; pastikan template pesan WA sudah disetujui oleh provider.<\/p>\n<h2 id=\"langkah-0-siapkan-google-sheets-template-kolom\">Langkah 0 \u2014 Siapkan Google Sheets (template & kolom) (google sheets automation)<\/h2>\n<p>Rekomendasi kolom:<\/p>\n<p><strong>Order ID | Customer | Phone | Order date | Payment method | Order status | COD confirmation | Confirmation TTL | Tracking | Last updated | Notes<\/strong><\/p>\n<p>Contoh formula: timestamp saat update:<\/p>\n<pre><code>=IF(A2<>\"\",IF(B2=\"\",NOW(),B2), \"\")<\/code><\/pre>\n<p>Sertakan conditional formatting untuk status Pending \/ Confirmed \/ Cancelled. (Sertakan screenshot CSV sebagai asset saat publish.)<\/p>\n<h2 id=\"langkah-1-buat-webhook-di-shopify-woocommerce\">Langkah 1 \u2014 Buat webhook di Shopify \/ WooCommerce (webhook shopify\/woocommerce)<\/h2>\n<p>Shopify: Admin \u2192 Settings \u2192 Notifications \u2192 Create webhook (lihat <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\/creating-webhooks\">dokumentasi Shopify membuat webhook<\/a>).<\/p>\n<p>WooCommerce: WooCommerce \u2192 Settings \u2192 Advanced \u2192 Webhooks (lihat <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">dokumentasi WooCommerce webhooks<\/a>).<\/p>\n<p>Contoh payload minimal (JSON, Shopify):<\/p>\n<pre><code>{\n \"id\": 12345,\n \"email\": \"customer@example.com\",\n \"billing_address\": { \"phone\": \"+628123456789\" },\n \"payment_gateway_names\": [\"COD\"],\n \"created_at\": \"2024-01-01T10:00:00Z\"\n}<\/code><\/pre>\n<p>Nota: nomor telepon sering ada di billing.phone \u2192 cek format.<\/p>\n<h2 id=\"langkah-2-siapkan-google-sheets-apps-script-sebagai-penerima-webhook\">Langkah 2 \u2014 Siapkan Google Sheets & Apps Script sebagai penerima webhook (cara google sheets workflow)<\/h2>\n<p>Deploy Apps Script sebagai Web App (doPost) untuk menerima webhook, parse JSON, validasi, dan tulis ke sheet. Panduan deploy: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/web\">Apps Script Web Apps<\/a>.<\/p>\n<h3 id=\"struktur-permission\">Struktur & permission<\/h3>\n<ul>\n<li>Struktur: Script project \u2192 .gs files \u2192 Libraries (opsional)<\/li>\n<li>Deploy: Publish \u2192 Deploy as web app \u2192 Execute as: Me \u2192 Who has access: Anyone (atau hanya tertentu jika menggunakan middleware)<\/li>\n<\/ul>\n<p>Contoh skeleton doPost(e):<\/p>\n<pre><code>\/\/ doPost handler - terima webhook\nfunction doPost(e) {\n var payload = JSON.parse(e.postData.contents);\n \/\/ validasi minimal\n if (!payload || !payload.id) return ContentService.createTextOutput('nok');\n \/\/ tulis ke sheet (implementasi lanjut)\n return ContentService.createTextOutput('ok');\n}<\/code><\/pre>\n<p>Referensi UrlFetchApp untuk panggilan HTTP: <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/url-fetch\/url-fetch-app\">UrlFetchApp<\/a>.<\/p>\n<h2 id=\"langkah-3-deteksi-order-cod-enqueue-pengiriman\">Langkah 3 \u2014 Deteksi order COD & enqueue pengiriman pesan (cod confirmation flow)<\/h2>\n<p>Filter jika payment_method contains “COD” \u2192 set COD confirmation = “Pending” dan set Confirmation TTL (timestamp + 24 jam). Hindari duplicate dengan cek Order ID atau unique composite (orderId+phone).<\/p>\n<p>Implementasikan pengecekan duplicate sebelum enqueue untuk menghindari kirim ganda.<\/p>\n<h2 id=\"langkah-4-kirim-cod-confirmation-via-whatsapp-api\">Langkah 4 \u2014 Kirim COD confirmation via WhatsApp API (cod confirmation whatsapp)<\/h2>\n<p>Contoh pesan (ID):<\/p>\n<p>“Halo {nama}, pesanan #{orderId} Anda terdaftar COD. Mohon balas YES untuk konfirmasi dalam 24 jam atau NO untuk batalkan. Terima kasih.”<\/p>\n<p>Contoh kirim memakai UrlFetchApp ke Twilio (lihat <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">Twilio WhatsApp API<\/a>):<\/p>\n<pre><code>function kirimWhatsApp(phone, message) {\n var url = \"https:\/\/api.twilio.com\/2010-04-01\/Accounts\/ACCOUNT_SID\/Messages.json\";\n var payload = {\n To: \"whatsapp:\" + phone,\n From: \"whatsapp:+1415XXXXXXX\",\n Body: message\n };\n var options = {\n method: \"post\",\n payload: payload,\n headers: { Authorization: \"Basic \" + Utilities.base64Encode(\"ACCOUNT_SID:AUTH_TOKEN\") }\n };\n var resp = UrlFetchApp.fetch(url, options);\n return resp.getContentText();\n}<\/code><\/pre>\n<p>Lihat juga dokumentasi <a href=\"https:\/\/docs.360dialog.com\/\">360dialog<\/a> dan aturan template WA di <a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\/message-templates\">Facebook\/WhatsApp templates<\/a>. Tips: atur rate\u2011limit, pakai template yang sudah disetujui, handle HTTP errors (429, 401).<\/p>\n<h2 id=\"langkah-5-menangani-inbound-replies-confirmation-flow\">Langkah 5 \u2014 Menangani inbound replies (confirmation flow)<\/h2>\n<p>Provider WA akan mem-forward pesan inbound ke webhook Anda (lihat <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/tutorial\/send-and-receive-media-messages-whatsapp\">Twilio inbound webhook<\/a> dan <a href=\"https:\/\/docs.360dialog.com\/\">360dialog inbound<\/a>). Parse body, cari kata kunci YES\/NO, lalu update row terkait \u2192 ubah Order status (Siap Kirim \/ Dibatalkan). Implementasikan reminder (24 jam) dan retry logic.<\/p>\n<p>State machine sederhana: Pending \u2192 (YES) Confirmed \u2192 Siap Kirim ; Pending \u2192 (no reply within TTL) \u2192 Reminder \u2192 Cancelled.<\/p>\n<h2 id=\"langkah-6-update-tracking-sinkronisasi-order-status\">Langkah 6 \u2014 Update tracking & sinkronisasi order status (order status, tracking)<\/h2>\n<p>Saat merchant memasukkan nomor resi di kolom Tracking \u2192 trigger script untuk kirim notifikasi WA dan (opsional) update ke Shopify\/WooCommerce via Orders API (Shopify: <a href=\"https:\/\/shopify.dev\/docs\/api\/admin-rest\/2023-10\/resources\/order\">Shopify Orders API<\/a> ; WooCommerce: <a href=\"https:\/\/woocommerce.github.io\/woocommerce-rest-api-docs\/#update-an-order\">WooCommerce Orders API<\/a>).<\/p>\n<p>Rekomendasi: mulai manual lewat sheet; otomatisasi API untuk skala besar.<\/p>\n<h2 id=\"langkah-7-otomatisasi-lanjutan-best-practices\">Langkah 7 \u2014 Otomatisasi lanjutan & best practices teknis (google sheets automation)<\/h2>\n<ul>\n<li>Retry\/backoff; reminder sequence 24h\/48h; fallback SMS\/email.<\/li>\n<li>Throttling & dead\u2011letter column (Notes).<\/li>\n<li>Migrasi ke DB \/ BigQuery saat volume tinggi (<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/overview\">BigQuery overview<\/a>).<\/li>\n<li>Make vs Zapier comparison: <a href=\"https:\/\/www.make.com\/en\/compare\">Make vs Zapier<\/a>.<\/li>\n<\/ul>\n<h2 id=\"contoh-kode-payload\">Contoh kode & payload (google sheets tutorial)<\/h2>\n<p>Contoh snippet yang sering digunakan:<\/p>\n<ul>\n<li>doPost(e) handler (lihat di atas)<\/li>\n<li>kirimWhatsApp(phone,message) (lihat di atas)<\/li>\n<li>inbound handler updateConfirmation(orderId, reply) \u2014 implementasi mirip: cari row by orderId, update kolom COD confirmation dan Order status.<\/li>\n<\/ul>\n<p>Sertakan link repo contoh di GitHub bila tersedia saat publish.<\/p>\n<h2 id=\"contoh-payloads-template-pesan\">Contoh payloads & template pesan<\/h2>\n<p>Shopify payload contoh: lihat contoh di Langkah 1. WooCommerce payload serupa (lihat <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">dokumentasi WooCommerce<\/a>).<\/p>\n<p>Inbound WA sample (JSON) disediakan di asset saat publish.<\/p>\n<p>Template pesan:<\/p>\n<ol>\n<li>Konfirmasi awal: “Halo {nama}, pesanan #{orderId} Anda terdaftar COD. Balas YES untuk konfirmasi dalam 24 jam.”<\/li>\n<li>Reminder 24 jam: “Pengingat: mohon konfirmasi pesanan #{orderId}. Balas YES\/NO.”<\/li>\n<\/ol>\n<p>Catatan: template WA butuh approval provider (<a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\/message-templates\">message templates<\/a>).<\/p>\n<h2 id=\"error-handling-troubleshooting-umum\">Error handling & troubleshooting umum (cara google sheets workflow)<\/h2>\n<ul>\n<li>Cek Apps Script logs\/executions: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/logging\">Apps Script logging<\/a>.<\/li>\n<li>Masalah umum: 403 permissions, JSON parse error, invalid phone, template not approved, 429 rate limit.<\/li>\n<li>Gunakan exponential backoff dan dead\u2011letter logging di kolom Notes.<\/li>\n<\/ul>\n<h2 id=\"keamanan-privasi-data\">Keamanan & privasi data (google sheets automation)<\/h2>\n<p>Simpan kredensial di PropertiesService (<a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a>) atau GCP Secret Manager (<a href=\"https:\/\/cloud.google.com\/secret-manager\">Secret Manager<\/a>). Batasi akses sheet dan audit trail. Untuk kepatuhan lokal (UU PDP), konsultasikan ke legal.<\/p>\n<h2 id=\"monitoring-reporting-scaling-operasional\">Monitoring, reporting & scaling operasional<\/h2>\n<p>Buat dashboard di Sheet (pivot\/summary) dengan metrik: pending count, confirmed %, cancelled %, avg time to confirm. Pertimbangkan migrasi ke DB\/BigQuery bila latency\/volume tinggi.<\/p>\n<h2 id=\"checklist-implementasi\">Checklist implementasi (google sheets automation)<\/h2>\n<ul>\n<li>[ ] Siapkan akun provider WA & nomor<\/li>\n<li>[ ] Buat webhook di Shopify\/WooCommerce<\/li>\n<li>[ ] Deploy Apps Script (doPost)<\/li>\n<li>[ ] Buat Sheet template & kolom mandatory<\/li>\n<li>[ ] Implement filter COD & enqueue<\/li>\n<li>[ ] Kirim WA template & handle inbound<\/li>\n<li>[ ] Update order status & tracking<\/li>\n<li>[ ] Monitoring & retry logic<\/li>\n<\/ul>\n<h2 id=\"contoh-skenario-end-to-end\">Contoh skenario end\u2011to\u2011end (cod confirmation flow, tracking)<\/h2>\n<ol>\n<li>Customer balas YES dalam 10 menit \u2192 update status Siap Kirim \u2192 merchant packing.<\/li>\n<li>No reply 24 jam \u2192 reminder \u2192 no reply 48 jam \u2192 auto\u2011cancel.<\/li>\n<li>Confirm YES \u2192 merchant input resi \u2192 otomatis kirim WA tracking.<\/li>\n<\/ol>\n<h2 id=\"faq\">FAQ singkat (google sheets tutorial, cara google sheets workflow)<\/h2>\n<section class=\"faq\">\n<div>\n<h3 id=\"faq-bisakah-pakai-zapier-make\">Bisakah pakai Zapier\/Make?<\/h3>\n<p>Ya \u2014 Zapier atau Make memudahkan integrasi tanpa coding, tetapi Apps Script memberi fleksibilitas lebih untuk custom logic dan kontrol biaya. Lihat <a href=\"https:\/\/zapier.com\/apps\/google-sheets\/integrations\">Zapier<\/a> dan <a href=\"https:\/\/www.make.com\/en\/compare\">Make<\/a>.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-multi-store\">Bagaimana kalau multi\u2011store?<\/h3>\n<p>Gunakan satu webhook per store atau sertakan store_id di payload untuk membedakan pesan dan sinkronisasi.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-biaya-whatsapp-api-limit\">Berapa biaya WhatsApp API & limit template?<\/h3>\n<p>Biaya bergantung provider. Cek pricing resmi Twilio: <a href=\"https:\/\/www.twilio.com\/pricing\">Twilio pricing<\/a> dan 360dialog: <a href=\"https:\/\/www.360dialog.com\/pricing\">360dialog pricing<\/a>.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-format-nomor-indonesia\">Format nomor Indonesia harus bagaimana?<\/h3>\n<p>Gunakan format internasional +62 dan validasi nomor sebelum kirim. Simpan nomor konsisten di Sheet untuk menghindari kegagalan pengiriman.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-apa-jika-template-belum-disetujui\">Apa yang terjadi jika template belum disetujui?<\/h3>\n<p>Pesan templated akan ditolak oleh provider; alternatif sementara: kirim SMS\/email atau kontak manual sampai template disetujui.<\/p>\n<\/p><\/div>\n<\/section>\n<h2 id=\"best-practices-rekomendasi-operasional\">Best practices & rekomendasi operasional (google sheets automation)<\/h2>\n<ul>\n<li>Pesan singkat, minta persetujuan eksplisit, audit trail, rate limiting.<\/li>\n<li>Format nomor +62, selalu sediakan fallback channel (telpon\/SMS\/email).<\/li>\n<li>Implementasikan monitoring dan dead\u2011letter untuk investigasi manual.<\/li>\n<\/ul>\n<h2 id=\"resources-pembelajaran-tambahan\">Resources & pembelajaran tambahan (google sheets tutorial)<\/h2>\n<ul>\n<li>Google Apps Script guides: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\">Apps Script guides<\/a><\/li>\n<li>Shopify webhooks: <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\">Shopify webhooks<\/a><\/li>\n<li>WooCommerce webhooks: <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">WooCommerce webhooks<\/a><\/li>\n<li>WhatsApp Business API: <a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\">WhatsApp Business API<\/a><\/li>\n<li>Twilio WhatsApp: <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio WhatsApp<\/a><\/li>\n<\/ul>\n<h2 id=\"mengapa-inreality-solutions-cocok-untuk-proyek-otomasi-ini\">Mengapa InReality Solutions cocok untuk proyek Otomasi ini<\/h2>\n<p>InReality Solutions memiliki keahlian di Otomasi AI & integrasi sistem untuk solusi end\u2011to\u2011end\u2014dari analisis proses sampai deployment dan operasional di pasar Indonesia. Kami menawarkan integrasi dengan CRM\/ERP, keamanan data, dan dukungan implementasi serta monitoring operasional. Lihat layanan kami: <a href=\"\/id\/layanan\/otomasi-ai\/\">\/layanan\/otomasi-ai<\/a> dan contoh kerja: <a href=\"\/id\/portofolio\/automasi-whatsapp\/\">\/portofolio\/automasi-whatsapp<\/a>.<\/p>\n<h2 id=\"call-to-action-konsultasi-demo-implementasi\">Call to Action \u2014 Konsultasi & Demo Implementasi<\/h2>\n<p>Butuh demo atau audit workflow COD Anda? Hubungi kami untuk konsultasi teknis atau demo implementasi. Kami kirimkan aset gratis: Google Sheets template + snippet Apps Script untuk percobaan. Ringkasan manfaat: Otomasi konfirmasi COD via Google Sheets + WhatsApp mengurangi beban follow\u2011up manual, mempercepat proses fulfillment, dan memberikan jejak audit yang jelas.<\/p>\n<p>Referensi tambahan dan contoh kasus tersedia di <a href=\"https:\/\/inrealitysolutions.com\/id\/kommo-crm-automation-cod-confirmation\/\">InReality Solutions \u2014 Kommo CRM Automation COD Confirmation<\/a> dan <a href=\"https:\/\/inrealitysolutions.com\/id\/mailchimp-automation-cod-confirmation-whatsapp\/\">Mailchimp Automation COD Confirmation WhatsApp<\/a>.<\/p>\n<p><\/body><br \/>\n<\/html><\/p>","protected":false},"excerpt":{"rendered":"<p>Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update […]<\/p>","protected":false},"author":16,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[170],"tags":[],"class_list":["post-9062","post","type-post","status-publish","format-standard","hentry","category-ai-automations"],"yoast_head":"\n<title>Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah\" \/>\n<meta property=\"og:description\" content=\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/\" \/>\n<meta property=\"og:site_name\" content=\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/InRealitySolutions\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-08T01:17:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-08T01:17:42+00:00\" \/>\n<meta name=\"author\" content=\"Maya Ananta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Maya Ananta\" \/>\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:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah\",\"datePublished\":\"2026-05-08T01:17:36+00:00\",\"dateModified\":\"2026-05-08T01:17:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\"},\"wordCount\":1464,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\",\"url\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\",\"name\":\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"datePublished\":\"2026-05-08T01:17:36+00:00\",\"dateModified\":\"2026-05-08T01:17:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\",\"url\":\"https:\/\/inrealitysolutions.com\/id\/\",\"name\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"description\":\"Transforming Businesses Through AR\/VR, Virtual Tours & AI Innovation\",\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/inrealitysolutions.com\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\",\"name\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"url\":\"https:\/\/inrealitysolutions.com\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png\",\"contentUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png\",\"width\":1006,\"height\":319,\"caption\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/InRealitySolutions\/\",\"https:\/\/www.linkedin.com\/company\/inreality-solutions\/\",\"https:\/\/www.instagram.com\/inreality_solutions\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\",\"name\":\"Maya Ananta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g\",\"caption\":\"Maya Ananta\"},\"url\":\"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/\"}]}<\/script>\n","yoast_head_json":{"title":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","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:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah","og_description":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update […]","og_url":"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/","og_site_name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","article_publisher":"https:\/\/www.facebook.com\/InRealitySolutions\/","article_published_time":"2026-05-08T01:17:36+00:00","article_modified_time":"2026-05-08T01:17:42+00:00","author":"Maya Ananta","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Maya Ananta","Estimasi waktu membaca":"8 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah","datePublished":"2026-05-08T01:17:36+00:00","dateModified":"2026-05-08T01:17:42+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"},"wordCount":1464,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/","url":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/","name":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"datePublished":"2026-05-08T01:17:36+00:00","dateModified":"2026-05-08T01:17:42+00:00","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah"}]},{"@type":"WebSite","@id":"https:\/\/inrealitysolutions.com\/id\/#website","url":"https:\/\/inrealitysolutions.com\/id\/","name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","description":"Transforming Businesses Through AR\/VR, Virtual Tours & AI Innovation","publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/inrealitysolutions.com\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/inrealitysolutions.com\/id\/#organization","name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","url":"https:\/\/inrealitysolutions.com\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/","url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png","contentUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png","width":1006,"height":319,"caption":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia"},"image":{"@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/InRealitySolutions\/","https:\/\/www.linkedin.com\/company\/inreality-solutions\/","https:\/\/www.instagram.com\/inreality_solutions\/"]},{"@type":"Person","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a","name":"Maya Ananta","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g","caption":"Maya Ananta"},"url":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"trp-custom-language-flag":false},"uagb_author_info":{"display_name":"Maya Ananta","author_link":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"},"uagb_comment_info":0,"uagb_excerpt":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update…","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/comments?post=9062"}],"version-history":[{"count":1,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062\/revisions"}],"predecessor-version":[{"id":9063,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062\/revisions\/9063"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=9062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=9062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=9062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":9062,"date":"2026-05-08T08:17:36","date_gmt":"2026-05-08T01:17:36","guid":{"rendered":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"},"modified":"2026-05-08T08:17:42","modified_gmt":"2026-05-08T01:17:42","slug":"google-sheets-automation-cod-confirmation","status":"publish","type":"post","link":"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/","title":{"rendered":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah"},"content":{"rendered":"

$\"Cover$
\n
\n
\n
\n
\n Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah<\/title><br \/>\n<\/head><br \/>\n<body><\/p>\n<h1 id=\"google-sheets-automation-cod-confirmation-whatsapp-cara-langkah-demi-langkah\">Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah<\/h1>\n<ul class=\"key-takeaways\">\n<li>Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual.<\/li>\n<li>Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update status & tracking.<\/li>\n<li>Gunakan provider WhatsApp API (Twilio \/ 360dialog \/ WATI) dan perhatikan template yang harus disetujui.<\/li>\n<\/ul>\n<nav class=\"toc\" aria-label=\"Daftar isi\">\n <strong>Daftar isi<\/strong><\/p>\n<ul>\n<li><a href=\"#untuk-siapa-artikel-ini\">Untuk siapa artikel ini<\/a><\/li>\n<li><a href=\"#gambaran-teknis-arsitektur-alur-cod-confirmation-flow\">Gambaran teknis & arsitektur alur<\/a><\/li>\n<li><a href=\"#pra-syarat-bahan-yang-perlu-disiapkan\">Pra\u2011syarat & bahan yang perlu disiapkan<\/a><\/li>\n<li><a href=\"#langkah-0-siapkan-google-sheets-template-kolom\">Langkah 0 \u2014 Siapkan Google Sheets (template & kolom)<\/a><\/li>\n<li><a href=\"#langkah-1-buat-webhook-di-shopify-woocommerce\">Langkah 1 \u2014 Buat webhook di Shopify \/ WooCommerce<\/a><\/li>\n<li><a href=\"#langkah-2-siapkan-google-sheets-apps-script-sebagai-penerima-webhook\">Langkah 2 \u2014 Siapkan Google Sheets & Apps Script sebagai penerima webhook<\/a><\/li>\n<li><a href=\"#langkah-3-deteksi-order-cod-enqueue-pengiriman\">Langkah 3 \u2014 Deteksi order COD & enqueue pengiriman pesan<\/a><\/li>\n<li><a href=\"#langkah-4-kirim-cod-confirmation-via-whatsapp-api\">Langkah 4 \u2014 Kirim COD confirmation via WhatsApp API<\/a><\/li>\n<li><a href=\"#langkah-5-menangani-inbound-replies-confirmation-flow\">Langkah 5 \u2014 Menangani inbound replies<\/a><\/li>\n<li><a href=\"#langkah-6-update-tracking-sinkronisasi-order-status\">Langkah 6 \u2014 Update tracking & sinkronisasi order status<\/a><\/li>\n<li><a href=\"#langkah-7-otomatisasi-lanjutan-best-practices\">Langkah 7 \u2014 Otomatisasi lanjutan & best practices teknis<\/a><\/li>\n<li><a href=\"#contoh-kode-payload\">Contoh kode & payload<\/a><\/li>\n<li><a href=\"#contoh-payloads-template-pesan\">Contoh payloads & template pesan<\/a><\/li>\n<li><a href=\"#error-handling-troubleshooting-umum\">Error handling & troubleshooting umum<\/a><\/li>\n<li><a href=\"#keamanan-privasi-data\">Keamanan & privasi data<\/a><\/li>\n<li><a href=\"#monitoring-reporting-scaling-operasional\">Monitoring, reporting & scaling operasional<\/a><\/li>\n<li><a href=\"#checklist-implementasi\">Checklist implementasi<\/a><\/li>\n<li><a href=\"#contoh-skenario-end-to-end\">Contoh skenario end\u2011to\u2011end<\/a><\/li>\n<li><a href=\"#faq\">FAQ singkat<\/a><\/li>\n<li><a href=\"#best-practices-rekomendasi-operasional\">Best practices & rekomendasi operasional<\/a><\/li>\n<li><a href=\"#resources-pembelajaran-tambahan\">Resources & pembelajaran tambahan<\/a><\/li>\n<li><a href=\"#mengapa-inreality-solutions-cocok-untuk-proyek-otomasi-ini\">Mengapa InReality Solutions cocok untuk proyek Otomasi ini<\/a><\/li>\n<li><a href=\"#call-to-action-konsultasi-demo-implementasi\">Call to Action \u2014 Konsultasi & Demo Implementasi<\/a><\/li>\n<\/ul>\n<\/nav>\n<h2 id=\"untuk-siapa-artikel-ini\">Untuk siapa artikel ini (cara google sheets workflow)<\/h2>\n<p>Artikel ini ditujukan untuk pemilik toko online (Shopify\/WooCommerce), head of operations, marketing manager, dan developer ringan\/IT ops. Hasil yang diharapkan: konfirmasi COD otomatis via WhatsApp, update order status (Siap Kirim \/ Dibatalkan), dan pengiriman notifikasi tracking. Use case: e\u2011commerce retail, showroom, marketplace lokal; catatan pasar Indonesia: COD masih populer dan pastikan format nomor +62.<\/p>\n<h2 id=\"gambaran-teknis-arsitektur-alur-cod-confirmation-flow\">Gambaran teknis & arsitektur alur (cod confirmation flow)<\/h2>\n<p>Diagram alur (sertakan PNG\/SVG saat publish):<\/p>\n<p><img decoding=\"async\" data-src=\"path-to-diagram.png\" alt=\"Diagram alur COD confirmation flow\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" class=\"lazyload\"><noscript><img decoding=\"async\" src=\"path-to-diagram.png\" alt=\"Diagram alur COD confirmation flow\"><\/noscript><\/p>\n<ul>\n<li>Shopify\/WooCommerce webhook \u2192 Google Apps Script (doPost) \u2192 tulis ke Google Sheets (queue)<\/li>\n<li>Apps Script memfilter payment_method == “COD” \u2192 kirim pesan via WhatsApp API (Twilio\/360dialog\/WATI). Lihat dokumentasi provider seperti <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio WhatsApp<\/a>, <a href=\"https:\/\/docs.360dialog.com\/\">360dialog<\/a>, atau <a href=\"https:\/\/docs.wati.io\/\">WATI<\/a>.<\/li>\n<li>Inbound webhook dari provider WA \u2192 Apps Script \u2192 update Sheet \u2192 optional call API ke Shopify\/WooCommerce untuk update order<\/li>\n<\/ul>\n<p>Referensi webhook Shopify: <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\">Shopify webhooks<\/a>. Referensi webhook WooCommerce: <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">WooCommerce webhooks<\/a>. Panduan Apps Script Web Apps: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/web\">Apps Script Web Apps<\/a>. WhatsApp Business API docs: <a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\">WhatsApp Business API<\/a>.<\/p>\n<h2 id=\"pra-syarat-bahan-yang-perlu-disipkan\">Pra\u2011syarat & bahan yang perlu disiapkan (google sheets tutorial)<\/h2>\n<ul>\n<li>Admin Shopify \/ WooCommerce dengan akses buat webhook (lihat <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\">Shopify<\/a> \/ <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">WooCommerce<\/a>).<\/li>\n<li>Google Account & Google Sheets; akses Apps Script (lihat <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/sheets\">Apps Script Sheets guide<\/a>).<\/li>\n<li>Akun provider WhatsApp API: <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio<\/a>, <a href=\"https:\/\/docs.360dialog.com\/\">360dialog<\/a>, atau <a href=\"https:\/\/docs.wati.io\/\">WATI<\/a>. Pastikan template pesan WA sudah disetujui (<a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\/message-templates\">WA message templates<\/a>).<\/li>\n<li>Kredensial API dan URL inbound webhook untuk menerima reply.<\/li>\n<li>Opsional: middleware\/no\u2011code \u2014 Zapier (<a href=\"https:\/\/zapier.com\/apps\/google-sheets\/integrations\">Zapier Google Sheets integrations<\/a>) atau Make (<a href=\"https:\/\/www.make.com\/en\/compare\">Make comparison<\/a>).<\/li>\n<\/ul>\n<p>Catatan: nomor Indonesia gunakan format +62; pastikan template pesan WA sudah disetujui oleh provider.<\/p>\n<h2 id=\"langkah-0-siapkan-google-sheets-template-kolom\">Langkah 0 \u2014 Siapkan Google Sheets (template & kolom) (google sheets automation)<\/h2>\n<p>Rekomendasi kolom:<\/p>\n<p><strong>Order ID | Customer | Phone | Order date | Payment method | Order status | COD confirmation | Confirmation TTL | Tracking | Last updated | Notes<\/strong><\/p>\n<p>Contoh formula: timestamp saat update:<\/p>\n<pre><code>=IF(A2<>\"\",IF(B2=\"\",NOW(),B2), \"\")<\/code><\/pre>\n<p>Sertakan conditional formatting untuk status Pending \/ Confirmed \/ Cancelled. (Sertakan screenshot CSV sebagai asset saat publish.)<\/p>\n<h2 id=\"langkah-1-buat-webhook-di-shopify-woocommerce\">Langkah 1 \u2014 Buat webhook di Shopify \/ WooCommerce (webhook shopify\/woocommerce)<\/h2>\n<p>Shopify: Admin \u2192 Settings \u2192 Notifications \u2192 Create webhook (lihat <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\/creating-webhooks\">dokumentasi Shopify membuat webhook<\/a>).<\/p>\n<p>WooCommerce: WooCommerce \u2192 Settings \u2192 Advanced \u2192 Webhooks (lihat <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">dokumentasi WooCommerce webhooks<\/a>).<\/p>\n<p>Contoh payload minimal (JSON, Shopify):<\/p>\n<pre><code>{\n \"id\": 12345,\n \"email\": \"customer@example.com\",\n \"billing_address\": { \"phone\": \"+628123456789\" },\n \"payment_gateway_names\": [\"COD\"],\n \"created_at\": \"2024-01-01T10:00:00Z\"\n}<\/code><\/pre>\n<p>Nota: nomor telepon sering ada di billing.phone \u2192 cek format.<\/p>\n<h2 id=\"langkah-2-siapkan-google-sheets-apps-script-sebagai-penerima-webhook\">Langkah 2 \u2014 Siapkan Google Sheets & Apps Script sebagai penerima webhook (cara google sheets workflow)<\/h2>\n<p>Deploy Apps Script sebagai Web App (doPost) untuk menerima webhook, parse JSON, validasi, dan tulis ke sheet. Panduan deploy: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/web\">Apps Script Web Apps<\/a>.<\/p>\n<h3 id=\"struktur-permission\">Struktur & permission<\/h3>\n<ul>\n<li>Struktur: Script project \u2192 .gs files \u2192 Libraries (opsional)<\/li>\n<li>Deploy: Publish \u2192 Deploy as web app \u2192 Execute as: Me \u2192 Who has access: Anyone (atau hanya tertentu jika menggunakan middleware)<\/li>\n<\/ul>\n<p>Contoh skeleton doPost(e):<\/p>\n<pre><code>\/\/ doPost handler - terima webhook\nfunction doPost(e) {\n var payload = JSON.parse(e.postData.contents);\n \/\/ validasi minimal\n if (!payload || !payload.id) return ContentService.createTextOutput('nok');\n \/\/ tulis ke sheet (implementasi lanjut)\n return ContentService.createTextOutput('ok');\n}<\/code><\/pre>\n<p>Referensi UrlFetchApp untuk panggilan HTTP: <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/url-fetch\/url-fetch-app\">UrlFetchApp<\/a>.<\/p>\n<h2 id=\"langkah-3-deteksi-order-cod-enqueue-pengiriman\">Langkah 3 \u2014 Deteksi order COD & enqueue pengiriman pesan (cod confirmation flow)<\/h2>\n<p>Filter jika payment_method contains “COD” \u2192 set COD confirmation = “Pending” dan set Confirmation TTL (timestamp + 24 jam). Hindari duplicate dengan cek Order ID atau unique composite (orderId+phone).<\/p>\n<p>Implementasikan pengecekan duplicate sebelum enqueue untuk menghindari kirim ganda.<\/p>\n<h2 id=\"langkah-4-kirim-cod-confirmation-via-whatsapp-api\">Langkah 4 \u2014 Kirim COD confirmation via WhatsApp API (cod confirmation whatsapp)<\/h2>\n<p>Contoh pesan (ID):<\/p>\n<p>“Halo {nama}, pesanan #{orderId} Anda terdaftar COD. Mohon balas YES untuk konfirmasi dalam 24 jam atau NO untuk batalkan. Terima kasih.”<\/p>\n<p>Contoh kirim memakai UrlFetchApp ke Twilio (lihat <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">Twilio WhatsApp API<\/a>):<\/p>\n<pre><code>function kirimWhatsApp(phone, message) {\n var url = \"https:\/\/api.twilio.com\/2010-04-01\/Accounts\/ACCOUNT_SID\/Messages.json\";\n var payload = {\n To: \"whatsapp:\" + phone,\n From: \"whatsapp:+1415XXXXXXX\",\n Body: message\n };\n var options = {\n method: \"post\",\n payload: payload,\n headers: { Authorization: \"Basic \" + Utilities.base64Encode(\"ACCOUNT_SID:AUTH_TOKEN\") }\n };\n var resp = UrlFetchApp.fetch(url, options);\n return resp.getContentText();\n}<\/code><\/pre>\n<p>Lihat juga dokumentasi <a href=\"https:\/\/docs.360dialog.com\/\">360dialog<\/a> dan aturan template WA di <a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\/message-templates\">Facebook\/WhatsApp templates<\/a>. Tips: atur rate\u2011limit, pakai template yang sudah disetujui, handle HTTP errors (429, 401).<\/p>\n<h2 id=\"langkah-5-menangani-inbound-replies-confirmation-flow\">Langkah 5 \u2014 Menangani inbound replies (confirmation flow)<\/h2>\n<p>Provider WA akan mem-forward pesan inbound ke webhook Anda (lihat <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/tutorial\/send-and-receive-media-messages-whatsapp\">Twilio inbound webhook<\/a> dan <a href=\"https:\/\/docs.360dialog.com\/\">360dialog inbound<\/a>). Parse body, cari kata kunci YES\/NO, lalu update row terkait \u2192 ubah Order status (Siap Kirim \/ Dibatalkan). Implementasikan reminder (24 jam) dan retry logic.<\/p>\n<p>State machine sederhana: Pending \u2192 (YES) Confirmed \u2192 Siap Kirim ; Pending \u2192 (no reply within TTL) \u2192 Reminder \u2192 Cancelled.<\/p>\n<h2 id=\"langkah-6-update-tracking-sinkronisasi-order-status\">Langkah 6 \u2014 Update tracking & sinkronisasi order status (order status, tracking)<\/h2>\n<p>Saat merchant memasukkan nomor resi di kolom Tracking \u2192 trigger script untuk kirim notifikasi WA dan (opsional) update ke Shopify\/WooCommerce via Orders API (Shopify: <a href=\"https:\/\/shopify.dev\/docs\/api\/admin-rest\/2023-10\/resources\/order\">Shopify Orders API<\/a> ; WooCommerce: <a href=\"https:\/\/woocommerce.github.io\/woocommerce-rest-api-docs\/#update-an-order\">WooCommerce Orders API<\/a>).<\/p>\n<p>Rekomendasi: mulai manual lewat sheet; otomatisasi API untuk skala besar.<\/p>\n<h2 id=\"langkah-7-otomatisasi-lanjutan-best-practices\">Langkah 7 \u2014 Otomatisasi lanjutan & best practices teknis (google sheets automation)<\/h2>\n<ul>\n<li>Retry\/backoff; reminder sequence 24h\/48h; fallback SMS\/email.<\/li>\n<li>Throttling & dead\u2011letter column (Notes).<\/li>\n<li>Migrasi ke DB \/ BigQuery saat volume tinggi (<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/overview\">BigQuery overview<\/a>).<\/li>\n<li>Make vs Zapier comparison: <a href=\"https:\/\/www.make.com\/en\/compare\">Make vs Zapier<\/a>.<\/li>\n<\/ul>\n<h2 id=\"contoh-kode-payload\">Contoh kode & payload (google sheets tutorial)<\/h2>\n<p>Contoh snippet yang sering digunakan:<\/p>\n<ul>\n<li>doPost(e) handler (lihat di atas)<\/li>\n<li>kirimWhatsApp(phone,message) (lihat di atas)<\/li>\n<li>inbound handler updateConfirmation(orderId, reply) \u2014 implementasi mirip: cari row by orderId, update kolom COD confirmation dan Order status.<\/li>\n<\/ul>\n<p>Sertakan link repo contoh di GitHub bila tersedia saat publish.<\/p>\n<h2 id=\"contoh-payloads-template-pesan\">Contoh payloads & template pesan<\/h2>\n<p>Shopify payload contoh: lihat contoh di Langkah 1. WooCommerce payload serupa (lihat <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">dokumentasi WooCommerce<\/a>).<\/p>\n<p>Inbound WA sample (JSON) disediakan di asset saat publish.<\/p>\n<p>Template pesan:<\/p>\n<ol>\n<li>Konfirmasi awal: “Halo {nama}, pesanan #{orderId} Anda terdaftar COD. Balas YES untuk konfirmasi dalam 24 jam.”<\/li>\n<li>Reminder 24 jam: “Pengingat: mohon konfirmasi pesanan #{orderId}. Balas YES\/NO.”<\/li>\n<\/ol>\n<p>Catatan: template WA butuh approval provider (<a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\/message-templates\">message templates<\/a>).<\/p>\n<h2 id=\"error-handling-troubleshooting-umum\">Error handling & troubleshooting umum (cara google sheets workflow)<\/h2>\n<ul>\n<li>Cek Apps Script logs\/executions: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/logging\">Apps Script logging<\/a>.<\/li>\n<li>Masalah umum: 403 permissions, JSON parse error, invalid phone, template not approved, 429 rate limit.<\/li>\n<li>Gunakan exponential backoff dan dead\u2011letter logging di kolom Notes.<\/li>\n<\/ul>\n<h2 id=\"keamanan-privasi-data\">Keamanan & privasi data (google sheets automation)<\/h2>\n<p>Simpan kredensial di PropertiesService (<a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a>) atau GCP Secret Manager (<a href=\"https:\/\/cloud.google.com\/secret-manager\">Secret Manager<\/a>). Batasi akses sheet dan audit trail. Untuk kepatuhan lokal (UU PDP), konsultasikan ke legal.<\/p>\n<h2 id=\"monitoring-reporting-scaling-operasional\">Monitoring, reporting & scaling operasional<\/h2>\n<p>Buat dashboard di Sheet (pivot\/summary) dengan metrik: pending count, confirmed %, cancelled %, avg time to confirm. Pertimbangkan migrasi ke DB\/BigQuery bila latency\/volume tinggi.<\/p>\n<h2 id=\"checklist-implementasi\">Checklist implementasi (google sheets automation)<\/h2>\n<ul>\n<li>[ ] Siapkan akun provider WA & nomor<\/li>\n<li>[ ] Buat webhook di Shopify\/WooCommerce<\/li>\n<li>[ ] Deploy Apps Script (doPost)<\/li>\n<li>[ ] Buat Sheet template & kolom mandatory<\/li>\n<li>[ ] Implement filter COD & enqueue<\/li>\n<li>[ ] Kirim WA template & handle inbound<\/li>\n<li>[ ] Update order status & tracking<\/li>\n<li>[ ] Monitoring & retry logic<\/li>\n<\/ul>\n<h2 id=\"contoh-skenario-end-to-end\">Contoh skenario end\u2011to\u2011end (cod confirmation flow, tracking)<\/h2>\n<ol>\n<li>Customer balas YES dalam 10 menit \u2192 update status Siap Kirim \u2192 merchant packing.<\/li>\n<li>No reply 24 jam \u2192 reminder \u2192 no reply 48 jam \u2192 auto\u2011cancel.<\/li>\n<li>Confirm YES \u2192 merchant input resi \u2192 otomatis kirim WA tracking.<\/li>\n<\/ol>\n<h2 id=\"faq\">FAQ singkat (google sheets tutorial, cara google sheets workflow)<\/h2>\n<section class=\"faq\">\n<div>\n<h3 id=\"faq-bisakah-pakai-zapier-make\">Bisakah pakai Zapier\/Make?<\/h3>\n<p>Ya \u2014 Zapier atau Make memudahkan integrasi tanpa coding, tetapi Apps Script memberi fleksibilitas lebih untuk custom logic dan kontrol biaya. Lihat <a href=\"https:\/\/zapier.com\/apps\/google-sheets\/integrations\">Zapier<\/a> dan <a href=\"https:\/\/www.make.com\/en\/compare\">Make<\/a>.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-multi-store\">Bagaimana kalau multi\u2011store?<\/h3>\n<p>Gunakan satu webhook per store atau sertakan store_id di payload untuk membedakan pesan dan sinkronisasi.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-biaya-whatsapp-api-limit\">Berapa biaya WhatsApp API & limit template?<\/h3>\n<p>Biaya bergantung provider. Cek pricing resmi Twilio: <a href=\"https:\/\/www.twilio.com\/pricing\">Twilio pricing<\/a> dan 360dialog: <a href=\"https:\/\/www.360dialog.com\/pricing\">360dialog pricing<\/a>.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-format-nomor-indonesia\">Format nomor Indonesia harus bagaimana?<\/h3>\n<p>Gunakan format internasional +62 dan validasi nomor sebelum kirim. Simpan nomor konsisten di Sheet untuk menghindari kegagalan pengiriman.<\/p>\n<\/p><\/div>\n<div>\n<h3 id=\"faq-apa-jika-template-belum-disetujui\">Apa yang terjadi jika template belum disetujui?<\/h3>\n<p>Pesan templated akan ditolak oleh provider; alternatif sementara: kirim SMS\/email atau kontak manual sampai template disetujui.<\/p>\n<\/p><\/div>\n<\/section>\n<h2 id=\"best-practices-rekomendasi-operasional\">Best practices & rekomendasi operasional (google sheets automation)<\/h2>\n<ul>\n<li>Pesan singkat, minta persetujuan eksplisit, audit trail, rate limiting.<\/li>\n<li>Format nomor +62, selalu sediakan fallback channel (telpon\/SMS\/email).<\/li>\n<li>Implementasikan monitoring dan dead\u2011letter untuk investigasi manual.<\/li>\n<\/ul>\n<h2 id=\"resources-pembelajaran-tambahan\">Resources & pembelajaran tambahan (google sheets tutorial)<\/h2>\n<ul>\n<li>Google Apps Script guides: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\">Apps Script guides<\/a><\/li>\n<li>Shopify webhooks: <a href=\"https:\/\/shopify.dev\/docs\/api\/usage\/webhooks\">Shopify webhooks<\/a><\/li>\n<li>WooCommerce webhooks: <a href=\"https:\/\/woocommerce.com\/document\/webhooks\/\">WooCommerce webhooks<\/a><\/li>\n<li>WhatsApp Business API: <a href=\"https:\/\/developers.facebook.com\/docs\/whatsapp\">WhatsApp Business API<\/a><\/li>\n<li>Twilio WhatsApp: <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio WhatsApp<\/a><\/li>\n<\/ul>\n<h2 id=\"mengapa-inreality-solutions-cocok-untuk-proyek-otomasi-ini\">Mengapa InReality Solutions cocok untuk proyek Otomasi ini<\/h2>\n<p>InReality Solutions memiliki keahlian di Otomasi AI & integrasi sistem untuk solusi end\u2011to\u2011end\u2014dari analisis proses sampai deployment dan operasional di pasar Indonesia. Kami menawarkan integrasi dengan CRM\/ERP, keamanan data, dan dukungan implementasi serta monitoring operasional. Lihat layanan kami: <a href=\"\/id\/layanan\/otomasi-ai\/\">\/layanan\/otomasi-ai<\/a> dan contoh kerja: <a href=\"\/id\/portofolio\/automasi-whatsapp\/\">\/portofolio\/automasi-whatsapp<\/a>.<\/p>\n<h2 id=\"call-to-action-konsultasi-demo-implementasi\">Call to Action \u2014 Konsultasi & Demo Implementasi<\/h2>\n<p>Butuh demo atau audit workflow COD Anda? Hubungi kami untuk konsultasi teknis atau demo implementasi. Kami kirimkan aset gratis: Google Sheets template + snippet Apps Script untuk percobaan. Ringkasan manfaat: Otomasi konfirmasi COD via Google Sheets + WhatsApp mengurangi beban follow\u2011up manual, mempercepat proses fulfillment, dan memberikan jejak audit yang jelas.<\/p>\n<p>Referensi tambahan dan contoh kasus tersedia di <a href=\"https:\/\/inrealitysolutions.com\/id\/kommo-crm-automation-cod-confirmation\/\">InReality Solutions \u2014 Kommo CRM Automation COD Confirmation<\/a> dan <a href=\"https:\/\/inrealitysolutions.com\/id\/mailchimp-automation-cod-confirmation-whatsapp\/\">Mailchimp Automation COD Confirmation WhatsApp<\/a>.<\/p>\n<p><\/body><br \/>\n<\/html><\/p>","protected":false},"excerpt":{"rendered":"<p>Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update […]<\/p>","protected":false},"author":16,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[170],"tags":[],"class_list":["post-9062","post","type-post","status-publish","format-standard","hentry","category-ai-automations"],"yoast_head":"\n<title>Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah\" \/>\n<meta property=\"og:description\" content=\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/\" \/>\n<meta property=\"og:site_name\" content=\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/InRealitySolutions\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-08T01:17:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-08T01:17:42+00:00\" \/>\n<meta name=\"author\" content=\"Maya Ananta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Maya Ananta\" \/>\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:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah\",\"datePublished\":\"2026-05-08T01:17:36+00:00\",\"dateModified\":\"2026-05-08T01:17:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\"},\"wordCount\":1464,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\",\"url\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\",\"name\":\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"datePublished\":\"2026-05-08T01:17:36+00:00\",\"dateModified\":\"2026-05-08T01:17:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\",\"url\":\"https:\/\/inrealitysolutions.com\/id\/\",\"name\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"description\":\"Transforming Businesses Through AR\/VR, Virtual Tours & AI Innovation\",\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/inrealitysolutions.com\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\",\"name\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"url\":\"https:\/\/inrealitysolutions.com\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png\",\"contentUrl\":\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png\",\"width\":1006,\"height\":319,\"caption\":\"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\"},\"image\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/InRealitySolutions\/\",\"https:\/\/www.linkedin.com\/company\/inreality-solutions\/\",\"https:\/\/www.instagram.com\/inreality_solutions\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\",\"name\":\"Maya Ananta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g\",\"caption\":\"Maya Ananta\"},\"url\":\"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/\"}]}<\/script>\n","yoast_head_json":{"title":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","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:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/","og_locale":"id_ID","og_type":"article","og_title":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah","og_description":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update […]","og_url":"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/","og_site_name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","article_publisher":"https:\/\/www.facebook.com\/InRealitySolutions\/","article_published_time":"2026-05-08T01:17:36+00:00","article_modified_time":"2026-05-08T01:17:42+00:00","author":"Maya Ananta","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Maya Ananta","Estimasi waktu membaca":"8 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah","datePublished":"2026-05-08T01:17:36+00:00","dateModified":"2026-05-08T01:17:42+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"},"wordCount":1464,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/","url":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/","name":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"datePublished":"2026-05-08T01:17:36+00:00","dateModified":"2026-05-08T01:17:42+00:00","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah"}]},{"@type":"WebSite","@id":"https:\/\/inrealitysolutions.com\/id\/#website","url":"https:\/\/inrealitysolutions.com\/id\/","name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","description":"Transforming Businesses Through AR\/VR, Virtual Tours & AI Innovation","publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/inrealitysolutions.com\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/inrealitysolutions.com\/id\/#organization","name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","url":"https:\/\/inrealitysolutions.com\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/","url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png","contentUrl":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2021\/09\/Inreality-Solutions-logo.png","width":1006,"height":319,"caption":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia"},"image":{"@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/InRealitySolutions\/","https:\/\/www.linkedin.com\/company\/inreality-solutions\/","https:\/\/www.instagram.com\/inreality_solutions\/"]},{"@type":"Person","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a","name":"Maya Ananta","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/48f96fb33f8c03241bdaccaf1a39bbc773261c3363a2dc04d2d46adccd9b6c70?s=96&d=mm&r=g","caption":"Maya Ananta"},"url":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"trp-custom-language-flag":false},"uagb_author_info":{"display_name":"Maya Ananta","author_link":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"},"uagb_comment_info":0,"uagb_excerpt":"Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Google Sheets Automation COD Confirmation WhatsApp \u2014 Cara Langkah demi Langkah Otomatis kirim konfirmasi COD via WhatsApp dari Google Sheets\/Apps Script untuk mengurangi pembatalan manual. Alur: webhook toko \u2192 Apps Script (doPost) \u2192 enqueue di Sheets \u2192 kirim WA \u2192 terima reply \u2192 update…","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/comments?post=9062"}],"version-history":[{"count":1,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062\/revisions"}],"predecessor-version":[{"id":9063,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062\/revisions\/9063"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=9062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=9062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=9062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}