How to Use Google Spreadsheet as a Backend for Your App

Sometimes a spreadsheet can stand in as a lightweight database. Here’s how to do it

Photo by Lukas Blazek on Unsplash

If you have a simple app and you don’t need a very complex backend, you can use a Google spreadsheet to store your data. What is a database in our backends? It’s a table, and Google spreadsheets are also tables. Let’s see how we can use these tables as a backend for our apps.

Init

Let’s start working with setting up Google API credentials because we are going to need them to transfer data between front and backends.

Obviously, we will need a Google developers account. You can go here and create one, it’s free.

Next, let’s create a new project: