How to archive readings from multiple sensors in one Google Sheet spreadsheet

ChristianChristian Administrator, Moderator Posts: 2,101 admin
edited May 2019 in FAQs

In many cases it is useful to pool the readings of multiple sensors in one spreadsheet so you can view them at a glance. Learn here how it works:

Any questions or comments? Register for free ad get started!

In order to illustrate the setup, we'd like to archive the room temperature (Homematic IP Wall Thermostate), humidity and carbon dioxide (both provided by a Foobot device), and the outdoor temperature (OpenWeather) within one Google spreadheet. All your hardware sensors as well as your Google account should already be authenticated within Conrad Connect.

Pay attention to these details

  1. Whenever multiple sensors come into play, you must combine them through a logical OR-gate.
  2. Define upper and lower bound for sensors with metrical readings in a way that this range can never be reached in real life (e.g. -100°C to -99°C for tempeature) ...
  3. ... and chose "ABOVE" for these sensors when configuring the OR-element.

Step 2. und 3. will ensure that all readings will be passed to the Google sheet actuator. If you only want to record readings above or below a certain treshold edit the respective fields accordingly.

  1. Now set up the Google Sheets actuator.
  • Provide a name for the spreadsheet and the worksheet
  • Use the wizard in order to drag the desired parameters into the message field. Each additional parameter needs to be separated by the character string "|||" from the previous one. This is how it works in our example:
{{Schlafzimmer_temperature_1.parameter}} |||{{temperature_1.temperature}} |||{{HappyBot_Humidity_1.parameter}} |||{{HappyBot_Carbon_Dioxide_1.parameter}}
  • Conrad Connect will automatically add a date and time stemp
  • Now define the column headers, again seperating them by using this character string "|||"
Temp inside|||Temp outside|||Humidity|||CO2
  • You may limit the frequency of your recordings by *Limit to: Once per hour". If you want all available data to be recorded, stick to the default option "Limit to: Always"

Any questions or comments? Register for free ad get started!

Sign In or Register to comment.