Automating Cloud-Based Device Log Processing Using Google Apps Script

Muhammad Hasbi Asshidiqi; Muhammad Hilman Naufal; Muhamad Fikri; Oky Tria Saputra

Authors

Muhammad Hasbi Asshidiqi Politeknik IDN Bogor
Muhammad Hilman Naufal Politeknik IDN Bogor
Muhamad Fikri Politeknik IDN Bogor
Oky Tria Saputra Politeknik IDN Bogor

Keywords:

Google Apps Script, Device Log, Automation, Cloud Computing, Network Management

Abstract

Device log management is often a challenge for system administrators due to large data volumes and unstructured formats. Manual processing is time-consuming and prone to human error. This research aims to implement an automated device log processing system utilizing Google Apps Script (GAS) as a cloud-based processing engine. The research method used is Research and Development (R&D), consisting of log data collection, automation script design, integration with Google Sheets as a database, and functional testing. The results show that the developed system is capable of parsing log data in real-time, categorizing log types based on urgency levels, and presenting them in structured reports. Efficiency testing demonstrates a reduction in data processing time by [X]% compared to conventional methods. The conclusion of this study is that Google Apps Script provides a cost-effective and efficient solution for managing device logs for medium-scale institutions.

References

K. B. Sowmya And A. Thejaswini, “Systematising Troubleshooting Of Disputes In Network,” International Journal Of Reconfigurable And Embedded Systems (Ijres), Vol. 10, No. 1, P. 32, 2021, Doi: 10.11591/Ijres.V10.I1.Pp32-36.

I. Boyagane, O. Katulanda, S. Ranathunga, And S. Perera, “Vue4logs - Automatic Structuring Of Heterogeneous Computer System Logs,” Arxiv, Vol. Abs/2202.0, 2022.

J. J. Siang, R. R. Rivanka, And A. Wibowo, “Automation Of Daily Access Data Recap Of Employee Data Tables Using Apps Script To Detect Illegal Activities,” Jurnal Teknologi Informatika Dan Komputer, 2025.

N. Rawindaran, A. Jayal, E. Prakash, And C. Hewage, “Cost Benefits Of Using Machine Learning Features In Nids For Cyber Security In Uk Small Medium Enterprises (Sme),” Future Internet, Vol. 13, P. 186, 2021.

C. Macaneata, “Overview Of Security Information And Event Management Systems,” Informatica Economica, 2024.

W. Lin, J. Ma, T. Li, H. Ye, J. Zhang, And Y. Xiao, “Crptac: Find The Attack Chain With Multiple Encrypted System Logs,” Electronics, 2024.

A. I. Asry, “Implementation Of Google App Script In Cloud-Based Data Search Application,” Jeat : Journal Of Electrical And Automation Technology, 2022.

O. Vasenko, V. Yakuba, And I. Havrylov, “Automating Data Analysis In Scientific Research Of Future Education Specialists Using The Google Apps Script Platform,” Professional Education: Methodology, Theory And Technologies, 2023.

D. K. Anggraeni And T. D. Widajantie, “Peningkatan Efisiensi Administrasi Keuangan Melalui Sistem Penagihan Otomatis: Studi Kasus Pada Pt Java Energy Semesta,” Jurnal Akutansi Manajemen Ekonomi Kewirausahaan (Jamek), 2025.

O. Tirschwell And N. J. Horton, “Pivoting The Paradigm: The Role Of Spreadsheets In K-12 Data Science,” Arxiv, Vol. Abs/2506.0, 2025.

T. Wijaya, “Pemanfaatan Google App Script Dalam Merancang Aplikasi Web Guna Meningkatkan Efisiensi Biaya Perusahaan,” Journal Islamic Global Network For Information Technology And Entrepreneurship, 2024.

Y. R. Thota, B. R. Bandlapalli, M. Iytha, And T. Nikoubin, “Zero Cost Approach For Nlp Based, Serverless Voicemail Monitoring Automation Pipeline,” 2025 Ieee 18th Dallas Circuits And Systems Conference (Dcas), Pp. 1–6, 2025.

Y.-C. Chen, “The Framework For Automating Social Media Content Publishing Using Google Apps Script,” Iet Conference Proceedings, Vol. 2024, No. 28, Pp. 81–83, Sep. 2025, Doi: 10.1049/Icp.2025.0198.

J. P. Duterte, “Technology-Enhanced Learning Environments: Improving Engagement And Learning,” International Journal Of Research And Innovation In Social Science, Vol. Viii, No. X, Pp. 1305–1314, 2024, Doi: 10.47772/Ijriss.2024.8100111.

M. Szulawski, I. Kaźmierczak, And M. Prusik, “Is Self-Determination Good For Your Effectiveness? A Study Of Factors Which Influence Performance Within Self-Determination Theory,” Plos One, Vol. 16, No. 9, P. E0256558, Sep. 2021, Doi: 10.1371/Journal.Pone.0256558.

L. J. Ekanayake, D. Ihalage, And Sachith. P. Abyesundara, “Performance Evaluation Of Google Spreadsheet Over Rdbms Through Cloud Scripting Algorithms,” 2021 International Conference On Computer Communication And Informatics (Iccci), Pp. 1–7, 2021.

R. S. Alejandrino, M. C. G. Diomampo, And J. R. Balbin, “Smart Water Meter With Cloud Database And Water Bill Consumption Monitoring Via Sms And Mobile Application,” 2022 Ieee International Conference On Automatic Control And Intelligent Systems (I2cacis), Pp. 90–95, 2022.

R. Z. Fitriani, C. Kuncoro, And Y. Kuan, “Internet-Based Remote Setting And Data Acquisition For Fuel Cell,” Sensors And Materials, 2021.

S. Gulwani, V. Le, A. Radhakrishna, I. Radicek, And M. Raza, “Structure Interpretation Of Text Formats,” Proceedings Of The Acm On Programming Languages, Vol. 4, Pp. 1–29, 2020.

R. Zhu Et Al., “Sheetmind: An End-To-End Llm-Powered Multi-Agent Framework For Spreadsheet Automation,” Arxiv, Vol. Abs/2506.1, 2025.