Otomatisasi Monitoring Stok Logistik Terdistribusi Berbasis Rapid Application Development, GAS, dan Telegram Bot

Wahyu Setianto Dwi Aji; Asri Samsiar Ilmananda

doi:10.30606/rjti.v5i2.4741

Authors

Wahyu Setianto Dwi Aji Universitas Merdeka Malang
Asri Samsiar Ilmananda Universitas Merdeka Malang

DOI:

https://doi.org/10.30606/rjti.v5i2.4741

Keywords:

Rapid Application Development, Google Apps Script, Telegram Bot API, Inventory Management System, Real-Time Monitoring

Abstract

Daily logistics reporting latency on an H+1 scale across 24 active warehouses at PT Telkom Akses Area Malang triggers the risk of delayed Network Terminal Equipment (NTE) device installations at customers' homes due to stock shortage (understock) constraints, as well as storage space inefficiency caused by asset accumulation (overstock). This condition stems from conventional workflows where warehouse admins must manually recapitulate data using passive spreadsheets. This study aims to transform this manual mechanism into a real-time automated monitoring system using the Rapid Application Development (RAD) method. The developed system integrates Google Apps Script (GAS) technology as a cloud-based computational logic hub and the Telegram Bot API as an automated notification gateway to the managerial coordination group. Inventory control is autonomously managed by a two-way control logic based on Safety Stock (SS) and Maximum Stock (Smax) parameters to monitor 8,256 units of active ONT devices. Implementation results demonstrate that this automation successfully reduces the latency of sending critical stock reports from a daily scale to under 5 seconds with a 0% error rate (zero-error rate). The main contribution of this research is providing proactive stock visibility for warehouse admins, eliminating the risk of human error due to manual input processes, and accelerating strategic decision-making in the Supply Chain division of PT Telkom Akses Area Malang to maintain service sustainability for customers.

Downloads

Download data is not yet available.

References

B. E. Bakkouri, S. Raki, and T. Belgnaoui, “The Role of Chatbots in Enhancing Customer Experience: Literature Review,” Procedia Computer Science, vol. 203, pp. 432–437, Jan. 2022, doi: 10.1016/j.procs.2022.07.057.

A. R. Gagliardi, G. Festa, A. Usai, D. Dell’Anno, and M. Rossi, “The Impact of Knowledge Management on the Digital Supply Chain – A Bibliometric Literature Review,” International Journal of Physical Distribution & Logistics Management, vol. 53, no. 5–6, pp. 612–627, Mar. 2023, doi: 10.1108/IJPDLM-07-2022-0206.

R. N. Syafitri, “Studi Komparatif Penggunaan Teknologi Informasi dalam Manajemen Rantai Pasok di Industri Manufaktur,” Jurnal Sistem Informasi, Teknik Komputer dan Teknologi Pendidikan, vol. 4, no. 2, pp. 56–59, Apr. 2025.

I. G. Irawan, G. Nata, and I. M. Santosa, “Sistem Informasi Data Troubleshooting Yang Terintegrasi Dengan Bot Telegram,” SPINTER 2024, vol. 1, no. 2, Apr. 2024, Accessed: Apr. 07, 2026. [Online]. Available: https://spinter.stikom-bali.ac.id/index.php/spinter/article/view/131

D. A. Haryono, R. Hidayati, M. Andarwati, and A. S. Ilmananda, “Sistem Informasi Akuntansi Berbasis Web untuk Pengelolaan Persediaan Sparepart Sepeda Motor dengan Pendekatan Waterfall,” Jurnal Sosial Teknologi, vol. 5, no. 1, p. 31811, Feb. 2025, doi: 10.59188/jurnalsostech.v5i1.31811.

E. Kurniawati and A. Ikhwan, “Perancangan Sistem Informasi Manajemen Inventaris Kontrol Stok Barang Berbasis Web,” JTSIA, vol. 6, no. 3, pp. 408–415, Jul. 2023, doi: 10.32493/jtsi.v6i3.30881.

A. Muarif and A. H. Tantri, “Perancangan Sistem Informasi Inventaris Berbasis Web Menggunakan Permodelan UML,” Journal of Information System and Application Development, vol. 3, no. 2, pp. 112–118, Sep. 2025, doi: 10.26905/jisad.v3i2.16127.

