Utilization of Telegram Bot for Integrated Data Visualization with Google Sheets at PT Telkom Cibitung

Abstract

In today’s digital age, organizations demand real-time, accurate, and efficient access to data in order to support decision-making and enhance operational workflows. This research focuses on the development and implementation of a Telegram Bot integrated with Google Sheets to improve data visualization and internal coordination at PT Telkom Cibitung. Prior to this innovation, the process of retrieving data from Google Sheets and sharing it via Telegram was conducted manually, leading to frequent errors, delays in communication, and inefficiencies in data-driven tasks—particularly within the sales division.The study adopts a descriptive-analytical method to examine existing workflows and to design a solution that automates data retrieval using a bot. The Telegram Bot was programmed to fetch and present key data points directly from Google Sheets based on user input, reducing the dependency on manual operations. The system was tested within the sales division and demonstrated significant improvements in speed, accuracy, and usability.Based on the analysis and findings, it can be concluded that the integration of Telegram Bot with Google Sheets provides a viable and scalable solution to the problems previously encountered at PT Telkom Cibitung. This approach not only eliminates the risk of data misinterpretation and human error but also enhances interdepartmental coordination. The implementation of such automation technology reflects a strategic move towards digital transformation and highlights the value of low-code solutions in business environments with limited IT resources.