El art\u00edculo que enlazo explica perfectamente c\u00f3mo hacerlo, pero dejo aqu\u00ed los pasos generales:<\/p>\n
- \n
- Crear una hoja de c\u00e1lculo en Google Spreadsheet, y ponerle un nombre (ojo, tanto al documento como a la hoja en s\u00ed) descriptivo.<\/li>\n
- Ir a Herramientas > Editor de secuencias de comandos, e introducir el c\u00f3digo que se adjunta:<\/li>\n<\/ul>\n
\n\/\/ 2017 by Daniel Eichhorn, https:\/\/blog.squix.org
\n\/\/ Inspired by https:\/\/gist.github.com\/bmcbride\/7069aebd643944c9ee8b
\n\/\/ Create or open an existing Sheet and click Tools > Script editor and enter the code below
\n\/\/ 1. Enter sheet name where data is to be written below
\nvar SHEET_NAME = \"Sheet1\";
\n\/\/ 2. Run > setup
\n\/\/ 3. Publish > Deploy as web app
\n\/\/ - enter Project Version name and click 'Save New Version'
\n\/\/ - set security level and enable service (most likely execute as 'me' and access 'anyone, even anonymously)
\n\/\/ 4. Copy the 'Current web app URL' and post this in your form\/script action<\/p>\nvar SCRIPT_PROP = PropertiesService.getScriptProperties(); \/\/ new property service<\/p>\n
\/\/ If you don't want to expose either GET or POST methods you can comment out the appropriate function
\nfunction doGet(e){
\n return handleResponse(e);
\n}<\/p>\nfunction doPost(e){
\n return handleResponse(e);
\n}<\/p>\nfunction handleResponse(e) {
\n var lock = LockService.getPublicLock();
\n lock.waitLock(30000); \/\/ wait 30 seconds before conceding defeat.<\/p>\ntry {
\n \/\/ next set where we write the data - you could write to multiple\/alternate destinations
\n var doc = SpreadsheetApp.openById(SCRIPT_PROP.getProperty(\"key\"));
\n var sheet = doc.getSheetByName(SHEET_NAME);
\n \/\/ we'll assume header is in row 1 but you can override with header_row in GET\/POST data<\/p>\n\/\/var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];<\/p>\n
var nextRow = sheet.getLastRow()+1; \/\/ get next row
\n var row = [];
\n var headerRow = [];
\n \/\/ loop through the header columns
\n var jsonData = JSON.parse(e.postData.contents);<\/p>\nheaderRow.push(\"jsonData.app_id\");
\n headerRow.push(\"jsonData.dev_id\");
\n headerRow.push(\"jsonData.hardware_serial\");
\n headerRow.push(\"jsonData.port\");
\n headerRow.push(\"jsonData.counter\");
\n headerRow.push(\"jsonData.payload_raw\");
\n headerRow.push(\"jsonData.payload_decoded\");
\n headerRow.push(\"jsonData.metadata.time\");
\n headerRow.push(\"jsonData.metadata.frequency\");
\n headerRow.push(\"jsonData.metadata.modulation\");
\n headerRow.push(\"jsonData.metadata.data_rate\");
\n headerRow.push(\"jsonData.metadata.coding_rate\");
\n headerRow.push(\"jsonData.metadata.downlink_url\");
\n for (var i = 0; i < jsonData.metadata.gateways.length; i++) {\n var gateway = jsonData.metadata.gateways[i];\n headerRow.push(\"gateway.gtw_id\");\n headerRow.push(\"gateway.timestamp\");\n headerRow.push(\"gateway.channel\");\n headerRow.push(\"gateway.rssi\");\n headerRow.push(\"gateway.snr\");\n headerRow.push(\"gateway.latitude\");\n headerRow.push(\"gateway.longitude\");\n headerRow.push(\"gateway.altitude\");\n }\n sheet.getRange(1, 1, 1, headerRow.length).setValues([headerRow]);\n \n row.push(jsonData.app_id);\n row.push(jsonData.dev_id);\n row.push(jsonData.hardware_serial);\n row.push(jsonData.port);\n row.push(jsonData.counter);\n row.push(jsonData.payload_raw);\n var raw = Utilities.base64Decode(jsonData.payload_raw);\n var decoded = Utilities.newBlob(raw).getDataAsString();\n row.push(decoded);\n row.push(jsonData.metadata.time);\n row.push(jsonData.metadata.frequency);\n row.push(jsonData.metadata.modulation);\n row.push(jsonData.metadata.data_rate);\n row.push(jsonData.metadata.coding_rate);\n row.push(jsonData.metadata.downlink_url);\n for (var i = 0; i < jsonData.metadata.gateways.length; i++) {\n var gateway = jsonData.metadata.gateways[i];\n row.push(gateway.gtw_id);\n row.push(gateway.timestamp);\n row.push(gateway.channel);\n row.push(gateway.rssi);\n row.push(gateway.snr);\n row.push(gateway.latitude);\n row.push(gateway.longitude);\n row.push(gateway.altitude);\n\n }\n\n \/\/ more efficient to set values as [][] array than individually\n sheet.getRange(nextRow, 1, 1, row.length).setValues([row]);\n \/\/ return json success results\n return ContentService\n .createTextOutput(JSON.stringify({\"result\":\"success\", \"row\": nextRow}))\n .setMimeType(ContentService.MimeType.JSON);\n } catch(e) {\n \/\/ if error return this\n return ContentService\n .createTextOutput(JSON.stringify({\"result\":\"error\", \"error\": e}))\n .setMimeType(ContentService.MimeType.JSON);\n } finally { \/\/release lock\n lock.releaseLock();\n }\n}\n\nfunction setup() {\n var doc = SpreadsheetApp.getActiveSpreadsheet();\n SCRIPT_PROP.setProperty(\"key\", doc.getId());\n}\n<\/code><\/p>\n- \n
- Ejecutar la funci\u00f3n \"setup\" mediante Ejecutar > Ejecutar funci\u00f3n > Setup. Indicar los permisos adecuados para acceder a la hoja de c\u00e1lculo creada anteriormente.<\/li>\n
- Publicar el script mediante Publicar > Implementar como aplicaci\u00f3n web. Crear un nombre de versi\u00f3n descriptivo, indicar que el nivel de seguridad para ejecutar la aplicaci\u00f3n ser\u00e1 \"Yo\", e indicar que el acceso a la aplicaci\u00f3n ser\u00e1 para \"Cualquiera, incluso an\u00f3nimo\" (a esto me refer\u00eda con la seguridad de la informaci\u00f3n m\u00e1s arriba).<\/li>\n
- Copiar la URL de la aplicaci\u00f3n web que nos genera.<\/li>\n
- Posteriormente, en la consola de TTN, ser\u00e1 necesario a\u00f1adir a nuestra aplicaci\u00f3n una integraci\u00f3n de tipo HTTP, creando un Process ID significativo, indicar la Access Key como \"default\", a\u00f1adiendo la URL que hemos copiado anteriormente, e indic\u00e1ndo que el m\u00e9todo HTTP a utilizar ser\u00e1 \"POST\".<\/li>\n<\/ul>\n
Y con esto, la informaci\u00f3n generada por nuestros dispositivos LoRaWAN registrados en TTN pasar\u00e1 a almacenarse de manera autom\u00e1tica en nuestra hoja de c\u00e1lculo:<\/p>\n
![\"Datos](\"http:\/\/bitacora.eniac2000.com\/wp-content\/uploads\/2021\/02\/datos-lorawan-spreadsheet-400x101.jpg\" "\\"Datos")
<\/a>