Sync Google Sheets data to Firebase Realtime Database || 2022
Step 1 : Create project in Firebase
Open Firebase : https://firebase.google.com/
Click on “Get started” and create new project.
Once you create new project, click “Build” and select “Realtime Database”
Follow the instruction as shown in the video.
Step 2: Create google sheet
Open google sheet
Create new file and insert the data.
Publish the google to the web as shown in the video.
Once it is published, click “Extension” and select “Apps Script”
Step 3: Connect to firebase
Replace the code.gs file with : https://github.com/anish-gyawali/Ioni...
Click on project setting and select “Show "appsscript.json" manifest file in editor” as shown in the video and replace appsscript.json with : https://github.com/anish-gyawali/Ioni...
Select “Initialize” near to Debug as shown in the video and follow the instruction to grant permission.
Check the firebase “Realtime Database” you can see the excel data imported to firebase.