Sheets Stack - SERVER

Express JS routes to expose simplify interactions with Google Sheets. It provides two modules for different use cases.

See the full Documentation on Postman.

Modules

Lists DB

This module treats each column in a spreadsheet as a list. The first row is the list title and each subsequent cell is an entry.

Use Cases

• Flash cards
• Sight words

Basic DB

This module treats each column as a DB column with the first row being the header. Each subsequent row represents a database entry. While this module provides advanced pagination, sorting, and querying it runs in memory and is therefore more scalable for smaller datasets.

Usage

This library is available on NPM under @de44/sheets-stack-server.

// TODO: describe environment variables, logging, credentials, and running