Differences
This shows you the differences between two versions of the page.
|
iothings:proiecte:2023sric:loratrackingsystem [2024/05/30 01:49] sebastian.matusa [References] |
iothings:proiecte:2023sric:loratrackingsystem [2024/05/30 01:56] (current) sebastian.matusa [Google Sheets Data] |
||
|---|---|---|---|
| Line 275: | Line 275: | ||
| {{:iothings:proiecte:2023sric:webhook.png?800|}} | {{:iothings:proiecte:2023sric:webhook.png?800|}} | ||
| + | The webhook configuration is designed to bridge The Things Network (TTN) application with Google Sheets. The webhook, identified as "iot-sric-project-webhook," is set to format data in JSON and directs uplink messages to a specified Google Script URL. This setup ensures that uplink messages received by the TTN application are forwarded to Google Sheets for logging and further analysis. This integration facilitates seamless data transfer from IoT devices to a user-friendly and accessible data management platform. | ||
| - | ==== Google Sheets Script ==== | + | |
| + | |||
| + | ==== Google Sheets ==== | ||
| + | The data received in Google Sheets includes the following fields: Device ID, Application ID, Device EUI, Device Address, Received At, Port, Undecoded Payload, SSIDs, Gateway ID, EUI, RSSI, SNR, Latitude, Longitude, and Altitude of the gateway. | ||
| + | |||
| + | === Google Sheets Script === | ||
| <code> | <code> | ||
| Line 405: | Line 411: | ||
| The primary purpose of this script is to collect and organize data from LoRaWAN devices into a structured format within a Google Sheets spreadsheet. It handles both the data from the devices themselves (including SSIDs detected by the devices) and metadata from the gateways that received the uplink messages, ensuring all relevant information is logged efficiently. | The primary purpose of this script is to collect and organize data from LoRaWAN devices into a structured format within a Google Sheets spreadsheet. It handles both the data from the devices themselves (including SSIDs detected by the devices) and metadata from the gateways that received the uplink messages, ensuring all relevant information is logged efficiently. | ||
| - | === Google Sheets Data === | + | |
