Integrate into Google Sheets via Helium
Google Sheets is a web-based application that enables users to create, update and modify spreadsheets and share the data online in real time.
The Google Sheets online spreadsheet application enables users to create, edit and format spreadsheets online to organize and analyze information. Google Sheets is often compared to Microsoft Excel, as both applications are used for similar purposes. Google Sheets is essentially Google's cloud-based version of Microsoft Excel's basic features.
Thanks to Helium's integration capabilities, we can easily save sensor data via Google Sheets and do some simple data analysis accordingly.
Upgradable to Industrial Sensors
With the SenseCAP S2110 controller and S2100 data logger, you can easily turn the Grove into a LoRaWAN® sensor. Seeed not only helps you with prototyping but also offers you the possibility to expand your project with the SenseCAP series of robust industrial sensors.
The IP66 housing, Bluetooth configuration, compatibility with the global LoRaWAN® network, built-in 19 Ah battery, and powerful support from APP make the SenseCAP S210x the best choice for industrial applications. The series includes sensors for soil moisture, air temperature and humidity, light intensity, CO2, EC, and an 8-in-1 weather station. Try the latest SenseCAP S210x for your next successful industrial project.
Create Google Form
If you have not registered for a Google account prior to learning this tutorial, please complete your Google account here first.
Once you have completed your account registration, please login to the Google Forms page. Then, simply create a new Google Form.
We recommend setting questions to "Short answer".
Here, I will create a table using Vision AI Module as an example. This table should have two sets of data, one for the number of people detected and its confidence level.
Short Answer needs to be selected for each new sensor tag created.
Head over to the responses tab and tell the form you want your results sent to Google Sheets by clicking the Google Sheets button.
Simply enter the Google Form title in the new pop-up window and click the Create button at the bottom right.
Make sure we have created the required columns.
Make Form Public
Go back to our form setup page and click on the Send button in the top right hand corner to get the link to share the form.
You'll get a share link like this one.
https://docs.google.com/forms/d/e/1FAIpQLSce9ozQMVwdgIYXYyutRPeE5opGba6724QGEN_I_dvoEH_Muw/viewform?usp=sf_link
We're only after the ID of the form, so we're going to remove the prefix https://docs.google.com/forms/d/e/ and suffix /viewform?usp=sf_link. We should be left with a big string that contains no slashes.
1FAIpQLSce9ozQMVwdgIYXYyutRPeE5opGba6724QGEN_I_dvoEH_Muw
Please record this ID, which will be used in the Helium integration.
Add Google Sheets Integration in Helium
Go back to Helium and add a Google Sheets integration in Console, go to Integrations on the left-hand menu. Select the integration to add - in this case, the Google Sheets integration as shown below.
Click Add Integration in the new page.
On the new page, we enter the form ID we obtained above into the corresponding field and click on Get Google Form Fields to check if the ID is correct. If, after clicking on it, we are able to get the content of the labels in the columns of the form, the link is correct.
Click on Generate Function Body w/ Fields Above at the bottom and Helium will automatically generate the required decoder for us.
At this point, you don't have to rush to click on the Add Integration button on the right, as the integration still needs a little modification to accommodate the sensor values we have passed on.
Create your Decoder
We have prepared the code for the complete decoder required to import all the sensors in the kit into Google Sheets for you, please refer to the table below.
Before using the decoder code for the corresponding sensor, please ensure that you have followed the tutorial above to create and share the Google Form. And if you want to use the code provided by us directly, the label of the sensor in your form should also match the code.
| Sensor Type | Download Address |
|---|---|
| Wio Terminal built-in light sensor | Download |
| Wio Terminal built-in IMU sensor | Download |
| Soil Moisture Sensor | Download |
| VOC and eCO2 Gas Sensor (SGP30) | Download |
| Temp&Humi Sensor (SHT40) | Download |
| Vision AI Module | Download |
The decoder used by Google Forms cannot be used with the decoder provided in the Connecting to Helium.
Continuing from the previous step, we need to copy and replace the code area of Helium with the codec of the sensor you are using, and then just click Add Integration on the right hand side.
Of course, don't forget that we need to add the integration of the decoder and Google Forms to the Flow.
Upload code send data to Helium
Please follow the instructions in the Connecting to Helium tutorial to upload the code to send your sensor values to Helium.
Once the data has started to be sent, you can see a live refresh of the data from Google Sheets.
You can also do what I did above, add a variety of table styles to Google Sheets to make it more intuitive and easier for you to see data or understand trends in your data.
Tech Support & Product Discussion
Thank you for choosing our products! We are here to provide you with different support to ensure that your experience with our products is as smooth as possible. We offer several communication channels to cater to different preferences and needs.