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.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.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.
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
Call the following link:
Click on the File menu and then select "Make a copy"
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" 
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" to copy the web app / cloud URL and send it to your app, or you can use our mail option.
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.
open the menu bar by clicking on the three lines in the upper left corner
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.
The settings made here will be used in the hydrom
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:
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.
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.