Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities
DOI:
https://doi.org/10.37012/jtik.v11i1.2242Abstract
Currently, data security is very crucial in a company. Data hacking is increasingly common. Tokopedia experienced a data hack estimated at 91 million user accounts and 7 million merchant accounts. This data is then sold via the dark web, which seriously endangers user privacy and safety. Protection of personal data against hackers from outside is increasingly needed. Management of data recaps and monitoring employee data access in the largest retail company in Indonesia is carried out by the Human Resources division. Due to the large number of employees, daily access to employee data such as attendance is prone to misuse because detection of illegal activities on data is still done manually. In this research, a system based on Google Spreadsheet and Apps Script was created. which is able to detect illegal activities against employee databases. The system is able to accurately categorize logs based on account and IP address, distinguishing between normal and suspicious logs. The system is able to convert a spreadsheet containing data access recaps into an Excel file and send it to the specified email. System testing was carried out on Human Resources division employees through 6 tests on all system features. The results show that all system outputs are exactly as expected. The system helps Human Resources division employees observe data changes without having to access the database, making it easier to detect illegal data access.
Downloads
Published
Issue
Section
Citation Check
License
Copyright (c) 2025 Jek Siang Jong, Rio Rian Rivanka, Argo Wibowo

This work is licensed under a Creative Commons Attribution 4.0 International License.
Jurnal Teknologi Informatika dan Komputer allows readers to read, download, copy, distribute, print, search, or link to the full texts of its articles and allow readers to use them for any other lawful purpose. The journal allows the author(s) to hold the copyright without restrictions. Finally, the journal allows the author(s) to retain publishing rights without restrictions Authors are allowed to archive their submitted article in an open access repository Authors are allowed to archive the final published article in an open access repository with an acknowledgment of its initial publication in this journal.
Jurnal Teknlogi Informatika dan Komputer is licensed under a Creative Commons Attribution 4.0 International License.