NodeJS: Use Google Sheet as Database

Let’s say you are in one of these scenarios:
- You need to prototype a dynamic web application or CMS, and you need your non-engineers to have the flexibility to edit your data set on the fly.
- You need to quickly create a dynamic dashboard for reporting, where you already have all the data in google sheets.
You definitely should consider using Google Sheet as the database, and quickly build an API or you can connect it directly to your React Native mobile app or React/Vue Web App.

For the sake of simplicity, I will just show you how to integrate Google Sheet with your NodeJS API, written using NestJS. You can find the full source code here: https://github.com/sofyan-ahmad/google_sheet_example

Google API Service

This service is used to manage google API credential and token

Read Google Sheet