In this project, we will create a luminosity logger that will monitor the illuminance or measure the lux value and log it to a database which is google sheets in this project. Also, the data will be graphically presented in the google sheets portal.
Logging can be done with any sensor values and then can be analyzed later on. It can also be used for security measures like scanning and logging down some unique identity about who entered/exited with a timestamp.
For demonstration purposes, we will use an APDS 9301 sensor to monitor the real-time lux values and using google app script log the values in google sheets where the values will be graphically displayed using a timestamp.
Let's start by configuring the required prerequisites for the project.