• Initial setup for Pressac EnOcean gateway
• A Google account
Navigate to the Google Sheets connection page by clicking “– Google Sheets” in the Connections sub-menu on the Pressac EnOcean gateway web-interface.
On this page you will find the following fields.
|Status of the connection to Google Sheets, either Disconnected or Connected.
|Connection to Google Sheets can be Enabled or Disabled from here.
|What the device will appear as within the Google Sheet. When set to ‘Device Name’ the device name will be used and when set to ‘Device ID’ the unique device ID will be used.
|Limit sheet cells
|Allows you to enable the cell limit of the Google Sheet.
|Allows you to limit the amount of cells per sheet to one, two, three, four or five million. Google Sheets with large amounts of cells negatively impact the performance.
|This token will be provided when you connect your gateway to the Google Platform.
|Private key certificate of your Google project. This is generated/created when creating your credentials for your project.
Setting up the Google Sheets connection
Creating and importing the Private Key
To use the Google Sheets connection on your gateway please follow the procedure below.
Create a Google account which can be done here.
Now you have created your Google account, log in to the Google Cloud platform console which can be found here.
Then create a new “Project”. You can do this by clicking Select a Project at the top left of the page:
Then select New Project in the top right-hand side of the pop-up window:
Give your project a name and click the CREATE button:
Now you’ve created your project, enable the Google Drive and Google Sheets API by clicking the “hamburger” icon (☰) in the top left corner, selecting APIs & Services > Library:
In the search box, enter Google Drive API
Search Google Drive API and click the ENABLE button:
Then repeat this process to enable the Google Sheets API:
Next, by clicking the “hamburger” icon (☰) in the top left corner, selecting APIs & Services > credentials:
Then set up at the top of the page CREATE CREDENTIALS > Service Account:
Enter a service account ID for the account, and click CREATE AND CONTINUE:
Go back to the Credentials tab and select the Service Account you just created:
Within this service account page, select KEYS:
Then select ADD KEY and choose Create New Key:
Select JSON and click the CREATE button:
This will download the JSON key to your PC downloads folder. Your Google Sheets account setup is now complete.
Connecting the gateway to Google Sheets
Log in to the Pressac Smart Gateway Web interface, and select “Connections” and “Google Sheets.” Turn the connection on, and then click “Upload” in the Private Key field and upload the JSON file downloaded above:
The connection status should now change to “Connected” – the gateway is now sending data to the Google Sheets account. The data which is sent to the cloud is determined by the fields selected on the connection page:
|The time the gateway received a message from a physical device.
|Gateway name assigned in the System > General screen.
|Location of a device assigned on the edit device screen e.g. mainoffice.
|Values received by the gateway from a physical device such as temperature, humidity, current etc.
|Device value unit
|Unit the device value is measured in if available e.g. °C.
|Signal strength (dBm)
|Signal strength between the device and gateway in dBm.
Your gateway is now set up for Google Sheets.
Accessing your Google Sheets data
To access your Google Sheets data, scroll to the bottom of the Google Sheets connection page and click Launch Google Sheets. This will bring up a pop-up window where you will be able to select one of the spreadsheets which have been created by the gateway.
In order to access the data, you need to grant access to your Google account. You can enable this access through the Cloud console, or from the gateway itself, by entering your email address in the “Authorised Access” field and clicking the plus sign to add the account:
You should now be able to access the data by clicking “Launch Google Sheets” and selecting which spreadsheet you wish to view. A spreadsheet will be created for each sensor type.