Perancangan dan Pembuatan Sistem Penyimpanan Dokumen Lisensi Berbasis Google Apps Script
Abstract
This study aimed to develop a license and permit document storage system based on the Google ecosystem to improve document management efficiency in organizations. The problem identified was the manual document storage and retrieval process, which required a long time and increased the risk of delayed document renewal. The method used was the System Development Life Cycle (SDLC) with the Waterfall model, including analysis, design, implementation, and testing stages. The system was developed by integrating Google Forms, Google Drive, and Google Sheets with automation using Google Apps Script. The results showed that the system improved document retrieval efficiency from 300 seconds to 10 seconds, achieving a 96.6% increase. The system also reduced human error and improved document expiration monitoring effectiveness.
Keywords: Document Management System; Google Apps Script; Cloud Computing; Automation; Digital Archiving
Abstrak
Penelitian ini bertujuan untuk mengembangkan sistem penyimpanan dokumen lisensi dan izin berbasis ekosistem Google guna meningkatkan efisiensi pengelolaan dokumen pada organisasi. Permasalahan yang dihadapi adalah proses penyimpanan dan pencarian dokumen yang masih dilakukan secara manual sehingga memerlukan waktu lama dan berisiko terhadap keterlambatan pembaruan dokumen. Metode yang digunakan adalah System Development Life Cycle (SDLC) dengan model Waterfall yang meliputi tahap analisis, desain, implementasi, dan pengujian. Sistem dikembangkan dengan mengintegrasikan Google Forms, Google Drive, dan Google Sheets serta otomatisasi menggunakan Google Apps Script. Hasil penelitian menunjukkan bahwa sistem mampu meningkatkan efisiensi waktu pencarian dokumen dari 300 detik menjadi 10 detik atau sebesar 96,6%. Sistem juga mampu mengurangi kesalahan manusia dan meningkatkan efektivitas pemantauan masa berlaku dokumen.
Keywords
References
D. Horiah, A. Gani, I. Kamaruddin, and A. Kadir, “Electronic Document Management: The Essence of Effective Modern Organisation,” Journal of Information and Knowledge Management, vol. 14, no. 2, pp. 77–85, 2024, doi: 10.24191/jikm.v14i2.4472.
D. Anggraini, K. Adi, and J. E. Suseno, “Electronic document management systems implementation across industries: systematic analysis,” Indonesian Journal of Electrical Engineering and Computer Science, vol. 36, no. 1, pp. 264–273, 2024, doi: 10.11591/ijeecs.v36.i1.pp264-273.
Y. Guo, guang, Q. Yin, Y. Wang, J. Xu, & L. Zhu, Efficiency and optimization of government service resource allocation in a cloud computing environment. Journal of Cloud Computing, vol. 12, no. 1, p. 18, 2023, https://doi.org/10.1186/s13677-023-00400-2.
J. J. A. Y. R. Fernandez and J. M. Fernandez, “Implementation of Manual Records Management System : Basis for Proposed Web-based Records Management System, IJAMS, ” vol. V, no. 6, pp. 930–938, 2025.
D. Nur and N. Sutarni, “Penerapan Sistem Kearsipan Elektronik Sebagai Determinan Terhadap Produktivitas Kerja Pegawai (The implementation of electronic filing system as a determinant of employee’s productivity),” Jurnal Pendidikan Manajemen Perkantoran, vol. 2, no. 2, pp. 148–156, 2017, [Online]. Available: https://ejournal.upi.edu/index.php/ jpmanper/article/view/8104
A. Sutriyono, I.S. Permana, C.S.D. Andhini, & S.M. Azka, “SIKURMA: Development of a Google Apps Script–Based Document Repository Information System for Optimizing Digital Archive Management in Higher Education. Jurnal Media Computer Science, vol. 5, no. 1, pp. 533-544, 2025.
W. S. Putra, “Penerapan Penyimpanan Protokol Notaris dengan Metode Cloud Computing System,” Unes Journal of Swara Justisia, vol. 8, no. 1, pp. 113–132, 2024, doi: 10.31933/ujsj.v8i1.482.
H. Yi, “Improving cloud storage and privacy security for digital twin based medical records. Journal of Cloud Computing, vol. 12, no. 1, p. 151, 2023 https://doi.org/10.1186/s13677-023-00523-6.
K. Sama and O. I. A. Unkriswina, “Otomatisasi Pengelolaan Data Dan Pembuatan Dokumen,” Jurnal Pengabdian Masyarakat, vol. 3, no. 01, pp. 212–217, 2026.
A. van der Merwe, A. Gerber, and H. Smuts, “Guidelines for conducting design science research in information systems,” Communications in Computer and Information Science, vol. 1136 CCIS, pp. 163–178, 2020, doi: 10.1007/978-3-030-35629-3_11.
L. N. Varlamova, “International Records Management and Archives Terminology Systems Standardized by ISO and IEC,” Atlanti, vol. 28, no. 2, pp. 99–109, 2018, doi: 10.33700/2670-451x.28.2.99-109(2018).
C. Engel, P. Ebel, and J. M. Leimeister, “Cognitive automation,” Electronic Markets, vol. 32, no. 1, pp. 339–350, 2022, doi: 10.1007/s12525-021-00519-7.
C. Miyachi, “What is ‘Cloud’? It is time to update the NIST definition?,” IEEE Cloud Computing, vol. 5, no. 3, pp. 6–11, 2018, doi: 10.1109/MCC.2018.032591611.
C. V. Marian, M. Neferu, and D. A. Mitrea, “Design and Evaluation of a Low-Code/No-Code Document Management and Approval System,” Information, vol. 17, no. 1, p. 46, 2026, doi: 10.3390/info17010046.
J. Orioque, S. Pajaron, and J. Cabardo, “Contextualized Online Document Management System,” Journal of Innovative Technology Convergence, vol. 6, no. 1, pp. 65–74, 2024, doi: 10.69478/jitc2024v6n2a07.
M. Iqbal, D. Daraba, and E. Indrayani, “Implementasi Kebijakan Tentang Pedoman Penerapan Sistem Informasi Kearsipan Dinamis Terintegrasi Dalam Upaya Pengelolaan Naskah Dinas Elektronik Di Sekretariat Daerah Kota Bekasi,” Jurnal Kajian Pemerintah: Journal of Government, Social and Politics, vol. 10, no. 2, pp. 110–122, 2024, doi: 10.25299/jkp.2024.vol10(2).19930.
W.S. Nurfajriyah, & B. Bahar, “Model Aplikasi Perpustakaan Berbasis Web dengan Fitur Booking pada Sekolah Menengah Kejuruan. Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi, vol. 13, no. 1, pp. 807-818, 2024
How To Cite This :
Refbacks
- There are currently no refbacks.
