Sync Excel data to Firebase Realtime Database || 2022

why is the appscript not working for me? is it because my database url is .app?

Thank you bro, much love! It works. August 2023

Hi, I have a sheet presenting cities and universities and so on. But when I add a new university with same city name it only shows the last university row in same city. Do you know how to fix that?

I can't choose initialize function. It always shows myFunction. How I solve that?

I want your help sir...after signup the data is shown in firebase database but after refreshing it the data get disapper ....plz give the solution for it what to do ani how to do....plz

Wow , amazing tutorial.
How can we convert the data in the firebase to visual analytical data? Like in terms of graphs and charts .

do you know how to export text.exe file to firebase by automatically?

It cannot save appsscript.json

This video is wonderful! You are to be congratulated, however I made a small adjustment to the code so that it goes through all the tabs on import.

function getEnvironment() {
var environment = {
spreadsheetID: "replace with your keys",
firebaseUrl: "replace with your keys/",
};
return environment;
}

// Creates a Google Sheets on change trigger for the specific sheet
function createSpreadsheetEditTrigger(sheetID) {
var triggers = ScriptApp.getProjectTriggers();
var triggerExists = false;
for (var i = 0; i < triggers.length; i++) {
if (triggers[i].getTriggerSourceId() == sheetID) {
triggerExists = true;
break;
}
}

if (!triggerExists) {
var spreadsheet = SpreadsheetApp.openById(sheetID);
ScriptApp.newTrigger("importSheet")
.forSpreadsheet(spreadsheet)
.onChange()
.create();
}
}

// Delete all the existing triggers for the project
function deleteTriggers() {
var triggers = ScriptApp.getProjectTriggers();
for (var i = 0; i < triggers.length; i++) {
ScriptApp.deleteTrigger(triggers[i]);
}
}

// Initialize
function initialize(e) {
writeDataToFirebase(getEnvironment().spreadsheetID);
}

// Write the data to the Firebase URL
function writeDataToFirebase(sheetID) {
var ss = SpreadsheetApp.openById(sheetID);
SpreadsheetApp.setActiveSpreadsheet(ss);
createSpreadsheetEditTrigger(sheetID);
var sheets = ss.getSheets();

for (var i = 0; i < sheets.length; i++) {
importSheet(sheets[i]);
}

function importSheet(sheet) {
var name = sheet.getName();
var data = sheet.getDataRange().getValues();

var dataToImport = {};

for (var i = 1; i < data.length; i++) {
dataToImport[data[i][0]] = {};
for (var j = 0; j < data[0].length; j++) {
assign(dataToImport[data[i][0]], data[0][j].split("__"), data[i][j]);
}
}

var token = ScriptApp.getOAuthToken();

var firebaseUrl =
getEnvironment().firebaseUrl + sheet.getParent().getId() + "/" + name;
var base = FirebaseApp.getDatabaseByUrl(firebaseUrl, token);
base.setData("", dataToImport);
}

function assign(obj, keyPath, value) {
lastKeyIndex = keyPath.length - 1;
for (var i = 0; i < lastKeyIndex; ++i) {
key = keyPath[i];
if (!(key in obj)) obj[key] = {};
obj = obj[key];
}
obj[keyPath[lastKeyIndex]] = value;
}
}

how to connect microsoft excel with firebase ? also what if we want to add multiple files ?

Thank you! Solved my issue like a charm, thanks!! Learning lots more from you!

I added an excel file to the previously created project but it is not showing even after i followed your steps sincerely.Please please help and respond asappp

Good job, keep helping others

Thanks

can i change the name of sheet1

Nice one, worked like a magic.

Thanks for tutorial bro.. Good tutorial... ❤️❤️

excellent synchronization of sheet to firebase
but from firebase to sheet it doesn't sync
¿some example?

10x bro, worked like a charm!

Thanks for your tutorial 👍

i want to import multiple tables

Sir if there are multiple excel tables the how we define url of deffrent tables

so good

Can it, combined with koldular to load db

please , Can you show us how to retrieve database from Firebase to Google Sheets?

many thanks