How to Sync Google Sheets spreadsheet with the Firebase database?

Question

I want to know if there's any solution to integrate Google Sheets spreadsheet with a Firebase database.

The use case is having a spreadsheet file stored in Google Drive, where I want to automatically sync data with the Firebase database (JSON format), and upon updating the spreadsheet file, I want Firebase to refresh and update the data stored.

Answer 1

Agreed with you @Morfinismo. You might need to listen to edit event from the scripts and then communicate with the firebase from there

/**
 * The event handler triggered when editing the spreadsheet.
 * @param {Event} e The onEdit event.
 */
function onEdit(e) {
  // update firebase from here
}

For more information on setting up googlescript check https://developers.google.com/apps-script/overview

For more information on connecting googlescript with firebase check https://sites.google.com/site/scriptsexamples/new-connectors-to-google-services/firebase