Google Sheet for data import

The tSheet feature is one of the simplest methods for importing data into Twinzo, requiring no programming knowledge. This user-friendly tool allows anyone to easily integrate data into the system without the need for technical expertise.

1 Before we start, make your copy of public tSheet
2 twinzo connection
3 Send single data
4 Send multiple data
5 Send Data Periodically

For accurate display of sensor data in the 3D app, it is crucial to establish a connection between the Sensors - Public Documentation - Confluence and their corresponding Areas / POI - Public Documentation - Confluence. Detailed instructions and further information on how to set up this connection can be found in the relevant section of our documentation.

Before we start, make your copy of public tSheet

The tSheet contains 3 sheet: twinzo connection, send single data and send multiple data.

Sheets in tSheet

twinzo connection

This sheet serves us to established the connection with the twinzo server.

twinzo connection sheet

In the upper section of the interface, enter your credentials, which are the same as those used for the portal or 3D app:

Client: Your client identifier.
Login: Your login username.
Password: Your password.
API URL: Select the type of your license. When you user self-onboarding -use Platform (https://platform.twinzo.eu/), in case your colleagues invite you, use Enterprise (https://portal.twinzo.eu/). If you are using an on-premise solution select “Custom - Enter your API URL below:” and input your specific URL.

Below these fields, you'll find the Connect with Twinzo button. Click this to initiate the request to connect. The first run of the script will require permissions, and a step-by-step manual on how to grant these permissions is available here → Authorizing an Apps Script

The Connection Established indicator will show whether your connection is successfully made. This connection is required only once or whenever data changes.

Send single data

This sheet serves for importing single data. It means, when you have only 1 value or sensor, you can use this sheet. You also can send more sensors information in one step for different sensors or different quantities.

SensorLogin - select one of your already created sensors. If you write login of not existing sensor (the new sensor should be added into the last row - image bellow), new sensor will be added. Then reconnect yourself (in “twinzo connection” sheet) for downloading new list of sensors.

Timestamp - date and time when the data was collected. Please insert valid datetime format. For help with date and time follow: Troubleshooting.
Quantity - quantity of the value.
Value - collected value. It can be number, decimal number, True/False, String, negative number,…
Unit - unit of the value.
DataType - according to the value, select correct DataType. More info about DataType: Sensors Data | Data types.
Import data - button to import data.

Output in twinzo portal

Send multiple data

This sheet serves for importing many data for the same sensors and quantity. It means, when you have multiple data the of the same sensor and quantity, you can use this sheet.

In the top of the sheet enter information about sensor you want to import.

SensorLogin - select one of your already created sensors. If you write login of not existing sensor, new sensor will be added.
Quantity - quantity of the value.
Unit - unit of the value.
DataType - according to the value, select correct DataType. More info about DataType: Sensors Data | Data types.
Import data - button to import data.

There is the place for paste your collected information below.

Timestamp - date and time when the data was collected. Please insert valid datetime format. For help with date and time follow: Troubleshooting.
Value - collected value. It can be number, decimal number, True/False, String, negative number,…

Output in the twinzo portal

Send Data Periodically

To automate regular data submissions, please use the Google Sheets copy linked below. Follow the instructions to set up the SetRandomData function trigger and define the submission interval.

https://docs.google.com/spreadsheets/d/1jrz0wSSfx3-rqjVmrhy_oo6Ord6P6jwqqsdp2ik3PQA/copy

Setting up the Trigger

Open the Google Sheet and navigate to Extensions > Apps Script.
In the Apps Script editor, go to Triggers (clock icon).
Click Add Trigger in the lower right.
Select SetRandomData as the function to trigger.
Choose the desired frequency under Select event source > Time-driven:
- Options include Hourly, Daily, or Weekly intervals.
Define the interval that best fits your data submission schedule and save the trigger settings.

Data only from SendSingleData will be sent repeatedly.

Icon by Iconduck