Telegram BOT Application Development Integration with Google Sheets for Sending Service Reporting

Adrian Bintang; April Lia Hananto; Agustia Hananto

doi:10.59934/jaiea.v4i3.1136

Authors

Adrian Bintang Universitas Buana Perjuangan Karawang
April Lia Hananto Universitas Buana Perjuangan Karawang
Agustia Hananto Universitas Buana Perjuangan Karawang

DOI:

https://doi.org/10.59934/jaiea.v4i3.1136

Keywords:

Telegram bot; Google sheets; Delivery services; Real-time monitoring; Information system

Abstract

The development of digital communication technology has changed the way businesses operate, including in the delivery service sector. This research aims to develop a Telegram bot application that is integrated with Google Sheets to facilitate reporting and data management of sending services. Telegram bots were chosen because of their ease of access and wide use in Indonesia. The development method uses an agile approach with the stages of needs analysis, system design, implementation, and testing. Integration with the Google Sheets API allows for real-time storage and management of data. The test results show that the app can handle order reporting, shipment tracking, and generate automated reports with an accuracy rate of 98.5%. The system successfully reduced the report processing time from 2 hours to 5 minutes and increased operational efficiency by 75%. The bot can handle up to 1000 transactions per day with an average response time of 2.3 seconds. The implementation of this system provides a cost-effective and user-friendly solution for MSMEs in the field of delivery services.

Downloads

Download data is not yet available.

References

Bahrudin, D., & Izmi Badruzzaman, U. (2021). Design of a WEB-Based Activity Report Information System at PT. Areon Bandung. Indonesian Journal of Socio-Technology, 2(12), 2203–2213. https://doi.org/10.36418/jist.v2i12.312

Candra, D., Rindho, Y., Dirgahayu, T., Informatics, P. S., Industry, F. T., Informatics, P. S., & Industry, F. T. (2024). Development of a Grocery Store Information System Based on Google Apps Script at Toko Asih 1. 15(4), 930–941.

Fahrijal, T., Hartawan, R., Study, P., Informatics, T., High, S., Informatics, M., & Center, K. J. (n.d.). DESIGN OF NTE DEVICE MONITORING WEB APPLICATION BY TECHNICIANS IN PT WAREHOUSE UNIT. TELKOM ACCESS. 4, 367–382.

Faizal, A. A., & Sanusi, A. (2022). The design of the "Problem Solving Management" Case User Information System using a web-based Telegram BOT at PT. Gunung Amal SolutionInternational. Journal of Education and Counseling, 4(6), 3431–3436.

Fajryn, F., Setiawan, H., & Sartika, D. (2024). Digitization of the water pH monitoring system at the wastewater management plant of the BSPJI Palembang laboratory. Journal of Computer Science and Information Systems, 5(2), 139–148.

Farma, J. (2023). Implementation of automatic system bells using Bluetooth: improves efficiency and user experience. Journal of Data Portal, 3(3), 1–22. http://portaldata.org/index.php/portaldata/article/view/355

Gaddafi, S. A., & Computer, T. (2023). Applying iot technology to energy management and energy saving on cloud computing infrastructure. 3(1).

Larasati, P. D., & Sa'ba, N. F. (2021). The design of a Web-Based Attendance Reporting System at PT. Solar Control Specialist (SCS). SISKOM-KB Journal (Computer Systems and Artificial Intelligence), 5(1), 74–80. https://doi.org/10.47970/siskom-kb.v5i1.231

Nugraha, P. W., Muhammad, M. I., Karmanto, B., & Khasanah, L. (2024). Designing Telegram Chatbot to Support the Outpatient Registration Process for General Patients at the Sedong Health Center, Cirebon Regency. 12(2), 66–76. https://doi.org/10.47007/inohim.v12i2.566

Panja, E., & Manongga, D. (2023). The design of a web-based financial information system at GKS Mauliru uses the rapid application development method. JATI (Student Journal of Informatics Engineering), 7(1), 579–584. https://doi.org/10.36040/jati.v7i1.6401

