//1eESQsmS6oo9YgFEo0DnILxtukfNf-5NwUdnqeeP7w4o
//https://script.google.com/macros/s/AKfycby1ForREXO6r45BwcoqWR7dzm6IrESZ6vyoFh0N6cmT9HIgF_Lv/exec?temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82&temperature=21&humidity=82
//https://script.google.com/macros/s/AKfycby1ForREXO6r45BwcoqWR7dzm6IrESZ6vyoFh0N6cmT9HIgF_Lv/exec?temperature=1,2&humidity=3,4
//-----------------------------------------------
// Author: Trieu Le
// Email: lethanhtrieuk36@gmail.com
// Publish date: 07-Oct-2015
// Description: This code for demonstration send data from ESP8266 into Google Spreadsheet
// GET request syntax:
// https://script.google.com/macros/s/AKfycby1ForREXO6r45BwcoqWR7dzm6IrESZ6vyoFh0N6cmT9HIgF_Lv/exec
//-----------------------------------------------
/**
* Function doGet: Parse received data from GET request,
  get and store data which is corresponding with header row in Google Spreadsheet
*/
function doGet(e) {
  Logger.log( JSON.stringify(e) );  // view parameters
  var result = 'Makker het doet pijn om goed aan het loggen te zijn.'; // assume success
  if (e.parameter == 'undefined') {
    result = 'No Parameters';
  }
  else {
    var sheet_id = '1eESQsmS6oo9YgFEo0DnILxtukfNf-5NwUdnqeeP7w4o';      // Spreadsheet ID
    var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();     // get Active sheet
    var newcolumn = sheet.getLastColumn() + 1;
    var rowData = [];
    var d = new Date();
    var timeStamp = d.getTime();

    var lastRow = sheet.getLastRow(); + 1
    var lastColumn = sheet.getLastColumn(); + 1

    rowData[0] = timeStamp;                                             // Timestamp in column A
    for (var param in e.parameter) {
      Logger.log('In for loop, param=' + param);
      var value = stripQuotes(e.parameter[param]);
      Logger.log(param + ':' + e.parameter[param]);

      switch (param) {
        case 'temperature': //Parameter
          var arrayT = value.split(",");
          Logger.log(JSON.stringify(arrayT));
          var newRange = sheet.getRange(1, newcolumn, 1, arrayT.length);
          newRange.setValues([arrayT]);

          break;

        case 'humidity': //Parameter
          var arrayH = value.split(",");
          Logger.log(JSON.stringify(arrayH));
          var newRange = sheet.getRange(2, newcolumn, 1, arrayH.length);
          newRange.setValues([arrayH]);
          break;

        default:
          result = "unsupported parameter";
      }
    }
  }
  // Return result of operation
  return ContentService.createTextOutput(result);
}
/**
* Remove leading and trailing single or double quotes
*/
function stripQuotes( value ) {
  return value.replace(/^["']|['"]$/g, "");
}
//-----------------------------------------------
// End of file
//-----------------------------------------------