Dev Google Spreadsheets

Step 1: Create your Firebase project

Go to Create Database

Step 2: Create your Realtime database

Go to Create Database

Step 3: Create your spreadsheet and populate it

The first row contains your keys. The first key should be set to “id” and each row should be labeled with the corresponding number, starting with “1”. An easy way to set the id for each row in column A is to enter this formula “=COUNTA($B$2:B2)” into cell A2 and then apply that to all rows. You can add as many rows or columns as you need.

Step 4: Create your Apps Script project

In the menu, go to Tools -> Script editor

Step 5: Start the sync

Tip & Tricks

Add Security

Generating an Array

Nested data