Implementation of Cake Sales Website with Google Sheet Database (Study Case : Classikeik Shop)

Article Sidebar

PDF
Published: Dec 22, 2025
Keywords:
digitalization, UMKM, transaction efficiency, cloud computing

Main Article Content

Ahmad Azhar
UNIVERSITAS ISLAM INDRAGIRI
Muhammad Afrizal

Abstract

The Classikeik store previously conducted sales manually through a pre-order system using direct messages (DM) on Instagram and WhatsApp chat. The system caused problems in recording and managing transaction data due to the relatively high volume of orders. This research aims to overcome these problems through the development of a cake buying and selling website that is directly integrated with Google Sheets as a database. The research method used is implementative with a descriptive approach, utilizing HTML, CSS, JavaScript, and Google Apps Script technologies. The website is integrated with Google Sheets through two main worksheets, namely the “Products” worksheet, which automatically updates product information on the website page, and the “Orders” worksheet, which real-time stores every order that comes through the website. The implementation results show that this system improves time efficiency in order processing, speeds up customer service, significantly increases the number of orders, and provides convenience in managing transaction data automatically. Thus, the use of website integration and Google Sheets has proven effective in digitizing the operations of small-scale culinary businesses such as Toko Classikeik.

Article Details

Issue
Vol. 1 No. 2 (2025): Computer Science Insights
Section
Articles
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

References

[1] D. Ternando and H. Mulyono, “Sistem Informasi Promosi Berbasis Web Pada UMKM Jajanan Aulia,” J. Manaj. Sist. Inf., vol. 7, no. 3, pp. 487–500, 2022, doi: 10.33998/jurnalmsi.2022.7.3.185.

[2] T. Triase, R. Al Ikhsan, and P. I. J. Hasibuan, “E-Commerce Untuk Meningkatkan Penjualan Pada Umkm Solo Fried Chicken Berbasis Website Php Native,” JUTECH J. Educ. Technol., vol. 5, no. 1, pp. 20–34, 2024, doi: 10.31932/jutech.v5i1.3170.

[3] Y. Anis, E. N. Wahyudi, and H. C. Kurniawan, “Metode Waterfall dalam Pengembangan Sistem Inventaris Guna Meningkatkan Efisiensi Manajemen Stok Barang,” J. Teknol. Dan Sist. Inf. Bisnis, vol. 6, no. 2, pp. 329–338, 2024, doi: 10.47233/jteksis.v6i2.1351.

[4] R. Irawati and I. B. Prasetyo, “Pemanfaatan Platform E-Commerce Melalui Marketplace Sebagai Upaya Peningkatan Penjualan dan Mempertahankan Bisnis di Masa Pandemi (Studi pada UMKM Makanan dan Minuman di Malang),” J. Penelit. Manaj. Terap., vol. 6, no. 2, pp. 114–133, 2021.

[5] J. Raya, P. No, D. P. Klod, K. D. Tim, and K. Denpasar, “Kajian Penerapan Digitalisasi UMKM : Studi Kasus Desa Study on MSMEs Digitalization : Case of Gelgel Village , Klungkung,” vol. 12, no. 4, pp. 731–739, 2024, doi: 10.26418/justin.v12i4.82976.

[6] H. G. Ardiansyah, “Penerapan Chatbot Auto Reply Pada Whatsapp Menggunakan Artificial Intelligence (Studi Kasus Sri Ratu Laundry),” Pros. Semin. SeNTIK, vol. 7, 2023, [Online]. Available: https://ejournal.jak-stik.ac.id/index.php/sentik/article/view/3462

[7] I. Arisandi, I. G. P. Warka, and Z. Gazalba, “Analisis Kebutuhan Tenaga Kerja Dan Peralatan Pada Proyek Peningkatan Jalan: Studi Pada Pelaksanaan Proyek Peningkatan Jalan Pancor-Rempung,” Ganec Swara, vol. 12, no. 2, pp. 1–7, 2018.

[8] M. Jaringan, S. Kasus, P. Kwt, and A. Farm, “Digitalisasi usaha kecil melalui website umkm sebagai upaya memperluas jaringan (studi kasus pada kwt azalea farm boyolali),” vol. 15, no. c, pp. 60–68, 2024.

[9] G. Santoso, M. Rizal, H. Wiyana, and S. N. Subagja, “JUBISDIGI : Jurnal Bisnis Digital Digitalisasi UMKM : Strategi Dan Model Bisnis Berbasis Teknologi Untuk Keberlanjutan JUBISDIGI : Jurnal Bisnis Digital,” vol. 01, no. 01, pp. 21–30, 2025.

[10] F. M. Rahi, E. G. Radjah, and A. C. Talakua, “Integrasi WhatsApp Gateway Dalam Sistem Informasi Absensi Berbasis Website Di SMA Negeri 1 Pandawai,” pp. 744–757, 2024.

[11] F. LIa Dwi Cahyanti, Elly Firasari, and Umi Khultsum, “Sistem Informasi Penjualan Berbasis WEB Pada UKM Rukun Makmur Tlingsing,” Nuansa Inform., vol. 18, no. 2, pp. 11–18, 2024, doi: 10.25134/ilkom.v18i2.126.

[12] D. Darna, D. Y. Liliana, F. Fatimah, I. Ermis, and E. Y. Metekohy, “Pengembangan Website untuk Meningkatkan Pemasaran Produk UMKM,” Bhakti Persada, vol. 8, no. 2, pp. 100–107, 2022, doi: 10.31940/bp.v8i2.100-107.