Lido Guides

How to Import Firestore Data to Lido

  • Import Firestore 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 Firestore data to Lido in just a few simple steps. Make sure you create a Lido account before following the steps below.

How to generate a service account key

As Firestore is part of Firebase, you still need the Firebase database URL and a service account key to access Firestore data. 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.

Import Firestore to Lido

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

After entering the access information, 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 Firestore

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.

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

Voila! Your spreadsheet now contains the data. You can calculate KPIs from it and create dashboards displaying the data. 

It is clear 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