Sensor Data Recording and Alerts Notification using IFTTT with ESP32

Abstract

ABSTRACT

IoT's main value is data. Real-time data from different sources, stored and processed into actionable insights to transform and optimise processes is invaluable. This is why the device cloud is an important (and sometimes expensive) part of the architecture of any IoT solution since the data must be easily accessed for analysis. For individuals looking to deploy pilots and prototypes of scalable work on a budget, coughing up huge sums for data storage on platforms like Azure can be a burden. While there are tonnes of free IoT platforms, they sometimes have restrictions that make them unsuitable in certain situations. This work will cover a cheap/free cloud storage alternative. How to connect IoT devices to Google Sheets to log data. Google Sheets is used to creating spreadsheets instead of Microsoft Excel. It can be integrated with dozens of Google services, like Maps, to create innovative solutions. Google made it easy for developers to programmatically fill in data into a Google sheet using APIs and Gscript, which we have used for this work. To demonstrate Google Sheets as a device cloud, we have built a simple IoT temperature and humidity monitor. Using DHT11, the device will measure temperature and humidity and upload the data to a Google Sheet.