Streamline Data to Firebase

I'm seeking a savvy developer to build a bridge between Google Sheets and Firebase, maximizing data efficiency without rush.

Key Tasks:
- Connect Google Sheet data to Firebase.


Ideal Candidate Attributes:
- Expert in Google Apps Script.
- Proven Firebase integration experience.


This project isn't urgent so we can prioritize quality and innovation. Can't wait to collaborate with someone who shares a vision for streamlined workflows and impeccable data management.


Need to be able to delete collection be importing fresh data.
This script needs to be amended so that it can
1. get column names from the sheet.
2. use the sheet name of the user as the collection name
3. toggle between Prod and development environment

function writeDataToFirebase() {
var ss = SpreadsheetApp.openById("###############");
var sheet = ss.getSheets()[0];
var data = sheet.getDataRange().getValues();
var dataImport = {};
var firebaseUrl = "#######";
var firestore = FirestoreApp.getFirestore("###################");
for(var i = 1; i < data.length; i++) {
dataImport ={
"Type": data[i][0],
"Question": data[i][1],
"Order" : data[i][2]
}
firestore.createDocument("ChatQuestions", dataImport)