Google Spreadsheets script for syncing to Firebase

google-sheets-sync-to-firebase.js

function syncToFirebase () {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();
  var numCols = rows.getNumColumns();
  var values = rows.getValues();
  
  var output = [];
  
  var sheetName = sheet.getName();
  var header = values[0];
  for (var i = 1; i < numRows; i++) {
    var row = values[i];
    var name = row[0];
    var obj = {};
    for (var j = 0; j < numCols; j++) {
      var key = header[j];
      var value = row[j];
      obj[key] = value;
    }
    output.push(obj);
  }
  Logger.log(output);

  var firebaseUrl = "https://webvr-6345b.firebaseio.com/webvrrocks/" + sheetName + "/";
  var base = FirebaseApp.getDatabaseByUrl(firebaseUrl);

  base.setData("", output);
}