GGSheets2RTDB_Appsscript.gs

function syncData() {
  var sheet = SpreadsheetApp.getActiveSheet()
  var [rows, columns] = [sheet.getLastRow(), sheet.getLastColumn()]
  var data = sheet.getRange(2, 1, rows-1, columns).getValues()
  
  var dataPath = 'Product'
  var projectId = 'ggsheets2rtdb'
  var region = 'asia-southeast1'
  
  var fireBaseUrl = 'https://' +projectId+ '-default-rtdb.' +region+ '.firebasedatabase.app/' +dataPath +'.json'
  var response = UrlFetchApp.fetch(fireBaseUrl, {
    method: "PUT",
    headers: {
      "Content-type": "application/json",
      "Authorization": "Bearer "+ScriptApp.getOAuthToken()
    },
    payload: JSON.stringify(data)
  });
  Logger.log(response)
}