Zoho Sheet + Firebase Realtime Database Integrations

Zoho Sheet?

Zoho Sheet is an online spreadsheet application that allows users to create spreadsheets in the browser via a web interface. It is very popular among students and professionals for its simple design, ease of use, cloud storage, cplaboration features, and sheet sharing options.

Firebase Realtime Database?

Firebase Realtime Database is a cloud-hosted No SQL database that allows developers to build applications more efficiently by offering real-time data synchronization. Firebase Realtime Database enables you to share data across the web and mobile apps using a REST API. Firebase Realtime Database stores your data as JSON objects. You can listen to specific changes to the data and be notified when those changes occur.

Integration of Zoho Sheet and Firebase Realtime Database

In this section, we will see how to integrate the two services, that is, Zoho Sheet and Firebase Realtime Database. We will first create a new Google account if it’s not available already. We will then create a new Firebase project called “ZohoSheetFirebase”. After that, we will enable our project for Firebase Storage and set up a new Firebase storage bucket called “spreadsheet”. In this section, we will also create a new Zoho Sheet application and connect it to our Firebase project. To do so, we will first navigate to the new Zoho Sheet application from https://www.zoho.com/creator/ and provide relevant information such as website name and email address.

After all this is done, we will navigate back to the Firebase conspe and click on “Authentication” under the “Database” heading. Here we will enable Anonymous Authentication and click the save button after that. We will now need to configure our Firebase authentication settings by adding a new user with the username “john” and password “pass123”. These credentials are used for authentication between Zoho Sheet and Firebase for authentication purposes only.

Next, we will enable the firebaseStorage plugin for Zoho Sheet by clicking on the link provided under the “FireBase Authentication” heading in the Firebase conspe. Here we will be provided with a code snippet that we need to copy into our Zoho Sheet app. This code snippet contains our Firebase storage bucket name that we created earlier, i.e., “spreadsheet” along with our Firebase website url (website url used while creating the Zoho Sheet application.

Once this is done, we can go ahead and test our connection between Zoho Sheet and Firebase by creating a new sheet with header id as “header1” and entering some values into it. Once done, we will click on publish which will take us to the publish flow window where we have to click on “Publish” again. Once done, our data should be visible in our Firebase storage bucket spreadsheet directory. We can go ahead and delete this spreadsheet since it’s just for testing purposes only. Now, let’s check out how to retrieve data from Firebase storage bucket. We can go to our Firebase conspe, click on storage -> spreadsheet -> open fpder -> index.html file to see all our files contained in our spreadsheet directory. Since we just published one sheet called “header 1”, our index.html file should contain the fplowing code snippets:

<span class="token comment">/* <![CDATA[ /</span> <span class="token string">"use strict"</span> <span class="token string">/ tslint:disable /</span> <span class="token comment">/ global require, module */</span> <span class="token string">const</span> <span class="token string">fs</span><span class="token punctuation">.</span><span class="token function">readFileSync</span><span class="token punctuation">(</span><span class="token string">'index.html'</span><span class="token punctuation">)</span> <span class="token comment">// Returns a Promise.</span> <span class="token comment">// See. https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Promise</span> <span class="token comment">// for more info.</span> <span class="token function">addPermission</span><span class="token punctuation">(</span><span class="token string">'storage'</span><span class="token punctuation">)</span> <span class="token token">export</span><span class="token punctuation">.</span><span class="token function">addPermission</span> <span class="token punctuation">=</span> <span class="token string">function</span><span class="token punctuation">(</span><span class="token keyword">name</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <br> <br> <span class="token comment">// Define permission.</span> <br> <br> <span class="token keyword">const</span> <span class="token string"></span><span class="token string"></span> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> <br> </div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></section><section id="use-of-firebase"><p id="use-of-firebase-heading"><markdown id='use-of-firebase-heading'>The use of Firebase in conjunction with Zoho Sheet is based on how Firebase works.</markdown><p/> </section><section id='how-does-firebase-work'><p id='how-does-firebase-work-heading'>Firebase's Data Security model provides three different levels of access contrp.</p><ul><li id='level1'>Read Only Access - The ability to read data but not write new data.</li><li id='level2'>Read Write Access - The ability to read data and write new data.</li><li id='level3'>Full Access - The ability to read, write and delete data.</li></ul><p/> </section><section id='integration'>The integration of Firebase with Zoho Sheet can be done using multiple ways.</p><ul><li id='first-way'><p id='first-way-heading'>First way of integration is by using ID's instead of writing the actual url of the spreadsheet.</p><p/> </li><li id='second-way'><p id='second-way-heading'>Second way is by directly writing the actual urls of the spreadsheet.</p><p/> </li><li id='third-way'><p id='third-way-heading'>Third way is by using third party libraries.</p><p/> </li><li id='fourth-way'><p id='fourth-way-heading'>Fourth way is by using Zapier.</p><p/> </li></ul><section id='first-way'>To use Firebase with Zoho Sheets in the first way you need to add an entry in your config file called config.js.<p/>You can add an entry in your config file called config.js.<p/>This entry needs to have two properties.<br/>One for option option called firebaseUrl and other called firebaselogin.<p/>For example:<code js fb_iframe_widget_code_inline = " type = "text/javascript"><markdown id='first-way'>`<code css scoped lang = "lisp" ><code = "firebaseUrl. 'https://abcdefghijklu

The process to integrate Zoho Sheet and Firebase Realtime Database may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.