Connect my google sheet with my home bulb lights
Budget: $30 – $250 USD
The aim of the project is to control one bulb light located in my home with a google sheet. I have a home controlled by a google account (google home app) and a bulb light which is being controlled by that google home app.
I would like to control that light by using a specific cell in google sheet. So when the cell says "yes" then the light is turned on and vice versa when the cell says "no" then the light should be turned off.
Also, if I change the status of that light from google home app then, it should be synchronized to the google sheet.
The functions should be constructed to scale the rest of the lights of my house, so I will use that created functions and I should change tokens and keys to add more lights.
I would like to control that light by using a specific cell in google sheet. So when the cell says "yes" then the light is turned on and vice versa when the cell says "no" then the light should be turned off.
Also, if I change the status of that light from google home app then, it should be synchronized to the google sheet.
The functions should be constructed to scale the rest of the lights of my house, so I will use that created functions and I should change tokens and keys to add more lights.