Sends data to Google Drive with Johnny-five and request

README.md

Google Sheets Template:

https://docs.google.com/spreadsheets/d/1RgJ9S52lzCEM05K46xQffEO_QHocIUQ-xvSXac8TJng/edit?usp=sharing

Google Sheets Script:

function salvarDado(valor) {
  var url = "https://docs.google.com/spreadsheets/d/1RgJ9S52lzCEM05K46xQffEO_QHocIUQ-xvSXac8TJng/edit#gid=0";  
  var planilha = SpreadsheetApp.openByUrl(url);
  var dados = planilha.getSheetByName('Dados');
  
  dados.insertRowBefore(2);
  dados.getRange("A2").setValue(new Date());
  dados.getRange("B2").setValue(valor);
}

function doGet(propriedades){
  salvarDado(propriedades.parameter.sensor);
  
  var output = "Valor salvo: "+propriedades.parameter.sensor;
  
  return HtmlService.createHtmlOutput(output);
}

JohnnyWithDrive.js

var five = require('johnny-five');
var request = require('request');

var url = 'https://script.google.com/macros/s/YOUR-APP-ID-HERE/exec';
var board = new five.Board();

board.on("ready", function() {
  var sensor = new five.Pin("A0");

  // Faz leitura unica e loga o valor
  function lerSensor(){
    sensor.query(function(state) {
      console.log(state.value);
      request(url + '?sensor=' + state.value);
    })
  };
  
  // Inicia leitura do sensor a cada 1s
  setInterval(lerSensor, 3000);

});