google_sheet_datalogger.gs

/*
 * IOT Google Sheets datalogger skript
 * Roboking
 * Arduino YUN
 */
function doGet(e) {
  Logger.log( JSON.stringify(e) );

  var result = 'Ok';

  if (e.parameter == undefined) {
    result = 'No Parameters';
  }
  else {
    var id = '12i4Iflw3PuzUSKxEu6m4LWonrjQY3970P0q20aXaoro';//Google SpreadsheetURL id
    var sheet = SpreadsheetApp.openById(id).getActiveSheet();
    var newRow = sheet.getLastRow() + 1;
    var rowData = [];
    rowData[0] = new Date(); // Cas a datum sa zapisuje do kolonky A

    for (var param in e.parameter) {
      Logger.log('In for loop, param='+param);
      var value = stripQuotes(e.parameter[param]);
      switch (param) {
        case 'Data1': //Parameter Data1
          rowData[1] = value; //Hodnota sa zapise do bunky B
          break;
        case 'Data2': //Parameter Data1
          rowData[2] = value; //Hodnota sa zapise do bunky C
          break;
        case 'Data3':
          rowData[3] = value;
          break;
        default:
          result = "unsupported parameter";
      }
    }
    Logger.log(JSON.stringify(rowData));

    //Tvorba noveho riadku
    var newRange = sheet.getRange(newRow, 1, 1, rowData.length);
    newRange.setValues([rowData]);
  }

  // Navrat vysledku operacie
  return ContentService.createTextOutput(result);
}

/**
* Odobranie uvodzoviek a apostrofov
*/
function stripQuotes( value ) {
  return value.replace(/^["']|['"]$/g, "");
}