Steph Smith tracks everything she does in Google Sheets.

From how often she exercises, how many books she gets through, how often she learns to code and a lot more.

She does this to quantify her progress in all facets of her life.

Taking this idea, she came up with a project called Progression Page in which each member can log their daily progress in terms of what they’re learning.

This information is directly pulled from Google Sheets and displayed on the web page.

It is one of the many examples where Google Sheets can be used as a database.

It’s advantageous to use it because of ease of viewing, editing and scaling the information as needed.

Keeping this functionality of Google Sheets in mind, Steph has drafted a tutorial covering 3 ways to link with the Google API for those using NodeJS which covers:

– HTTP requests with v3

– OAuth2 with v4

– OAuth2 with google-spreadsheet

– Utilizing the data in an express app.

Read the tutorial here.

Credits: Steph Smith on Twitter

TO DO: Follow Steph Smith’s tutorial on using google sheets as database in express app

Related

Prosthetics that pick signals from…

Bionic arms such as the Hero Arm, by Open Bionics, are used… 

  • 9

Build an iOS app with minimal coding

SwiftUI is one of the simplest ways to build user… 

  • 10

Render smooth 3D models in your browser

Zdog is a 3D JavaScript engine for canvas tag and SVG. You… 

  • 10

Start coding in V in just 90 minutes

‘Simple, fast, safe, compiled language for developing… 

  • 10

The small business website teardown

FreshChalk co-founder Adam Doppelt spent more than a month… 

  • 9

How to e-mail like a pro

The thing about e-mail writing is that physical cues are… 

  • 16

Why bootstrapped startups should go for…

Founders of bootstrapped startups do not find much time at… 

  • 11

6 ways to manage finances like a ninja

Managing personal finance is a skill one must start honing… 

  • 12

Getting started with front end dev, UI…

Founder of AI software Explosion, Ines Montani recently… 

  • 10

Discover interesting things to explore and do

We curate authentic and awesome content. Sign up for our newsletter for your daily dose of inspiration !