Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah<\/title><br \/>\n<\/head><br \/>\n<body><\/p>\n<h1 id=\"apps-script-automation-daily-report-bot-panduan-langkah-demi-langkah\">Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah<\/h1>\n<section class=\"key-takeaways\">\n<h2 id=\"ringkasan-cepat\">Ringkasan Cepat<\/h2>\n<ul>\n<li>Otomasi laporan harian dari Google Sheet atau DB dengan <a href=\"https:\/\/developers.google.com\/apps-script\">Google Apps Script<\/a>.<\/li>\n<li>Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain).<\/li>\n<li>Simpan kredensial di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a> dan gunakan triggers terjadwal.<\/li>\n<li>Gunakan retry & observability (Logger \/ Cloud Logging) untuk stabilitas produksi.<\/li>\n<\/ul>\n<\/section>\n<nav class=\"toc\" aria-label=\"Daftar isi\">\n<h2 id=\"daftar-isi\">Daftar Isi<\/h2>\n<ul>\n<li><a href=\"#target-pembaca-intent\">Target Pembaca & Intent<\/a><\/li>\n<li><a href=\"#mengapa-perlu-daily-report-bot-masalah-solusi\">Mengapa Perlu Daily Report Bot (Masalah & Solusi)<\/a><\/li>\n<li><a href=\"#use-case-utama-varian\">Use\u2011Case Utama & Varian<\/a><\/li>\n<li><a href=\"#arsitektur-workflow\">Arsitektur & Workflow<\/a><\/li>\n<li><a href=\"#persiapan-requirement\">Persiapan & Requirement<\/a><\/li>\n<li><a href=\"#struktur-project-best-practice-kode\">Struktur Project & Best Practice Kode<\/a><\/li>\n<li><a href=\"#langkah-langkah-implementasi-ringkasan-langkah-utama\">Langkah\u2011langkah Implementasi<\/a><\/li>\n<li><a href=\"#contoh-kode-snippets\">Contoh Kode & Snippets<\/a><\/li>\n<li><a href=\"#template-pesan-formatting\">Template Pesan & Formatting \u2014 Slack vs WhatsApp<\/a><\/li>\n<li><a href=\"#error-handling-retries-observability\">Error Handling, Retries & Observability<\/a><\/li>\n<li><a href=\"#security-permissions\">Security & Permissions<\/a><\/li>\n<li><a href=\"#checklist-sebelum-live\">Checklist Sebelum Live<\/a><\/li>\n<li><a href=\"#keberatan-umum-faq-singkat\">Keberatan Umum & FAQ (singkat)<\/a><\/li>\n<li><a href=\"#mengapa-inreality-solutions-cocok\">Mengapa InReality Solutions Cocok untuk Proyek Otomasi Anda<\/a><\/li>\n<li><a href=\"#cta-konsultasi-demo-otomasi\">Konsultasi & Demo Otomasi<\/a><\/li>\n<\/ul>\n<\/nav>\n<article>\n<h2 id=\"target-pembaca-intent\">Target Pembaca & Intent<\/h2>\n<p>Panduan ini ditujukan untuk pengambil keputusan pemasaran\/operasi, developer internal, dan analis data di perusahaan B2B\/UKM. Fokusnya adalah how\u2011to teknis praktis untuk membangun workflow Apps Script lengkap dengan contoh kode, template pesan, dan checklist implementasi.<\/p>\n<h2 id=\"mengapa-perlu-daily-report-bot-masalah-solusi\">Mengapa Perlu Daily Report Bot (Masalah & Solusi)<\/h2>\n<p>Manual reporting memakan waktu dan rawan inkonsistensi. Solusi yang disarankan: gunakan <a href=\"https:\/\/developers.google.com\/apps-script\">Google Apps Script<\/a> untuk ekstraksi dari Sheets\/DB, transformasi menjadi summary, lalu kirim otomatis ke channel tim\u2014mengurangi delay dan menjaga keputusan berbasis data.<\/p>\n<h2 id=\"use-case-utama-varian\">Use\u2011Case Utama & Varian<\/h2>\n<h3 id=\"skenario-utama-laporan-penjualan-harian\">Skenario utama \u2014 Laporan Penjualan Harian<\/h3>\n<ul>\n<li>Data source: <a href=\"https:\/\/support.google.com\/docs\/answer\/3093343\">Google Sheet<\/a> (transaksi) atau database via JDBC\/REST. Contoh otomasi Sheet: <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-form-crm\/\">Form\u2192CRM Sheet<\/a>.<\/li>\n<li>Laporan ringkas: total penjualan, 5 produk teratas, perubahan vs hari sebelumnya.<\/li>\n<li>Delivery: Slack channel via <a href=\"https:\/\/api.slack.com\/messaging\/webhooks\">Incoming Webhook<\/a> atau WhatsApp via provider seperti <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">Twilio<\/a> (bisa juga provider lokal).<\/li>\n<\/ul>\n<h3 id=\"varian\">Varian<\/h3>\n<p>Inventori harian, ringkasan leads\/CRM, monitoring sistem\/alert. Contoh integrasi form\u2011to\u2011CRM dan appointment\/reminder lewat Sheets\u2192WA: <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-appointment-whatsapp\/\">contoh appointment\u2192WA<\/a>. Untuk OCR\u2192sheet sebelum pemrosesan ringkasan lihat: <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-ocr-invoice\/\">contoh OCR invoice<\/a>.<\/p>\n<h2 id=\"arsitektur-workflow\">Arsitektur & Workflow (cara apps script workflow)<\/h2>\n<p>Diagram teks: Google Sheet \/ DB \u2192 Apps Script (extract \u2192 transform \u2192 build summary) \u2192 Notifier (send to slack\/wa) \u2192 Scheduled trigger (daily).<\/p>\n<p>Komponen penting: time\u2011driven trigger (<a href=\"https:\/\/developers.google.com\/apps-script\/guides\/triggers\/installable\">installable triggers<\/a>), <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a> untuk secrets, dan <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/url-fetch\/url-fetch-app\">UrlFetchApp<\/a> untuk panggil webhook\/API. Panduan desain pipeline automasi: <a href=\"https:\/\/inrealitysolutions.com\/id\/workflow-automasi-saas-panduan\/\">workflow automasi<\/a>.<\/p>\n<h2 id=\"persiapan-requirement\">Persiapan & Requirement<\/h2>\n<ul>\n<li>Akun Google & Google Sheet sample. Referensi <a href=\"https:\/\/support.google.com\/docs\/answer\/3093343\">fungsi QUERY di Sheets<\/a>.<\/li>\n<li>Akses ke <a href=\"https:\/\/developers.google.com\/apps-script\">Apps Script Editor<\/a>.<\/li>\n<li>Slack webhook atau Slack App token; WhatsApp provider (Twilio atau provider lokal). Twilio WA docs: <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio WhatsApp<\/a>.<\/li>\n<li>OAuth scopes: Spreadsheet, UrlFetchApp, JDBC (jika perlu). Lihat <a href=\"https:\/\/developers.google.com\/apps-script\/concepts\/scopes\">Authorization Scopes<\/a>.<\/li>\n<li>Jika perlu OCR sebelum masuk Sheet, lihat contoh Zapier OCR invoice: <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-ocr-invoice\/\">OCR\u2192sheet<\/a>.<\/li>\n<\/ul>\n<h2 id=\"struktur-project-best-practice-kode\">Struktur Project & Best Practice Kode<\/h2>\n<p>File direkomendasikan: config.js, utils.js, reportGenerator.js, notifier.js, triggers.js. Simpan token di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a>, hindari hardcoding. Referensi struktur project dan orkestrasi: <a href=\"https:\/\/inrealitysolutions.com\/id\/workflow-automasi-saas-panduan\/\">workflow automasi<\/a>.<\/p>\n<h2 id=\"langkah-langkah-implementasi-ringkasan-langkah-utama\">Langkah\u2011langkah Implementasi (ringkasan langkah utama)<\/h2>\n<h3 id=\"1-setup-google-sheet-contoh-query\">1) Setup Google Sheet & contoh QUERY<\/h3>\n<p>Gunakan <a href=\"https:\/\/support.google.com\/docs\/answer\/3093343\">fungsi QUERY<\/a> untuk pra-filter data di Sheet sebelum diproses di Apps Script.<\/p>\n<h3 id=\"2-buat-apps-script-project-dan-struktur-file\">2) Buat Apps Script project dan struktur file<\/h3>\n<p>Buat file sesuai struktur praktis dan simpan secrets di PropertiesService.<\/p>\n<h3 id=\"3-implement-querysheet\">3) Implement querySheet() \u2014 baca range & filter<\/h3>\n<pre><code>function querySheet() {\n const ss = SpreadsheetApp.openById(PropertiesService.getScriptProperties().getProperty('SHEET_ID'));\n const sheet = ss.getSheetByName('data');\n const values = sheet.getDataRange().getValues();\n \/\/ process rows -> return array of records\n return values.slice(1);\n}<\/code><\/pre>\n<h3 id=\"4-implement-querydb\">4) Implement queryDB() \u2014 JDBC\/REST<\/h3>\n<p>Jika menggunakan DB, ikuti panduan <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/jdbc\">JDBC<\/a> atau gunakan REST API dengan UrlFetchApp (amankan kredensial di PropertiesService).<\/p>\n<h3 id=\"5-implement-buildsummary\">5) Implement buildSummary(data)<\/h3>\n<p>Hitung total, top items, growth; kembalikan object summary yang siap diformat untuk delivery.<\/p>\n<h3 id=\"6-format-pesan\">6) Format pesan untuk Slack (Block Kit) dan WhatsApp (plain text)<\/h3>\n<p>Untuk Slack gunakan <a href=\"https:\/\/api.slack.com\/block-kit\">Block Kit<\/a>, untuk WhatsApp gunakan plain text template.<\/p>\n<h3 id=\"7-implement-sendtoslack-sendtowa\">7) Implement sendToSlack() & sendToWA()<\/h3>\n<pre><code>function sendToSlack(payload) {\n const url = PropertiesService.getScriptProperties().getProperty('SLACK_WEBHOOK');\n UrlFetchApp.fetch(url, {\n method: 'post',\n contentType: 'application\/json',\n payload: JSON.stringify(payload)\n });\n}<\/code><\/pre>\n<p>Untuk WhatsApp via Twilio, panggil endpoint Twilio sesuai <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">panduan Twilio WhatsApp<\/a>. Contoh integrasi lead routing: <a href=\"https:\/\/inrealitysolutions.com\/id\/whatsapp-crm-automotive-guide\/\">WhatsApp CRM Automotive<\/a>, <a href=\"https:\/\/inrealitysolutions.com\/id\/whatsapp-crm-jewelry-lead-routing\/\">WhatsApp CRM Jewelry<\/a>.<\/p>\n<h3 id=\"8-setup-scheduled-trigger-daily\">8) Setup scheduled trigger (daily)<\/h3>\n<pre><code>ScriptApp.newTrigger('mainDailyReport').timeBased().everyDays(1).atHour(7).create();<\/code><\/pre>\n<p>Lihat dokumentasi triggers: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/triggers\/installable\">Installable Triggers<\/a>.<\/p>\n<h3 id=\"9-test-end-to-end\">9) Test end\u2011to\u2011end & tambahkan logging\/monitoring<\/h3>\n<p>Tambahkan logging dan integrasi ke Cloud Logging untuk observability: <a href=\"https:\/\/cloud.google.com\/logging\/docs\">Cloud Logging<\/a>.<\/p>\n<h2 id=\"contoh-kode-snippets\">Contoh Kode & Snippets (highlight)<\/h2>\n<ul>\n<li><strong>querySheet()<\/strong> \u2014 contoh di atas.<\/li>\n<li><strong>buildSummary(data)<\/strong> \u2014 agregasi total dan top N (implementasi berdasarkan struktur data Anda).<\/li>\n<li><strong>sendToSlack(payload)<\/strong> \u2014 gunakan Block Kit JSON (<a href=\"https:\/\/api.slack.com\/block-kit\">Block Kit<\/a>).<\/li>\n<li><strong>sendToWA via Twilio<\/strong> \u2014 panggil Twilio API sesuai <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">dokumentasi<\/a>.<\/li>\n<\/ul>\n<h2 id=\"template-pesan-formatting\">Template Pesan & Formatting \u2014 Slack vs WhatsApp<\/h2>\n<p>Contoh singkat:<\/p>\n<ul>\n<li>WhatsApp (plain): “Laporan Harian \u2022 Total: Rp X\\nTop 3 Produk: A, B, C\\nGrowth vs Kemarin: +Y%”.<\/li>\n<li>Slack (Block Kit): header, section KPI, context line; tambahkan emoji untuk highlight; lihat <a href=\"https:\/\/api.slack.com\/block-kit\">contoh Block Kit<\/a>.<\/li>\n<\/ul>\n<h2 id=\"error-handling-retries-observability\">Error Handling, Retries & Observability<\/h2>\n<p>Gunakan try\/catch dengan pola retry (exponential backoff) dan <code>Logger.log()<\/code>. Untuk skala, gunakan <a href=\"https:\/\/cloud.google.com\/logging\/docs\">Cloud Logging<\/a>. Kirim notifikasi on\u2011failure ke admin Slack channel untuk tindakan cepat.<\/p>\n<h2 id=\"security-permissions\">Security & Permissions<\/h2>\n<p>Simpan secrets di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a>, gunakan minimal OAuth scopes, rencanakan rotasi token dan batasi akses project script sesuai prinsip least privilege.<\/p>\n<h2 id=\"checklist-sebelum-live\">Checklist Sebelum Live<\/h2>\n<ul>\n<li>Validasi data & output summary.<\/li>\n<li>Token tersimpan di PropertiesService dan tidak di\u2011hardcode.<\/li>\n<li>Rate limit & retry handling diimplementasikan.<\/li>\n<li>Notifikasi error aktif dan monitoring tersedia.<\/li>\n<li>Backup plan manual jika notifikasi gagal.<\/li>\n<\/ul>\n<h2 id=\"keberatan-umum-faq-singkat\">Keberatan Umum & FAQ (singkat)<\/h2>\n<section class=\"faq\" aria-labelledby=\"keberatan-umum-faq-singkat-list\">\n<h3 id=\"keberatan-umum-faq-singkat-list\">FAQ<\/h3>\n<div class=\"faq-item\">\n<h4 id=\"faq-aman-menyimpan-token-di-script\">Apakah aman menyimpan token di Script?<\/h4>\n<p>Simpan di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a> dan rencanakan rotasi token. Hindari hardcode serta batasi akses project.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-data-terlalu-besar-untuk-sheet\">Data terlalu besar untuk Sheet?<\/h4>\n<p>Gunakan database dan hubungkan via JDBC\/REST. Panduan JDBC: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/jdbc\">JDBC guide<\/a>.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-bisa-kirim-wa-tanpa-twilio\">Bisa kirim WA tanpa Twilio?<\/h4>\n<p>Ya \u2014 ada provider WhatsApp Business API lokal\/alternatif. Pilih provider yang sesuai anggaran, SLA, dan compliance.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-jam-penjadwalan-dan-timezone\">Bagaimana dengan timezone dan jadwal?<\/h4>\n<p>Atur trigger menggunakan waktu lokal yang sesuai akun Google\/Drive dan uji di lingkungan staging. Gunakan logging timestamp untuk verifikasi.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-cara-menguji-end-to-end\">Bagaimana menguji end\u2011to\u2011end sebelum live?<\/h4>\n<p>Gunakan test sheet\/data sandbox, webhook test channel Slack, dan nomor WhatsApp sandbox (mis. Twilio sandbox). Tambahkan verbose logging dan jalankan trigger manual untuk verifikasi.<\/p>\n<\/p><\/div>\n<\/section>\n<h2 id=\"mengapa-inreality-solutions-cocok\">Mengapa InReality Solutions Cocok untuk Proyek Otomasi Anda<\/h2>\n<ul>\n<li>Keahlian end\u2011to\u2011end Otomasi & Agentic AI untuk integrasi sistem CRM\/ERP.<\/li>\n<li>Praktik keamanan data & manajemen kredensial.<\/li>\n<li>Dukungan deployment, monitoring, dan dokumentasi untuk tim operasi.<\/li>\n<\/ul>\n<p>Lihat layanan kami: <a href=\"\/id\/layanan\/otomasi-ai\/\">\/layanan\/otomasi-ai<\/a> dan portofolio: <a href=\"\/id\/portofolio\/\">\/portofolio<\/a>.<\/p>\n<h2 id=\"cta-konsultasi-demo-otomasi\">Konsultasi & Demo Otomasi<\/h2>\n<p>Butuh implementasi end\u2011to\u2011end atau demo teknis? Ajukan konsultasi singkat untuk menilai workflow dan estimasi solusi. Kontak: <a href=\"\/id\/kontak-konsultasi\/\">\/kontak-konsultasi<\/a><\/p>\n<section id=\"ringkasan-manfaat\">\n<h2>Ringkasan manfaat<\/h2>\n<p>Dengan apps script automation daily report bot Anda mendapatkan laporan konsisten, lebih cepat, dan terintegrasi ke channel tim (Slack\/WA) sehingga keputusan operasional lebih tepat waktu dan terukur.<\/p>\n<\/section>\n<\/article>\n<p><\/body><br \/>\n<\/html><\/p>","protected":false},"excerpt":{"rendered":"<p>Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial […]<\/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-7224","post","type-post","status-publish","format-standard","hentry","category-ai-automations"],"yoast_head":"\n<title>Apps Script Automation Daily Report Bot \u2014 Panduan 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\/apps-script-automation-daily-report\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah\" \/>\n<meta property=\"og:description\" content=\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\" \/>\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=\"2025-12-11T01:20:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-11T01:20:43+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=\"5 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah\",\"datePublished\":\"2025-12-11T01:20:37+00:00\",\"dateModified\":\"2025-12-11T01:20:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\"},\"wordCount\":964,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\",\"url\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\",\"name\":\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"datePublished\":\"2025-12-11T01:20:37+00:00\",\"dateModified\":\"2025-12-11T01:20:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apps Script Automation Daily Report Bot \u2014 Panduan 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":"Apps Script Automation Daily Report Bot \u2014 Panduan 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\/apps-script-automation-daily-report\/","og_locale":"id_ID","og_type":"article","og_title":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah","og_description":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial […]","og_url":"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/","og_site_name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","article_publisher":"https:\/\/www.facebook.com\/InRealitySolutions\/","article_published_time":"2025-12-11T01:20:37+00:00","article_modified_time":"2025-12-11T01:20:43+00:00","author":"Maya Ananta","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Maya Ananta","Estimasi waktu membaca":"5 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah","datePublished":"2025-12-11T01:20:37+00:00","dateModified":"2025-12-11T01:20:43+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/"},"wordCount":964,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/","url":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/","name":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"datePublished":"2025-12-11T01:20:37+00:00","dateModified":"2025-12-11T01:20:43+00:00","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Apps Script Automation Daily Report Bot \u2014 Panduan 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":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial…","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7224","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=7224"}],"version-history":[{"count":1,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7224\/revisions"}],"predecessor-version":[{"id":7225,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7224\/revisions\/7225"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=7224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=7224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=7224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":7224,"date":"2025-12-11T08:20:37","date_gmt":"2025-12-11T01:20:37","guid":{"rendered":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/"},"modified":"2025-12-11T08:20:43","modified_gmt":"2025-12-11T01:20:43","slug":"apps-script-automation-daily-report","status":"publish","type":"post","link":"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/","title":{"rendered":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah"},"content":{"rendered":"

$\"Cover$
\n
\n
\n
\n
\n Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah<\/title><br \/>\n<\/head><br \/>\n<body><\/p>\n<h1 id=\"apps-script-automation-daily-report-bot-panduan-langkah-demi-langkah\">Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah<\/h1>\n<section class=\"key-takeaways\">\n<h2 id=\"ringkasan-cepat\">Ringkasan Cepat<\/h2>\n<ul>\n<li>Otomasi laporan harian dari Google Sheet atau DB dengan <a href=\"https:\/\/developers.google.com\/apps-script\">Google Apps Script<\/a>.<\/li>\n<li>Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain).<\/li>\n<li>Simpan kredensial di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a> dan gunakan triggers terjadwal.<\/li>\n<li>Gunakan retry & observability (Logger \/ Cloud Logging) untuk stabilitas produksi.<\/li>\n<\/ul>\n<\/section>\n<nav class=\"toc\" aria-label=\"Daftar isi\">\n<h2 id=\"daftar-isi\">Daftar Isi<\/h2>\n<ul>\n<li><a href=\"#target-pembaca-intent\">Target Pembaca & Intent<\/a><\/li>\n<li><a href=\"#mengapa-perlu-daily-report-bot-masalah-solusi\">Mengapa Perlu Daily Report Bot (Masalah & Solusi)<\/a><\/li>\n<li><a href=\"#use-case-utama-varian\">Use\u2011Case Utama & Varian<\/a><\/li>\n<li><a href=\"#arsitektur-workflow\">Arsitektur & Workflow<\/a><\/li>\n<li><a href=\"#persiapan-requirement\">Persiapan & Requirement<\/a><\/li>\n<li><a href=\"#struktur-project-best-practice-kode\">Struktur Project & Best Practice Kode<\/a><\/li>\n<li><a href=\"#langkah-langkah-implementasi-ringkasan-langkah-utama\">Langkah\u2011langkah Implementasi<\/a><\/li>\n<li><a href=\"#contoh-kode-snippets\">Contoh Kode & Snippets<\/a><\/li>\n<li><a href=\"#template-pesan-formatting\">Template Pesan & Formatting \u2014 Slack vs WhatsApp<\/a><\/li>\n<li><a href=\"#error-handling-retries-observability\">Error Handling, Retries & Observability<\/a><\/li>\n<li><a href=\"#security-permissions\">Security & Permissions<\/a><\/li>\n<li><a href=\"#checklist-sebelum-live\">Checklist Sebelum Live<\/a><\/li>\n<li><a href=\"#keberatan-umum-faq-singkat\">Keberatan Umum & FAQ (singkat)<\/a><\/li>\n<li><a href=\"#mengapa-inreality-solutions-cocok\">Mengapa InReality Solutions Cocok untuk Proyek Otomasi Anda<\/a><\/li>\n<li><a href=\"#cta-konsultasi-demo-otomasi\">Konsultasi & Demo Otomasi<\/a><\/li>\n<\/ul>\n<\/nav>\n<article>\n<h2 id=\"target-pembaca-intent\">Target Pembaca & Intent<\/h2>\n<p>Panduan ini ditujukan untuk pengambil keputusan pemasaran\/operasi, developer internal, dan analis data di perusahaan B2B\/UKM. Fokusnya adalah how\u2011to teknis praktis untuk membangun workflow Apps Script lengkap dengan contoh kode, template pesan, dan checklist implementasi.<\/p>\n<h2 id=\"mengapa-perlu-daily-report-bot-masalah-solusi\">Mengapa Perlu Daily Report Bot (Masalah & Solusi)<\/h2>\n<p>Manual reporting memakan waktu dan rawan inkonsistensi. Solusi yang disarankan: gunakan <a href=\"https:\/\/developers.google.com\/apps-script\">Google Apps Script<\/a> untuk ekstraksi dari Sheets\/DB, transformasi menjadi summary, lalu kirim otomatis ke channel tim\u2014mengurangi delay dan menjaga keputusan berbasis data.<\/p>\n<h2 id=\"use-case-utama-varian\">Use\u2011Case Utama & Varian<\/h2>\n<h3 id=\"skenario-utama-laporan-penjualan-harian\">Skenario utama \u2014 Laporan Penjualan Harian<\/h3>\n<ul>\n<li>Data source: <a href=\"https:\/\/support.google.com\/docs\/answer\/3093343\">Google Sheet<\/a> (transaksi) atau database via JDBC\/REST. Contoh otomasi Sheet: <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-form-crm\/\">Form\u2192CRM Sheet<\/a>.<\/li>\n<li>Laporan ringkas: total penjualan, 5 produk teratas, perubahan vs hari sebelumnya.<\/li>\n<li>Delivery: Slack channel via <a href=\"https:\/\/api.slack.com\/messaging\/webhooks\">Incoming Webhook<\/a> atau WhatsApp via provider seperti <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">Twilio<\/a> (bisa juga provider lokal).<\/li>\n<\/ul>\n<h3 id=\"varian\">Varian<\/h3>\n<p>Inventori harian, ringkasan leads\/CRM, monitoring sistem\/alert. Contoh integrasi form\u2011to\u2011CRM dan appointment\/reminder lewat Sheets\u2192WA: <a href=\"https:\/\/inrealitysolutions.com\/id\/google-sheets-automation-appointment-whatsapp\/\">contoh appointment\u2192WA<\/a>. Untuk OCR\u2192sheet sebelum pemrosesan ringkasan lihat: <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-ocr-invoice\/\">contoh OCR invoice<\/a>.<\/p>\n<h2 id=\"arsitektur-workflow\">Arsitektur & Workflow (cara apps script workflow)<\/h2>\n<p>Diagram teks: Google Sheet \/ DB \u2192 Apps Script (extract \u2192 transform \u2192 build summary) \u2192 Notifier (send to slack\/wa) \u2192 Scheduled trigger (daily).<\/p>\n<p>Komponen penting: time\u2011driven trigger (<a href=\"https:\/\/developers.google.com\/apps-script\/guides\/triggers\/installable\">installable triggers<\/a>), <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a> untuk secrets, dan <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/url-fetch\/url-fetch-app\">UrlFetchApp<\/a> untuk panggil webhook\/API. Panduan desain pipeline automasi: <a href=\"https:\/\/inrealitysolutions.com\/id\/workflow-automasi-saas-panduan\/\">workflow automasi<\/a>.<\/p>\n<h2 id=\"persiapan-requirement\">Persiapan & Requirement<\/h2>\n<ul>\n<li>Akun Google & Google Sheet sample. Referensi <a href=\"https:\/\/support.google.com\/docs\/answer\/3093343\">fungsi QUERY di Sheets<\/a>.<\/li>\n<li>Akses ke <a href=\"https:\/\/developers.google.com\/apps-script\">Apps Script Editor<\/a>.<\/li>\n<li>Slack webhook atau Slack App token; WhatsApp provider (Twilio atau provider lokal). Twilio WA docs: <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\">Twilio WhatsApp<\/a>.<\/li>\n<li>OAuth scopes: Spreadsheet, UrlFetchApp, JDBC (jika perlu). Lihat <a href=\"https:\/\/developers.google.com\/apps-script\/concepts\/scopes\">Authorization Scopes<\/a>.<\/li>\n<li>Jika perlu OCR sebelum masuk Sheet, lihat contoh Zapier OCR invoice: <a href=\"https:\/\/inrealitysolutions.com\/id\/zapier-automation-ocr-invoice\/\">OCR\u2192sheet<\/a>.<\/li>\n<\/ul>\n<h2 id=\"struktur-project-best-practice-kode\">Struktur Project & Best Practice Kode<\/h2>\n<p>File direkomendasikan: config.js, utils.js, reportGenerator.js, notifier.js, triggers.js. Simpan token di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a>, hindari hardcoding. Referensi struktur project dan orkestrasi: <a href=\"https:\/\/inrealitysolutions.com\/id\/workflow-automasi-saas-panduan\/\">workflow automasi<\/a>.<\/p>\n<h2 id=\"langkah-langkah-implementasi-ringkasan-langkah-utama\">Langkah\u2011langkah Implementasi (ringkasan langkah utama)<\/h2>\n<h3 id=\"1-setup-google-sheet-contoh-query\">1) Setup Google Sheet & contoh QUERY<\/h3>\n<p>Gunakan <a href=\"https:\/\/support.google.com\/docs\/answer\/3093343\">fungsi QUERY<\/a> untuk pra-filter data di Sheet sebelum diproses di Apps Script.<\/p>\n<h3 id=\"2-buat-apps-script-project-dan-struktur-file\">2) Buat Apps Script project dan struktur file<\/h3>\n<p>Buat file sesuai struktur praktis dan simpan secrets di PropertiesService.<\/p>\n<h3 id=\"3-implement-querysheet\">3) Implement querySheet() \u2014 baca range & filter<\/h3>\n<pre><code>function querySheet() {\n const ss = SpreadsheetApp.openById(PropertiesService.getScriptProperties().getProperty('SHEET_ID'));\n const sheet = ss.getSheetByName('data');\n const values = sheet.getDataRange().getValues();\n \/\/ process rows -> return array of records\n return values.slice(1);\n}<\/code><\/pre>\n<h3 id=\"4-implement-querydb\">4) Implement queryDB() \u2014 JDBC\/REST<\/h3>\n<p>Jika menggunakan DB, ikuti panduan <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/jdbc\">JDBC<\/a> atau gunakan REST API dengan UrlFetchApp (amankan kredensial di PropertiesService).<\/p>\n<h3 id=\"5-implement-buildsummary\">5) Implement buildSummary(data)<\/h3>\n<p>Hitung total, top items, growth; kembalikan object summary yang siap diformat untuk delivery.<\/p>\n<h3 id=\"6-format-pesan\">6) Format pesan untuk Slack (Block Kit) dan WhatsApp (plain text)<\/h3>\n<p>Untuk Slack gunakan <a href=\"https:\/\/api.slack.com\/block-kit\">Block Kit<\/a>, untuk WhatsApp gunakan plain text template.<\/p>\n<h3 id=\"7-implement-sendtoslack-sendtowa\">7) Implement sendToSlack() & sendToWA()<\/h3>\n<pre><code>function sendToSlack(payload) {\n const url = PropertiesService.getScriptProperties().getProperty('SLACK_WEBHOOK');\n UrlFetchApp.fetch(url, {\n method: 'post',\n contentType: 'application\/json',\n payload: JSON.stringify(payload)\n });\n}<\/code><\/pre>\n<p>Untuk WhatsApp via Twilio, panggil endpoint Twilio sesuai <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">panduan Twilio WhatsApp<\/a>. Contoh integrasi lead routing: <a href=\"https:\/\/inrealitysolutions.com\/id\/whatsapp-crm-automotive-guide\/\">WhatsApp CRM Automotive<\/a>, <a href=\"https:\/\/inrealitysolutions.com\/id\/whatsapp-crm-jewelry-lead-routing\/\">WhatsApp CRM Jewelry<\/a>.<\/p>\n<h3 id=\"8-setup-scheduled-trigger-daily\">8) Setup scheduled trigger (daily)<\/h3>\n<pre><code>ScriptApp.newTrigger('mainDailyReport').timeBased().everyDays(1).atHour(7).create();<\/code><\/pre>\n<p>Lihat dokumentasi triggers: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/triggers\/installable\">Installable Triggers<\/a>.<\/p>\n<h3 id=\"9-test-end-to-end\">9) Test end\u2011to\u2011end & tambahkan logging\/monitoring<\/h3>\n<p>Tambahkan logging dan integrasi ke Cloud Logging untuk observability: <a href=\"https:\/\/cloud.google.com\/logging\/docs\">Cloud Logging<\/a>.<\/p>\n<h2 id=\"contoh-kode-snippets\">Contoh Kode & Snippets (highlight)<\/h2>\n<ul>\n<li><strong>querySheet()<\/strong> \u2014 contoh di atas.<\/li>\n<li><strong>buildSummary(data)<\/strong> \u2014 agregasi total dan top N (implementasi berdasarkan struktur data Anda).<\/li>\n<li><strong>sendToSlack(payload)<\/strong> \u2014 gunakan Block Kit JSON (<a href=\"https:\/\/api.slack.com\/block-kit\">Block Kit<\/a>).<\/li>\n<li><strong>sendToWA via Twilio<\/strong> \u2014 panggil Twilio API sesuai <a href=\"https:\/\/www.twilio.com\/docs\/whatsapp\/api\">dokumentasi<\/a>.<\/li>\n<\/ul>\n<h2 id=\"template-pesan-formatting\">Template Pesan & Formatting \u2014 Slack vs WhatsApp<\/h2>\n<p>Contoh singkat:<\/p>\n<ul>\n<li>WhatsApp (plain): “Laporan Harian \u2022 Total: Rp X\\nTop 3 Produk: A, B, C\\nGrowth vs Kemarin: +Y%”.<\/li>\n<li>Slack (Block Kit): header, section KPI, context line; tambahkan emoji untuk highlight; lihat <a href=\"https:\/\/api.slack.com\/block-kit\">contoh Block Kit<\/a>.<\/li>\n<\/ul>\n<h2 id=\"error-handling-retries-observability\">Error Handling, Retries & Observability<\/h2>\n<p>Gunakan try\/catch dengan pola retry (exponential backoff) dan <code>Logger.log()<\/code>. Untuk skala, gunakan <a href=\"https:\/\/cloud.google.com\/logging\/docs\">Cloud Logging<\/a>. Kirim notifikasi on\u2011failure ke admin Slack channel untuk tindakan cepat.<\/p>\n<h2 id=\"security-permissions\">Security & Permissions<\/h2>\n<p>Simpan secrets di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a>, gunakan minimal OAuth scopes, rencanakan rotasi token dan batasi akses project script sesuai prinsip least privilege.<\/p>\n<h2 id=\"checklist-sebelum-live\">Checklist Sebelum Live<\/h2>\n<ul>\n<li>Validasi data & output summary.<\/li>\n<li>Token tersimpan di PropertiesService dan tidak di\u2011hardcode.<\/li>\n<li>Rate limit & retry handling diimplementasikan.<\/li>\n<li>Notifikasi error aktif dan monitoring tersedia.<\/li>\n<li>Backup plan manual jika notifikasi gagal.<\/li>\n<\/ul>\n<h2 id=\"keberatan-umum-faq-singkat\">Keberatan Umum & FAQ (singkat)<\/h2>\n<section class=\"faq\" aria-labelledby=\"keberatan-umum-faq-singkat-list\">\n<h3 id=\"keberatan-umum-faq-singkat-list\">FAQ<\/h3>\n<div class=\"faq-item\">\n<h4 id=\"faq-aman-menyimpan-token-di-script\">Apakah aman menyimpan token di Script?<\/h4>\n<p>Simpan di <a href=\"https:\/\/developers.google.com\/apps-script\/reference\/properties\/properties-service\">PropertiesService<\/a> dan rencanakan rotasi token. Hindari hardcode serta batasi akses project.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-data-terlalu-besar-untuk-sheet\">Data terlalu besar untuk Sheet?<\/h4>\n<p>Gunakan database dan hubungkan via JDBC\/REST. Panduan JDBC: <a href=\"https:\/\/developers.google.com\/apps-script\/guides\/jdbc\">JDBC guide<\/a>.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-bisa-kirim-wa-tanpa-twilio\">Bisa kirim WA tanpa Twilio?<\/h4>\n<p>Ya \u2014 ada provider WhatsApp Business API lokal\/alternatif. Pilih provider yang sesuai anggaran, SLA, dan compliance.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-jam-penjadwalan-dan-timezone\">Bagaimana dengan timezone dan jadwal?<\/h4>\n<p>Atur trigger menggunakan waktu lokal yang sesuai akun Google\/Drive dan uji di lingkungan staging. Gunakan logging timestamp untuk verifikasi.<\/p>\n<\/p><\/div>\n<div class=\"faq-item\">\n<h4 id=\"faq-cara-menguji-end-to-end\">Bagaimana menguji end\u2011to\u2011end sebelum live?<\/h4>\n<p>Gunakan test sheet\/data sandbox, webhook test channel Slack, dan nomor WhatsApp sandbox (mis. Twilio sandbox). Tambahkan verbose logging dan jalankan trigger manual untuk verifikasi.<\/p>\n<\/p><\/div>\n<\/section>\n<h2 id=\"mengapa-inreality-solutions-cocok\">Mengapa InReality Solutions Cocok untuk Proyek Otomasi Anda<\/h2>\n<ul>\n<li>Keahlian end\u2011to\u2011end Otomasi & Agentic AI untuk integrasi sistem CRM\/ERP.<\/li>\n<li>Praktik keamanan data & manajemen kredensial.<\/li>\n<li>Dukungan deployment, monitoring, dan dokumentasi untuk tim operasi.<\/li>\n<\/ul>\n<p>Lihat layanan kami: <a href=\"\/id\/layanan\/otomasi-ai\/\">\/layanan\/otomasi-ai<\/a> dan portofolio: <a href=\"\/id\/portofolio\/\">\/portofolio<\/a>.<\/p>\n<h2 id=\"cta-konsultasi-demo-otomasi\">Konsultasi & Demo Otomasi<\/h2>\n<p>Butuh implementasi end\u2011to\u2011end atau demo teknis? Ajukan konsultasi singkat untuk menilai workflow dan estimasi solusi. Kontak: <a href=\"\/id\/kontak-konsultasi\/\">\/kontak-konsultasi<\/a><\/p>\n<section id=\"ringkasan-manfaat\">\n<h2>Ringkasan manfaat<\/h2>\n<p>Dengan apps script automation daily report bot Anda mendapatkan laporan konsisten, lebih cepat, dan terintegrasi ke channel tim (Slack\/WA) sehingga keputusan operasional lebih tepat waktu dan terukur.<\/p>\n<\/section>\n<\/article>\n<p><\/body><br \/>\n<\/html><\/p>","protected":false},"excerpt":{"rendered":"<p>Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial […]<\/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-7224","post","type-post","status-publish","format-standard","hentry","category-ai-automations"],"yoast_head":"\n<title>Apps Script Automation Daily Report Bot \u2014 Panduan 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\/apps-script-automation-daily-report\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah\" \/>\n<meta property=\"og:description\" content=\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/\" \/>\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=\"2025-12-11T01:20:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-11T01:20:43+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=\"5 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\"},\"author\":{\"name\":\"Maya Ananta\",\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a\"},\"headline\":\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah\",\"datePublished\":\"2025-12-11T01:20:37+00:00\",\"dateModified\":\"2025-12-11T01:20:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\"},\"wordCount\":964,\"publisher\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#organization\"},\"articleSection\":[\"AI Automations\"],\"inLanguage\":\"id\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\",\"url\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\",\"name\":\"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia\",\"isPartOf\":{\"@id\":\"https:\/\/inrealitysolutions.com\/id\/#website\"},\"datePublished\":\"2025-12-11T01:20:37+00:00\",\"dateModified\":\"2025-12-11T01:20:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/inrealitysolutions.com\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apps Script Automation Daily Report Bot \u2014 Panduan 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":"Apps Script Automation Daily Report Bot \u2014 Panduan 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\/apps-script-automation-daily-report\/","og_locale":"id_ID","og_type":"article","og_title":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah","og_description":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial […]","og_url":"https:\/\/inrealitysolutions.com\/id\/apps-script-automation-daily-report\/","og_site_name":"InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","article_publisher":"https:\/\/www.facebook.com\/InRealitySolutions\/","article_published_time":"2025-12-11T01:20:37+00:00","article_modified_time":"2025-12-11T01:20:43+00:00","author":"Maya Ananta","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Maya Ananta","Estimasi waktu membaca":"5 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#article","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/"},"author":{"name":"Maya Ananta","@id":"https:\/\/inrealitysolutions.com\/id\/#\/schema\/person\/8bf31cc88af0e2066d9d0f57dd52a80a"},"headline":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah","datePublished":"2025-12-11T01:20:37+00:00","dateModified":"2025-12-11T01:20:43+00:00","mainEntityOfPage":{"@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/"},"wordCount":964,"publisher":{"@id":"https:\/\/inrealitysolutions.com\/id\/#organization"},"articleSection":["AI Automations"],"inLanguage":"id"},{"@type":"WebPage","@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/","url":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/","name":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah - InReality Solutions \u2014 AR\/VR, Virtual Tours & AI Automations Indonesia","isPartOf":{"@id":"https:\/\/inrealitysolutions.com\/id\/#website"},"datePublished":"2025-12-11T01:20:37+00:00","dateModified":"2025-12-11T01:20:43+00:00","breadcrumb":{"@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/inrealitysolutions.com\/apps-script-automation-daily-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/inrealitysolutions.com\/id\/"},{"@type":"ListItem","position":2,"name":"Apps Script Automation Daily Report Bot \u2014 Panduan 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":"Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Apps Script Automation Daily Report Bot \u2014 Panduan Langkah demi Langkah Ringkasan Cepat Otomasi laporan harian dari Google Sheet atau DB dengan Google Apps Script. Bangun summary (total, top item, growth) lalu kirim terjadwal ke Slack atau WhatsApp (Twilio atau provider lain). Simpan kredensial…","_links":{"self":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7224","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=7224"}],"version-history":[{"count":1,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7224\/revisions"}],"predecessor-version":[{"id":7225,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/posts\/7224\/revisions\/7225"}],"wp:attachment":[{"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/media?parent=7224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/categories?post=7224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/inrealitysolutions.com\/id\/wp-json\/wp\/v2\/tags?post=7224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}