D. C. Y. Rindho and T. Dirgahayu, “Pengembangan Sistem Informasi Toko Kelontong Berbasis Google Apps Script pada Toko Asih,” Technologia: Jurnal Ilmiah, vol. 15, no. 4, pp. 930–941, Oct. 2024, doi: 10.31602/tji.v15i4.16708.

A. Triawan and A. R. Y. Siboro, “Penerapan Application Programming Interface (API) Pada Push Notification Untuk Informasi Monitoring Stok Barang Minim,” TeknoIS: Jurnal Ilmiah Teknologi Informasi dan Sains, vol. 11, no. 2, pp. 107–114, Nov. 2021, doi: 10.36350/jbs.v11i2.120.

D. Novita, “Otomatisasi Pembuatan Laporan Keuangan Berbasis Google Spreadsheet Menggunakan Bot Telegram,” Undergraduate Thesis, Sekolah Tinggi Teknologi Terpadu Nurul Fikri, 2024. Accessed: Nov. 11, 2025. [Online]. Available: https://repository.nurulfikri.ac.id/id/eprint/561/

E. Keith, “Optimizing Inventory Management through Advanced Forecasting Techniques in Supply Chains,” European Journal of Supply Chain Management, vol. 1, no. 1, pp. 22–30, 2023.

R. A. Brahmantyo, J. Wibowo, and V. Nurcahyawati, “Manajemen Persediaan Menggunakan Metode Safety Stock dan Reorder Point,” Jurnal Sains dan Informatika, vol. 9, no. 1, pp. 89–99, Aug. 2023, doi: 10.34128/jsi.v9i1.431.

F. Hariadi, R. R. H. Enda, F. I. Prasetyo, and D. A. P. Bangu, “Implementasi Teknologi Google Apps Script dan PHP dalam Otomatisasi Pengelolaan Data dan Pembuatan Dokumen Kerja Sama (OIA UNKRISWINA),” BESIRU: Jurnal Pengabdian Masyarakat, vol. 3, no. 1, pp. 212–217, Jan. 2026, doi: 10.62335/besiru.v3i1.2231.

A. D. Arini, “Implementasi Strategis Sistem Informasi Akuntansi Melalui Analisis Komparatif,” Jurnal Riset Akuntansi, vol. 2, no. 2, pp. 320–328, May 2024, doi: 10.54066/jura-itb.v2i2.1853.

P. N. Anggraini, K. Harianto, and H. Sutapa, “Implementasi Safety Stock dalam Pengendalian Persediaan Kerupuk pada PT. Merpati Mas Nusantara Tahun 2022 – 2025 di Kabupaten Kediri,” Musytari: Jurnal Manajemen, Akuntansi, dan Ekonomi, vol. 19, no. 10, pp. 11–20, Jun. 2025, doi: 10.2324/mvcm4d15.

P. A. W. Ariyanto and R. Soelistijadi, “Implementasi NodeMCU sebagai Sistem Deteksi Dini Bahaya Banjir di Purwodadi Berbasis Web dengan Notifikasi Bot Telegram,” Jurnal Teknologi dan Manajemen Informatika, vol. 8, no. 2, pp. 64–73, Dec. 2022, doi: 10.26905/jtmi.v8i2.7902.

F. Nurdiyansyah and I. Akbar, “Implementasi Algoritma K-Means untuk Menentukan Persediaan Barang pada Poultry Shop,” Jurnal Teknologi dan Manajemen Informatika, vol. 7, no. 2, pp. 86–94, Dec. 2021, doi: 10.26905/jtmi.v7i2.6377.

Sukiman and R. Kasela, “Analisis dan Perancangan Sistem Informasi Inventarisasi Aset Barang dan Fasilitas Berbasis Web di Villa Kopi Ciwidey,” J-SIKA: Jurnal Sistem Informasi Karya Anak Bangsa, vol. 7, no. 02, pp. 90–99, 2025.

L. Judijanto and A. Zulfikri, “Advancing Supply Chain Resilience Through Cloud-Based Logistics: A Narrative Review,” Sinergi International Journal of Logistics, vol. 2, no. 3, pp. 147–159, Aug. 2024, doi: 10.61194/sijl.v2i3.625.