Pengembangan Sistem Pendukung Keputusan Kontinu (Continuous Decision Support System) Berbasis Otomatisasi Laporan Konsolidasi menggunakan Google Apps Script dan Telegram API

Jaka Marfenda Satriana; Linda Wahyu Widianti

doi:10.55606/jutiti.v6i2.7413

Authors

Jaka Marfenda Satriana Sekolah Tinggi Manajemen Informatika dan Komputer (STI&K)
Linda Wahyu Widianti Sekolah Tinggi Manajemen Informatika dan Komputer (STI&K)

DOI:

https://doi.org/10.55606/jutiti.v6i2.7413

Keywords:

Continuous Decision Support System, Enterprise Architecture, Google Apps Script, Telegram API, Report Automation

Abstract

The manual process of consolidated reporting often results in delays in information delivery, data inconsistencies, and low effectiveness in distributing reports to decision-makers. This study aims to develop a Continuous Decision Support System based on automated consolidated reporting using Google Apps Script and the Telegram API, and to analyze it from an Enterprise Architecture perspective. The research employs a Design Science Research approach through the stages of problem identification, architectural design, system development, testing, and evaluation. The system is designed by utilizing Google Sheets as the data source, Google Apps Script as the automation engine, and the Telegram API as the information distribution channel. The results show that the proposed system is capable of integrating data reading, validation, report consolidation, summary generation, and automated notification delivery processes. From an Enterprise Architecture perspective, the system forms a lightweight integration architecture that connects the business, data, application, and technology layers. This study concludes that the integration of Google Apps Script and the Telegram API can support faster, more structured, and continuous information delivery for decision-makers.

Downloads

Download data is not yet available.

References

Alfareza, F., & Aditya, A. (2024). Clockify and BOT Telegram integration in employee performance measurement applications development. International Journal of Innovation in Enterprise System, 8(1), 101–111. https://doi.org/10.25124/ijies.v8i01.223

Ansyori, R., Qodarsih, N., & Soewito, B. (2018). A systematic literature review: Critical success factors to implement enterprise architecture. Procedia Computer Science, 135, 43–51. https://doi.org/10.1016/j.procs.2018.08.148

Bintang, A., Hananto, A. L., & Hananto, A. (2025). Telegram BOT application development integration with Google Sheets for sending service reporting. Journal of Artificial Intelligence and Engineering Applications (JAIEA), 4(3), 2208–2214. https://doi.org/10.59934/jaiea.v4i3.1136

Google Developers. (2026). Apps Script overview. Google for Developers. https://developers.google.com/apps-script/overview

Hevner, A. R., March, S. T., Park, J., & Ram, S. (2004). Design science in information systems research. MIS Quarterly, 28(1), 75–105. https://doi.org/10.2307/25148625

Möhring, M., Keller, B., Schmidt, R., Sandkuhl, K., & Zimmermann, A. (2023). Digitalization and enterprise architecture management: A perspective on benefits and challenges. SN Business and Economics, 3(2), 1–21. https://doi.org/10.1007/s43546-023-00426-3

Peffers, K., Tuunanen, T., Rothenberger, M. A., & Chatterjee, S. (2007). A design science research methodology for information systems research. Journal of Management Information Systems, 24(3), 45–77. https://doi.org/10.2753/MIS0742-1222240302

Sprague, R. H. (1980). A framework for the development of decision support systems. MIS Quarterly, 4(4), 1–26. https://doi.org/10.2307/248957

Srisawat, S., Wannapiroon, P., & Nilsook, P. (2024). Distributed digital enterprise architecture for transformation of educational organizations. TEM Journal, 13(2), 1645–1657. https://doi.org/10.18421/TEM132-77

Szukits, Á., & Móricz, P. (2024). Towards data-driven decision making: The role of analytical culture and centralization efforts. Review of Managerial Science, 18(10). https://doi.org/10.1007/s11846-023-00694-1

Telegram. (n.d.). Telegram Bot API. Retrieved June 23, 2026, from https://core.telegram.org/bots/api

The Open Group. (2022). The TOGAF Standard (10th ed.). https://www.opengroup.org/togaf

Verhoef, P. C., Broekhuizen, T., Bart, Y., Bhattacharya, A., Dong, J. Q., Fabian, N., & Haenlein, M. (2021). Digital transformation: A multidisciplinary reflection and research agenda. Journal of Business Research, 122, 889–901. https://doi.org/10.1016/j.jbusres.2019.09.022

Vial, G. (2019). Understanding digital transformation: A review and a research agenda. The Journal of Strategic Information Systems, 28(2), 118–144. https://doi.org/10.1016/j.jsis.2019.01.003

Wulan, S., & Dirgahayu, T. (2024). Pengembangan sumber daya manusia menggunakan Google Apps Script. Edusaintek: Jurnal Pendidikan, Sains dan Teknologi, 11(4), 2238–2254. https://doi.org/10.47668/edusaintek.v11i4.1448

Zhou, Y., Chen, L., Zhou, X., & Hu, S. (2024). Key factors and path selection for enterprise digital transformation: Configuration analysis based on fsQCA. Frontiers in Sustainability, 5. https://doi.org/10.3389/frsus.2024.1366129