How Streamsheets work – Stream Processing and IoT for Non-Programmers

This blog post introduces the basic operation of Streamsheets. Using the example of a smart WiFi switch with an integrated power consumption meter (Shelly 2.5), we set up a complete Streamsheet use case within 10 minutes.

This post contains 3 video sessions:

  • In the first video just below you see how the data connection is established and how the necessary spreadsheet formulas and charts are created. This includes an energy monitoring and an automatic shutdown if the energy consumption or operating temperature is too high. In addition, the first video shows how to set up the Streamsheet to automatically send emails in the event of an alarm and how to make entries in a log database (here MongoDB).
  • The second video extends the demo to show how you can created visual representations of the device status directly in the Streamsheets. This is done simply by dynamically linking the attributes of graphical objects with the contents of Streamsheet cells (cells, which then in turn are linked to the JSON data from the MQTT messages)
  • In the third video we confess, that we actually did not use the MQTT connectivity of the Shelly 2.5 device. Instead we used the REST API which delivers very complete JSON payloads. This gave us another use case, namely to show how easy it is to use a Streamsheet to build a highly flexible REST-to-MQTT Gateway just using spreadsheet formulas.

(If you want to know the basic principles of MQTT and JSON first, then this video blog post is recommended)

It is recommended to watch the following video in full screen mode. The video is 10 minutes long, but the first 5 minutes are enough to understand the basic principle of Streamsheets.

First Video: Introduction to Streamsheets (Main Video)


Second Video: Device Status – Dynamic drawings in Streamsheets


Third Video: Using Streamsheets to build bridges – REST to MQTT Gateway

By the way: Streamsheets are open-source and are available for all platforms (including the Raspberry Pi). Simply download at http://www.cedalo.com/download.

Of course we also sell a premium edition of Streamsheet-Server including commercial support and OPC UA functionality as a premium feature. Please don’t hesitate to contact us.