Export from Google spreadsheet to Firebase, ERROR

Question

I think most of my mistakes come from Firebase updates. But I get there.

Still loving Firebase!

Ok, I'm trying to export a Spreadsheet demo table to Firebase (below code). The error seems to be related to the Firebase link. I know how to fix this in Firebase projects, but it is connected to the spreadsheet Script editor.

ERROR: ReferenceError: "FirebaseApp" not defined. (line 13, file "Export")

function writeDataToFirebase() {
  var ss = 

SpreadsheetApp.openById("1rV2_S2q5rcakOuHs2E1iLeKR2floRIozSytAt2iRXo8");
  var sheet = ss.getSheets()[0];
  var data = sheet.getDataRange().getValues();
  var dataToImport = {};
  for(var i = 1; i < data.length; i++) {
    var year = data[i][0];
    dataToImport[year] = {
    caption:data[i][1]
  };
}

 var firebaseUrl = "https://test-db-9833d.firebaseio.com/";

 // ERROR HERE ********************************************

 var base = FirebaseApp.getDatabaseByUrl(firebaseUrl);
 base.setData("", dataToImport);

}

Answer 1

Google Firebase-, , , :

• Google
• URL firebase.
• firebase, true, , , perm
• , Logger.log, , ?

, : https://www.youtube.com/watch?v=9SIAnjgKZZQ&feature=youtu.be

, , dinamic " " :)

function onfire() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var range = sheet.getDataRange();
  var values = range.getValues();
  var allvals = []; var row = {};
  for(var i = 1; i < values.length; i++) {
    for( var j = 0; j < values[i].length; j++ ){
      if( values[i][j] ) {
        row[ values[0][j].toString() ] = values[i][j] ;
      }
    }
    allvals.push( row ); // insert row
    row = {}; // blank template obj
  }
  var firebaseUrl = "https://my-android-app-demo1.firebaseio.com/sheet";
  var base = firebase.getDatabaseByUrl(firebaseUrl, sec);
  // Logger.log( allvals );
  base.setData("", allvals );
}

hth, kres

Answer 2

JavaScript, FirebaseApp :

// Load Firebase library 
var firebaseScript = document.createElement('script');
firebaseScript.setAttribute('src', 
    'https://www.gstatic.com/firebasejs/4.1.1/firebase.js');
document.head.appendChild(firebaseScript);

// Initialize Firebase
// TODO: Replace with your project customized code snippet
var config = {
    apiKey: "<API_KEY>",
    authDomain: "<PROJECT_ID>.firebaseapp.com",
    databaseURL: "https://<DATABASE_NAME>.firebaseio.com",
    storageBucket: "<BUCKET>.appspot.com",
    messagingSenderId: "<SENDER_ID>",
};

var app = firebase.initializeApp(config);

, Webpack Browserify, firebase, :

var firebase = require("firebase/app");
require("firebase/auth");
require("firebase/database");

var config = {
  // ...
};

var app = firebase.initializeApp(config);

Answer 3

: script : : MYeP8ZEEt1ylVDxS7uyg9plDOcoke7-2l 11- script

: https://sites.google.com/site/scriptsexamples/new-connectors-to-google-services/firebase