How I Built a REST API Using Google Sheets

Not all apps need a database. Sometimes a spreadsheet will do

Photo by Khachik Simonian on Unsplash

Problem Statement

Google Sheets is where I keep track of my push-ups. I want to be able to visualize my push-ups, and I decided to build a data visualization chart using my own data. Without further ado, I swiftly explored the idea, discovered the possibility, and finalized my objectives.

Objectives

Here is the list of results that I want to achieve. I’ve organized them into both key results (must have) and bonus points (good to have).

Key results

• Build a REST API where I can retrieve the push-up count given the start date and the end date. For example, I’ll be able to retrieve my push-up count from 01-Jun-2020 to 30-Jun-2020.

Bonus points

• I am not required to move my push-up data, which is already in Google Sheets.
• High availability — In the midst of developing my REST API, I can still continue to log my push-up record and don’t need to insert my push-up data manually after development is completed.

As I do not want to introduce more effort in logging my push-ups, if I can build something on top of the current…