Regarding the Config, it will be empty, since there is no config made yet to the Google Calendar. We need the “Upcoming” node from the ical section:ĭouble click this node to change its settings. Now the ical nodes are available for use, we are going to build a Node-Red flow that only contains 2 nodes, an ical node and a MQTT node.
After the installation is done, a few new nodes are available:
After the installation is done, you might need to restart Node-Red. Search for “node-red-contrib-ical-events” and click install. The flow will run every 15 minutes, get events from the Google Calendar and push the results to an MQTT broker.įirst, we need to install “ node-red-contrib-ical-events” via Menu – Manage Palette – tab Install.
In Node-Red we are going to setup a quite simple flow. Save this link temporarily in a notepad file or so, since we Copy the full url or use the button “Copy link”. To get the url to access the public calendar, click on the “Get shareable link” button: Select the checkbox to make it available to public as shown below. Open the calendar settings in the left menu and scroll down to the “Access permissions for events”. You can open the calendar via the following link. Open your Gmail account from which calendar you want to use. Let’s start: 1) Get the public url of the Google calendar Optional: Real-time dashboard to mark finalized events.MySQL/MariaDB environment (in my case a XAMPP server with PHPMyAdmin included).2x a vb.NET script (download link available at the bottom of this post).MQTT broker (also running on the same Raspberry Pi).Node-Red (in my case installed on a Raspberry Pi).Login to a Google account from where you want to use the calendar.My real-time dashboard will show the events and you mark the events here as “done” and as the last step another script in Homeseer will update the event so it’s “marked as done”.
This post will explain how I got it working via my existing home automation landscape and how the calendar events from Google are fetched via Node-Red into MQTT, and use a script in Homeseer to save/update the events into a MySQL table. Listed events that are in the past should be marked as red color on the dashboard as a clear separation of what should have been done and the ones that are upcoming. So the task should remain visible on the dashboard until they say/mark it, it can disappear from the dashboard. Pretty straightforward forward, however they want to mark an event as done manually when the event is done. My family members at home wanted to have a shared calendar for events/appointments that are happening within the household and they want to have the upcoming events listed on the real-time dashboard.
0 kommentar(er)
