Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management
DOI:
https://doi.org/10.61132/saturnus.v4i2.1535Keywords:
Google Sheets, Information System, Inventory Management, Stock Taking, Warehouse InventoryAbstract
This research was conducted with the aim of developing an automation system for recording warehouse inventory based on Google Sheets to improve the effectiveness and efficiency of the stocktaking process at the Cresta Management warehouse. This research was based on problems in the semi-manual process that used logbooks and separate files for each group of goods, which caused problems such as data duplication, limited data access, lack of data transparency, and lengthy recapitulation process. This research used the Research and Development method using the ADDIE model (Analyze, Design, Develop, Implement, and Evaluate). Data were collected through observastion, interviews, questionnaires, and documentation. The result of this development is a system consisting of a login page, goods transcation recording, warehouse dashboard, stock reports, stock cards, and PDF report exports. This study also produced evaluation scores regarding the system’s feasibilty: 93,3% from the first media expert, 80% from the second media expert, 73,3% from the material expert, and 91,75% from users through User Acceptance Testing. These evaluation results indicate that the system is feasible for use and implementation in supporting warehouse operations, as it provides real time data updates, improves the efficiency of goods reporting, and enhances warehouse transactions.
References
Adam, A. (2024). Sistem informasi manajemen (Issue December).
Ardiansyah, Risnita, & Jailani, M. S. (2023). Teknik pengumpulan data dan instrumen penelitian ilmiah pendidikan pada pendekatan kualitatif dan kuantitatif. Jurnal IHSAN: Jurnal Pendidikan Islam, 1(2), 1-9. https://doi.org/10.61104/ihsan.v1i2.57
Bratha, W. G. E. (2022). Literature review komponen sistem informasi manajemen: Software, database dan brainware. Jurnal Ekonomi Manajemen Sistem Informasi, 3(3), 344-360. https://doi.org/10.31933/jemsi.v3i3
Clarke, V. (2021). Book review: Thematic analysis: A practical guide. 39(December 2024), 142-145. https://doi.org/10.58837/CHULA.PPJ.39.8
Daud, A. A., Yasani, S. M., Bohar, A., Latif, R., & Abdul, H. (2024). Critical analysis of the role of management information systems in optimizing strategic decision making. Journal of Business Management and Economic Development, 2(02), 1024-1030. https://doi.org/10.59653/jbmed.v2i02.854
Elhajjar, S., Yacoub, L., & Yaacoub, H. (2023). Automation in business research: Systematic literature review. Information Systems and E-Business Management, 0123456789. https://doi.org/10.1007/s10257-023-00645-z
Hassan, M. K. (2023). Development of an order processing system using Google Sheets and Appsheet for a Malaysian automotive SME factory warehouse. 20(3), 63-81. https://doi.org/10.24191/jmeche.v20i3.23901
Hidayat, F., & Nizar, M. (2021). Model ADDIE (Analysis, Design, Development, Implementation and Evaluation) dalam pembelajaran pendidikan agama Islam. 28-37. https://doi.org/10.15575/jipai.v1i1.11042
Molenda, M. (2003). The ADDIE model. 1-5.
Munyaka, J. B., & Yadavalli, V. S. S. (2022). Inventory management concepts and implementations: A systematic review. South African Journal of Industrial Engineering, 33(2), 15-36. https://doi.org/10.7166/33-2-2527
Nur, D., W., Rahayu, S., & Wiyatno, T. N. (2025). Perancangan sistem inventory material botol berbasis Appsheet dan Google Sheets menggunakan metode waterfall di PT. XYZ. Innovative: Journal Of Social Science Research, 5, 2487-2498.
Poon, P. L., Lau, M. F., Yu, Y. T., & Tang, S. F. (2024). Spreadsheet quality assurance: A literature review. Frontiers of Computer Science, 18(2). https://doi.org/10.1007/s11704-023-2384-6
Purwanto, P. (2025). Pemanfaatan spreadsheet (Google Sheet) dalam pengembangan sistem informasi inventaris peralatan pada gereja XYZ di Kota Salatiga. 13(1), 10-24. https://doi.org/10.18196/berdikari.v13i1.25430
Purwoko, R. A., Yudhistira, A. A., & Surabaya, U. N. (2024). Implementasi stock opname persediaan bahan baku. 2(12).
Puspasari, R. (2024). Pencatatan material stok & non-stok berbasis spreadsheet Google Sheets pada bagian logistik di PT PLN (Persero) Unit Pelaksana Transmisi Bali.
Rachmad, Y., Indrayani, N., Harto, B., Judijanto, L., Rukmana, A., Rahmawati, N., Ambulani, N., & Saktisyahputra. (2024). Digital technology management (Penggunaan teknologi dalam mengelola manajemen yang berdaya saing) (Issue May).
Sugiyono, P. D. (2022). Metode penelitian kuantitatif, kualitatif, dan R&D. Alfabeta.
Syarifah Nadia, & Chairil Anwar. (2024). Optimalisasi pencatatan e-commerce pada perusahaan: Input data Google Sheets. Jurnal Kabar Masyarakat, 2(4), 189-197. https://doi.org/10.54066/jkb.v2i4.2649
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Saturnus: Jurnal Teknologi dan Sistem Informasi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
