Monitoring and Energy Control inside Home using Google sheets with Line notification

Abstract—Power consumption has become a trend in managing electricity for use daily. This article presents a control and surveillance system for electrical home appliances remotely using Google account, together with Line notification, through a series of wireless transceivers that are currently used as cheap and do not require a dedicated PC server. This article simulates working with electrical devices such as light bulbs or fans, or other power-hungry devices. The system controls electricity and power, used to measure current and voltage without contact with high voltage circuits. The system sends information to be stored in google sheet as a datalogger. In addition, its display real-time values in dashboards and alert the status via the LINE application when there is an abnormal current or power. The test is divided into two parts: the first part sends data to a google sheet every minute and can display it on the dashboard immediately, and the second part sends status notifications via Line. They were set to send immediate alert messages when current and power are abnormal every hour. Experimental results from creating an anomaly simulation event in normal and abnormal conditions indicate that: the power data is sent to google sheets, and the status is notified via Line application. The accuracy of the power measurement of the device with the measuring device used is 95.76 percent.