Links

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.
Prerequisite
  1. 1.
    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
  2. 2.
    Google account available To use Google Sheets, you need a Google account. You can register here: https://accounts.google.com

Principle behind the Google Sheet integration

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.
New Sheet
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.
Contents of the created Sheet

Prepare the sheet

Copy the sheet from the Bonorum account

Call the following link:
Click on the File menu and then select "Make a copy"

Deploy the script

Click on the menu "Extensions" and then on "Apps Script"
Click on the blue "Deploy" button in the upper right corner of the screen and then select "New Deployment"
click on the gear in the type selector, then select "Web App"
click on the gear in the type selector, then select "Web App"
Make sure you use your email and that "Everyone" can access the Web APP
Click "Authorize Access" when the window appears and select your Google account.
A dialog box appears with the message "This application is not verified". Select "Advanced" and then "Go to main script (unsafe)."
A dialog box with approval requests is displayed. Select "Allow"

Copy the token

"Copy" to copy the web app / cloud URL and send it to your app, or you can use our mail option.

Setting up the Hydrom

Now open the Hydrom's user interface.

Step 1: Open menu bar

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.
open the menu bar by clicking on the three lines in the upper left corner

Step 2: Select "Service

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.

Step 3: Enable Google Sheets and change the settings.

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.
The settings made here will be used in the hydrom

additional settings

To avoid using too much power, we would turn off Bluetooth when it is not needed. This was documented here:
In order for the hydrom to transmit data reliably, a DeepSleep time must be set. This is documented on this page:

Save settings

Saving the data is important because it is the only way to connect to the service after waking up from DeepSleep.
Pressing the "SAVE" button saves the settings
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.

Activate DeepSleep

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.
In 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.