Design of a Skin Moisture Detection System Using a Microcontroller and Google Sheets as a Data Storage Platform
Desain Sistem Pendeteksi Kelembaban Kulit Menggunakan Mikrokontroler Dan Google Sheets Sebagai Platform Penyimpanan Data
DOI:
https://doi.org/10.21070/ups.11563Keywords:
ESP32, Capacitive Sensor, Skin Moisture, Google Sheets, Internet Of ThingsAbstract
Skin moisture is an important indicator of skin condition. Commercial measurement instruments are relatively expensive and less accessible for research and simple monitoring. This study aims to develop a skin moisture detection system using a capacitive sensor, ESP32 microcontroller, and Google Sheets for cloud-based data storage. The Research and Development (R&D) method was employed through hardware design, software development, system implementation, and performance testing. Sensor data were processed using trimmed mean, median filter, deadband, and Exponential Moving Average (EMA) to improve measurement stability. The processed data were converted into moisture percentages, displayed on an SSD1306 OLED, and transmitted automatically to Google Sheets via WiFi using Google Apps Script. The results show that the system can measure skin moisture in real time, classify skin conditions as dry, normal, or moist, and automatically store measurement data. The system provides a low-cost IoT-based prototype for skin moisture monitoring.
Downloads
References
A. Kimoto, F. Yonekawa, and T. Kawasoe, “Skin moisture measurement on stripping and pasted water by a handy-type electrostatic sensor,” Skin Research and Technology, vol. 28, no. 2, pp. 274–279, Mar. 2022, doi: 10.1111/srt.13125.
R. Saifuddin and S. D. Ayuni, “IoT Based PDAM Water Meter Monitoring System With Real Time Data,” Indonesian Journal of Innovation Studies, vol. 27, no. 1, Apr. 2026, doi: 10.21070/ijins.v27i1.2078.
D. Raditya Dwitama, M. F. Gunawan, A. Rahmadhani, R. Rahmadewi, and I. P. Sary, “Rancang Bangun Sensor Kapasitif Dua Plat Tembaga untuk Mengukur Viskositas Minyak,” Jurnal Pendidikan dan Teknologi Indonesia, vol. 6, no. 5, pp. 926–941, Jun. 2026, doi: 10.52436/1.jpti.1734.
A. Kurnia Ramadhan et al., “Sensor Data Processing System in a Prototype of an IoT-Based Solar-Powered Electric Induction Stove,” Journal of Electrical Technology UMY (JET-UMY), vol. 10, no. 1, 2026.
A. Syaifur Rohman et al., “Pengembangan Alat Portabel Pengukur Kadar Air dan Suhu Biji Kopi Berbasis ESP32 dengan Sensor Kapasitif dan Penyimpanan Data Real-Time Development of a Portable Coffee Bean Moisture and Temperature Meter Using a Capacitive Sensor and Real-Time Data Storage,” Jurnal Otomasi Kontrol dan Instrumentasi, vol. 17, no. 2, p. 2025, 2025, doi: 10.5614/joki.2025.17.2.12.
M. D. Ramadhan, A. Wisaksono, J. Jamaaluddin, and A. Ahfas, “Prototype Of Moisture Content Meter In Grain Using Esp32 Based On Spreadsheet,” Journal of Computer Networks, Architecture and High Performance Computing, vol. 6, no. 2, pp. 502–513, Apr. 2024, doi: 10.47709/cnahpc.v6i2.3530.
A. Prasetyo, J. Jamaaluddin, and I. Anshory, “PCB (Printed Circuit Board) Etching Machine Using ESP32-Camera Based Internet of Things,” Buletin Ilmiah Sarjana Teknik Elektro, vol. 5, no. 2, pp. 260–268, Jun. 2023, doi: 10.12928/biste.v5i2.8132.
Enggar Banifa Pratiwi, “Desain Skin Moisture Meter dengan Metode Pengukuran Kapasitansi Berbasis Mikrokontroler,” 2022.
S. Carolin, S. Yanti, and I. Sulistiyowati, “An Inventory Tool for Receiving Practicum Report Based on IoT by Using ESP32-CAM and UV Sterilizer: A Case Study at Muhammadiyah University of Sidoarjo,” Journal of Electrical Technology UMY (JET-UMY), vol. 6, no. 1, 2022.
M. Nur and T. Indrabulan, “SISTEM MONITORING PENGGUNAAN LABORATORIUM TERINTEGRASI BIOMETRIK SIDIK JARI DAN IOT BERBASIS GOOGLE SHEETS.” [Online]. Available: https://ejournal3.undip.ac.id/index.php/transient
J. Pebralia, L. Handayani, D. Suprayogi, and I. Amri, “IMPLEMENTATION OF INTERNET OF THINGS (IoT) BASED ON GOOGLE SHEETS FOR WATER QUALITY MONITORING SYSTEM,” JoP, vol. 9, no. 1, pp. 85–89, 2023.
Prof. Dr. Sugiyono, “Metode Penelitian dan Pengembangan (Research and Development/R&D)”.
W. Riyanta et al., “Penerapan Metode Research and Development Untuk Pengembangan Sumber Belajar Digital (Open Course Ware) di Politeknik Perkeretaapian Indonesia Madiun Application of Research and Development Methods for Development of Digital Learning Resources (Open Course Ware) at the Indonesian Railways Polytechnic Madiun,” Jurnal Ilmiah Intech : Information Technology Journal of UMUS, vol. 4, no. 2, pp. 246–254, 2022.
D. Ananta, “Sistem Monitoring Suhu dan Kelembaban Berbasis Internet of Things Menggunakan ESP32 dan DHT22,” Jurnal Informatika dan Teknik Elektro Terapan, vol. 14, no. 2, Apr. 2026, doi: 10.23960/jitet.v14i2.9467.
S. Systech, “SOLOMON SYSTECH SEMICONDUCTOR TECHNICAL DATA SSD1306 128 x 64 Dot Matrix OLED/PLED Segment/Common Driver with Controller,” 2008. [Online]. Available: http://www.solomon-systech.com
P. By ALLDATASHEETCOM, “TP4056 ASIC | Alldatasheet.”
P. By ALLDATASHEETCOM, “DATASHEET SEARCH SITE | WWW.ALLDATASHEET.COM,” 2019. [Online]. Available: www.espressif.com/en/subscribe.
P. By ALLDATASHEETCOM, “MT3608 DATASHEET SEARCH SITE | WWW.ALLDATASHEET.COM.”
B. Al Fatih and H. Putra, “GOOGLE APP SCRIPT UNTUK PENGEMBANGAN SISTEM INFORMASI LABORATORIUM,” 2024.
A. V. Shved and Ye. O. Davydenko, “OUTLIER DETECTION TECHNIQUE FOR HETEROGENEOUS DATA USING TRIMMED-MEAN ROBUST ESTIMATORS,” Radio Electronics, Computer Science, Control, no. 3, p. 50, Oct. 2022, doi: 10.15588/1607-3274-2022-3-5.
V. Chaturvedi, M. Falk, S. Björklund, J. F. Gonzalez-Martinez, and S. Shleev, “Monoolein-Based Wireless Capacitive Sensor for Probing Skin Hydration,” Sensors, vol. 24, no. 14, Jul. 2024, doi: 10.3390/s24144449.
H. Alfarizi and R. Z. Abidin, “SISTEM MONITORING SUHU BERBASIS IOT DENGAN SENSOR THERMOCOUPLE DAN PELAPORAN OTOMATIS MENGGUNAKAN GOOGLE SHEETS PADA RUANG COLD STORAGE,” 2025. doi: 10.36040/jati.v9i6.15495.
Downloads
Additional Files
Posted
License
Copyright (c) 2026 UMSIDA Preprints Server
This work is licensed under a Creative Commons Attribution 4.0 International License.
