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