{"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-22T08:28:36","modified_gmt":"2026-05-22T01:28:36","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":"<h1 id=\"google-sheets-automation-cod-confirmation-whatsapp-cara-langkah-demi-langkah\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-9118\" src=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\" alt=\"\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg 1080w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-300x300.jpg 300w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-1024x1024.jpg 1024w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-150x150.jpg 150w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-768x768.jpg 768w, https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-12x12.jpg 12w\" sizes=\"(max-width: 1080px) 100vw, 1080px\" \/>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 &amp; 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\"><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 &amp; arsitektur alur<\/a><\/li>\n<li><a href=\"#pra-syarat-bahan-yang-perlu-disiapkan\">Pra\u2011syarat &amp; bahan yang perlu disiapkan<\/a><\/li>\n<li><a href=\"#langkah-0-siapkan-google-sheets-template-kolom\">Langkah 0 \u2014 Siapkan Google Sheets (template &amp; 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 &amp; Apps Script sebagai penerima webhook<\/a><\/li>\n<li><a href=\"#langkah-3-deteksi-order-cod-enqueue-pengiriman\">Langkah 3 \u2014 Deteksi order COD &amp; 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 &amp; sinkronisasi order status<\/a><\/li>\n<li><a href=\"#langkah-7-otomatisasi-lanjutan-best-practices\">Langkah 7 \u2014 Otomatisasi lanjutan &amp; best practices teknis<\/a><\/li>\n<li><a href=\"#contoh-kode-payload\">Contoh kode &amp; payload<\/a><\/li>\n<li><a href=\"#contoh-payloads-template-pesan\">Contoh payloads &amp; template pesan<\/a><\/li>\n<li><a href=\"#error-handling-troubleshooting-umum\">Error handling &amp; troubleshooting umum<\/a><\/li>\n<li><a href=\"#keamanan-privasi-data\">Keamanan &amp; privasi data<\/a><\/li>\n<li><a href=\"#monitoring-reporting-scaling-operasional\">Monitoring, reporting &amp; 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 &amp; rekomendasi operasional<\/a><\/li>\n<li><a href=\"#resources-pembelajaran-tambahan\">Resources &amp; 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 &amp; 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 &amp; 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 == &#8220;COD&#8221; \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 &amp; 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 &amp; 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 &amp; 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&lt;&gt;\"\",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 &amp; 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 &amp; 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 &amp; enqueue pengiriman pesan (cod confirmation flow)<\/h2>\n<p>Filter jika payment_method contains &#8220;COD&#8221; \u2192 set COD confirmation = &#8220;Pending&#8221; 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>&#8220;Halo {nama}, pesanan #{orderId} Anda terdaftar COD. Mohon balas YES untuk konfirmasi dalam 24 jam atau NO untuk batalkan. Terima kasih.&#8221;<\/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 &amp; 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 &amp; best practices teknis (google sheets automation)<\/h2>\n<ul>\n<li>Retry\/backoff; reminder sequence 24h\/48h; fallback SMS\/email.<\/li>\n<li>Throttling &amp; 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 &amp; 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 &amp; 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: &#8220;Halo {nama}, pesanan #{orderId} Anda terdaftar COD. Balas YES untuk konfirmasi dalam 24 jam.&#8221;<\/li>\n<li>Reminder 24 jam: &#8220;Pengingat: mohon konfirmasi pesanan #{orderId}. Balas YES\/NO.&#8221;<\/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 &amp; 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 &amp; 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 &amp; 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 &amp; nomor<\/li>\n<li>[ ] Buat webhook di Shopify\/WooCommerce<\/li>\n<li>[ ] Deploy Apps Script (doPost)<\/li>\n<li>[ ] Buat Sheet template &amp; kolom mandatory<\/li>\n<li>[ ] Implement filter COD &amp; enqueue<\/li>\n<li>[ ] Kirim WA template &amp; handle inbound<\/li>\n<li>[ ] Update order status &amp; tracking<\/li>\n<li>[ ] Monitoring &amp; 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<\/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<\/div>\n<div>\n<h3 id=\"faq-biaya-whatsapp-api-limit\">Berapa biaya WhatsApp API &amp; 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<\/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<\/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<\/div>\n<\/section>\n<h2 id=\"best-practices-rekomendasi-operasional\">Best practices &amp; 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 &amp; 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 &amp; 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 &amp; 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>","protected":false},"excerpt":{"rendered":"<p>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 status &amp; tracking. Gunakan provider WhatsApp API (Twilio \/ 360dialog \/ [&hellip;]<\/p>","protected":false},"author":16,"featured_media":9118,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","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":"disabled","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":"set","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","has-post-thumbnail","hentry","category-ai-automations"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.5 (Yoast SEO v20.12) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Sheets Automation COD Confirmation WhatsApp<\/title>\n<meta name=\"description\" content=\"Cara membuat Google Sheets Automation COD Confirmation WhatsApp otomatis dengan Apps Script, Shopify, WooCommerce, dan WhatsApp API.\" \/>\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\" \/>\n<meta property=\"og:description\" content=\"Cara membuat Google Sheets Automation COD Confirmation WhatsApp otomatis dengan Apps Script, Shopify, WooCommerce, dan WhatsApp API.\" \/>\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 &amp; 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-22T01:28:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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-22T01:28:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/\"},\"wordCount\":1496,\"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\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"datePublished\":\"2026-05-08T01:17:36+00:00\",\"dateModified\":\"2026-05-22T01:28:36+00:00\",\"description\":\"Cara membuat Google Sheets Automation COD Confirmation WhatsApp otomatis dengan Apps Script, Shopify, WooCommerce, dan WhatsApp API.\",\"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\/\"},{\"@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 &amp; AI Automations Indonesia\",\"description\":\"Transforming Businesses Through AR\/VR, Virtual Tours &amp; 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 &amp; 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 &amp; 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 SEO Premium plugin. -->","yoast_head_json":{"title":"Google Sheets Automation COD Confirmation WhatsApp","description":"Cara membuat Google Sheets Automation COD Confirmation WhatsApp otomatis dengan Apps Script, Shopify, WooCommerce, dan WhatsApp API.","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","og_description":"Cara membuat Google Sheets Automation COD Confirmation WhatsApp otomatis dengan Apps Script, Shopify, WooCommerce, dan WhatsApp API.","og_url":"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-cod-confirmation\/","og_site_name":"InReality Solutions \u2014 AR\/VR, Virtual Tours &amp; 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-22T01:28:36+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg","type":"image\/jpeg"}],"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-22T01:28:36+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/google-sheets-automation-cod-confirmation\/"},"wordCount":1496,"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","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"datePublished":"2026-05-08T01:17:36+00:00","dateModified":"2026-05-22T01:28:36+00:00","description":"Cara membuat Google Sheets Automation COD Confirmation WhatsApp otomatis dengan Apps Script, Shopify, WooCommerce, dan WhatsApp API.","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\/"},{"@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 &amp; AI Automations Indonesia","description":"Transforming Businesses Through AR\/VR, Virtual Tours &amp; 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 &amp; 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 &amp; 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":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg",1080,1080,false],"thumbnail":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-150x150.jpg",150,150,true],"medium":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-300x300.jpg",300,300,true],"medium_large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-768x768.jpg",768,768,true],"large":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-1024x1024.jpg",1024,1024,true],"1536x1536":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg",1080,1080,false],"2048x2048":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8.jpg",1080,1080,false],"trp-custom-language-flag":["https:\/\/inrealitysolutions.com\/wp-content\/uploads\/2026\/05\/SEO-Pict-8-12x12.jpg",12,12,true]},"uagb_author_info":{"display_name":"Maya Ananta","author_link":"https:\/\/inrealitysolutions.com\/id\/author\/mayaananta\/"},"uagb_comment_info":1,"uagb_excerpt":"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 status &amp; tracking. Gunakan provider WhatsApp API (Twilio \/ 360dialog \/&hellip;","_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":2,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062\/revisions"}],"predecessor-version":[{"id":9119,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/9062\/revisions\/9119"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media\/9118"}],"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}]}}