将firebase DB值导入googlesheet

function importFirebaseData() {
  var firebaseConfig = {
    apiKey: "YOUR_API_KEY",
    authDomain: "YOUR_AUTH_DOMAIN",
    databaseURL: "YOUR_DATABASE_URL",
    projectId: "YOUR_PROJECT_ID",
    storageBucket: "YOUR_STORAGE_BUCKET",
    messagingSenderId: "YOUR_MESSAGING_SENDER_ID",
    appId: "YOUR_APP_ID"
  };

  // 初始化 Firebase
  firebase.initializeApp(firebaseConfig);

  // 获取 Firebase 数据库引用
  var database = firebase.database();

  // 获取要导入的 Firebase 数据库路径
  var firebasePath = "YOUR_FIREBASE_PATH";

  // 获取要导入的 Google Sheets 工作表
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  // 获取 Firebase 数据库中的值
  var firebaseData = database.ref(firebasePath);

  // 将 Firebase 数据库中的值导入到 Google Sheets
  firebaseData.once('value', function(snapshot) {
    var data = snapshot.val();
    var row = 1;
    for (var key in data) {
      sheet.getRange(row, 1).setValue(key);
      sheet.getRange(row, 2).setValue(data[key]);
      row++;
    }
  });
}