Pranoto, S., Sutiono, S., Sarifudin, & Nasution, D. (2024). The application of UML in the design of a development reporting and evaluation information system in the Development Administration Section of the Tebing Tinggi City Regional Secretariat. Surplus: Journal of Economics and Business, 2(2), 384–401. https://qjurnal.my.id/index.php/sur/article/view/866

Rahmawati, L., Priyatna, B., Hananto, A., & Solehudin, A. (2023). Web-Based Welding Workshop Project Management Information System: A Case Study of Two Daughters Welding Workshops. Unsika Electronic Journal of Information Systems, 1(1), 25–30.

D. K. Hakim and S. A. Nugroho, "Telegram Bot Implementation for Mikrotik Router Monitoring," Scientology, vol. 16, no. 2, pp. 151–157, 2020, doi: 10.30595/st.v16i2.7132.

I. A. Kamal and A. B. Cahyono, "The Utilization of Dialogflow-Based Chatbots and Google Sheet Api for Storing Online Store Consumer Complaint Reports," Automata, vol. 3, no. 2, pp. 1–5, 2022, [Online]. Available: https://journal.uii.ac.id/AUTOMATA/article/download/24201/14033

M. Katamin, S. Aulia, and S. Suliyono, "The Design of Telegram Bots for Securing the Key of the Optical Distribution Cabinet (ODC) of the Maintenance/Optima Division of PT. "Lakeside Lake," eProceedings Appl. Sci., vol. 9, no. 1, pp. 151–157, 2023.

A. U. Putra and A. Prihanto, "The Utilization of Whatsapp Chatbots for the Convenience of Users in Monitoring Cryptocurrency Prices," vol. 06, pp. 948–957, 2025.

Eka Yuniar and Heri Purnomo, "Implementation of the 'Alitta' Virtual Assistant chatbot from IAARD as an Information Center at IACRI," Antivirus J. Ilm. Tech. Inform., vol. 13, no. 1, pp. 24–35, 2019, doi: 10.35457/antivirus.v13i1.714.

Y. Prabowo, S. Aulia, and R. Maulana, "Making Telegram Bots for Assurance Technicians with Push Notification Method at Pt Telkom Akses Rajawali Kota Bandung," e-Proceeding Appl. Sci., vol. 9, no. 1, pp. 113–118, 2023.

R. Andriani and A. Sa'di, "SYSTEMASI: Journal of Telegram Bot Notification On Network Device Monitoring System," vol. 13, pp. 74–82, 2024, [Online]. Available: http://sistemasi.ftik.unisi.ac.id

N. A. Haqimi and R. T. Kusuma, "Timeline reminder system bot and telegram assistant chatbot for a university student and lecturer," J. Soft Comput. Explore., vol. 4, no. 4, pp. 186–194, 2023, doi: 10.52465/joscex.v4i4.221.

A. W. Budiman, A. Setiawan, and S. Nugroho, "Development of a Web-Based Information Service System by Utilizing AI on ChatGPT," J. Techno. Then Sist. Business-JTEXIS Inf., vol. 5, no. 4, p. 592, 2023, [Online]. Available: http://jurnal.unidha.ac.id/index.php/jteksishttps://doi.org/10.47233/jteksis.v5i4.1068

L. Rohmawati, M. A. Nugroho, and W. Wagito, "Implementation of Chatbot on Whatsapp for Server Resource Monitoring," J. Inf. Syst. Great., vol. 4, no. 2, pp. 107–112, 2023, doi: 10.24076/joism.2023v4i2.960.

R. W. Kartika, J. F. Liem, and D. Widjaja, "The Use of Ukrida ChatBot in the Health Examination of Ukrida Hospital Employees," pp. 247–258.

A. A. Chandra, V. Nathaniel, F. R. Satura, and F. D. Adhinata, "Development of Telegram-Based Student Information Chatbot with Natural Language Processing Method," J. ICTEE, vol. 3, no. 1, p. 20, 2022, doi: 10.33365/jictee.v3i1.1886.

Ikwan and Y. M. Djaksana, "Design of an Android-Based Electrical Power Usage Monitoring and Control System," J. Ris. Sist. Inf. and Technology. Inf., vol. 3, no. 1, pp. 13–24, 2021, doi: 10.52005/jursistekni.v3i1.66.