Development of A Cloud Storage Based Data Logging System

In the present world, as Internet of Things (IoT) based sensor monitoring and conditional controlling technology has been embedded in our day-to-day lives, there is a need for logging and storing sensor data for big data analysis. Due to free and easy to use features, Google spreadsheet has been chosen as the Cloud-based spreadsheet platform for sensor data logging and storing. This paper has provided a procedure to monitor sensor data, located at different geographical locations onto their corresponding specified worksheet in a well-defined structured manner in a single Google spreadsheet. The sensor readings uploaded in the Google spreadsheet can be accessed online by smartphone or a personal computer. For stable and accurate readings of sensors which work best on 5 V, the hardware communication protocol, Universal Asynchronous Receiver/Transmitter (UART) has been used during the development of the present work and this paper shows a simplistic way for uploading sensor values on the web, where memory constraint for storing sensor data is absent. In this developmental work, Arduino has been used for sensor data monitoring and ESP32 has been used for Internet connection