Connect the Hydrom to Google Sheets
The Google Sheets software was developed to cover all steps of the brewing process brewing process, from mashing to fermentation to storage.
Last updated
The Google Sheets software was developed to cover all steps of the brewing process brewing process, from mashing to fermentation to storage.
Last updated
Prerequisite
To make this setting, you must have access to the user interface. If you don't, see here how to do it: Access to the user Interface
Google account available To use Google Sheets, you need a Google account. You can register here: https://accounts.google.com
After the Hydrom has been successfully put into deep sleep, it will automatically begin submitting its collected and calculated readings to the user's Google account. Following this, Google Sheets automatically creates a new worksheet whose title corresponds to the name of the hydrom in question.
In this newly created Sheet, the received data variables are clearly organized and stored in different columns so that the user can easily access and analyze them.
Call the following link:
https://docs.google.com/spreadsheets/d/1v6VI_eaHwb0OGDMxZvnlsiRH7fhhiMUscAlDiQi-g14
Click "Authorize Access" when the window appears and select your Google account.
Now open the Hydrom's user interface.
To access the menu bar, you need to click on the three lines in the upper left corner. (See arrow) Then the menu bar will open.
On the "Services" page, you have the option to select and configure various interfaces and cloud services for use with its system. On this page, users can choose from three different interfaces - HTTP, MQTT, and TCP - and several cloud services, and then enable and parameterize these options to fit their needs. This page is a useful tool for those who want to connect their system to the cloud or other external services and customize the way data is transmitted and received. With the options available on the Services page, users can customize their system to meet their specific needs and ensure that it can communicate effectively with other devices and systems.
On the "Service" page, you need to enable the Google Sheets service. Copy the API token from the Google page and paste it into the "Token" field.
The token must be entered without spaces. If there are spaces, the token will not be accepted.
To avoid using too much power, we would turn off Bluetooth when it is not needed. This was documented here:
Bluetooth SettingsIn order for the hydrom to transmit data reliably, a DeepSleep time must be set. This is documented on this page:
Adjust IntervallSaving the data is important because it is the only way to connect to the service after waking up from DeepSleep.
You can check if the save was successful by looking at the settings file at http://hydrom001/settings.json/. This file is the persistent storage of the hydrom.
A second way to check the saving is to reload the page (all browsers offer this). If then the properties are reloaded, the hydrom has accepted them, otherwise the old settings are reloaded.
Enabling DeepSleep is mandatory for the hydrom to send data. If DeepSleep is activated, the hydrom wakes up after the specified time and sends the data to the set service. After that, the hydrom goes back to sleep and waits for the new service.
Adjust IntervallIn order for the device to send readings to the service at the set interval as intended, the Hydrom must be put into deep sleep.
There are two ways to put the Hydrom into deep sleep.
The easiest way to put the Hydrom into deep sleep is to turn the power switch off and on.
The other way is to put the device into deep sleep using the user interface. To do this, open the navigation bar and go to the "DeepSleep" tab.
click on the gear in the type selector, then select "Web App"
