December 27, 2020

Homebridge, retrieve accessories information & status

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

December 15, 2020

Free Gmail mail merge with Sheets

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.