Posts

Showing posts from December, 2020

Homebridge, retrieve accessories information & status

Image
Having Homebridge (HB) up and running it's simple to retrieve and visualize  status or measurements from accessories. For example I'm using the Aeotec MultiSensor 6 ,(AM6), via the z-way plugin , where I'm sensing the light level. Since Im living in northern Europe it's not very accurate to switch the indoor lightning by sun-rise/set. So instead I'm using the AM6 together with the EVE app  to switch the lightning.  To visualize the measured values over time I'm using NodeRed (NR) and a HomeBridge plugin

Free Gmail mail merge with Sheets

Image
There are several mail merges applications where you can merge information from Google:s "Sheets"(GS), but not so may free ones that are good. The point using mail merge is that you can personalize your outgoing mails and you will fore sure get a better response rate.   There should also be said that if you are having a free Gmail account you are limited to 100 outgoing mails per 24 hours. The first application, free !, handles the merge via a GS with a built in JavaScript macro and in the second application, 25 free mails per 24 hours(limit in app), the merge is done via an installed GS add-on with many nice functions.