Lido Guides

How to Import Firebase Data to Lido

  • Import Firebase data in just a few clicks
  • Lido looks just like Google Sheets but with more advanced features!
  • No complex code or developer time needed!
100% FREE - No Credit Card Required

In this article we will show you how to import firebase data to Lido in just a few simple steps. Lido looks just like Google Sheets or Excel but with more advanced functionality that saves users time!

1. Generate a Firebase service account key

Lido requires the Firebase database URL and a service account key to access Firebase data. Currently, Lido supports Realtime Database so make sure your data is stored there. Additionally, you should ensure that the database is built such that Firebase auto-generates a key for each record. You can visually confirm this by clicking Realtime Database in the left sidebar. A preview where you can check the individual entries will appear. It should look like the following:

The key (obscured here for security) appears as a randomly-generated string containing the values for a selected record. 

Once you confirm this is the case, you can now proceed to generating a service account key. Here are the steps:

Step 1: Click the gear icon besides the Project Overview in the left sidebar.

Step 2: In the Project settings, click Service accounts. The Firebase database URL is also included in this page, listed within the code box as value for the databaseURL attribute.

Step 3: Scroll down the page and click Generate new private key.

A pop-up will appear, reminding you to keep the generated key safe.

The key will be automatically downloaded to your device! Open it using a text editor to extract it.

2. Import Firebase to Lido

Click here to sign to create a Lido account

Step 1: Click Data tab on the upper-left corner of Lido.

A list of sources that you can integrate will appear. Look for Firebase, and click it. 

Step 2: Enter the following information:

Alias: the name you want to give to the integration

Firebase database URL: the URL of your Firebase database

Service Account Key: The code in the key file you downloaded using the steps from the previous section

Scroll down then you can either click Test connection to check if you got the information or click Connect.

Step 3: When Lido successfully connects to your database, the Database editor will be automatically loaded. Click the drop-down box below the Select Firebase Service label, and select Realtime Database

Once you are done, click Open Data Explorer.

Step 4. The Data Explorer shows all the tables in your database. Select the data columns, then click Save. Take note that a column named Key is included in the listed columns. This is auto-generated whenever a new entry is added to Firebase. Make sure that they are unticked before you click Save

You will be shown a preview of the data. If you are satisfied, click Save dataset & add view.

Voila! The data is now loaded to your spreadsheet. You can now do data crunching on it and create dashboards displaying the data. 

We can clearly see that it is easier to integrate different platforms into Lido for data analysis, dashboarding, and generating reports. Try it now!

Turn your spreadsheet into software