Loglists

LogLists: tinkering around with a simpler JavaScript framework called Alpine.js, I found a way to fetch data from a Google Sheets spreadsheet:

Motivation

Loglists comes from a wish to show small bits of information from my Google Sheets spreadsheets, without having to re-copy the data onto somewhere else!

In order to update the website, I would only need to update the cloud-based spreadsheet!

Features

• pulls data from Google Sheets worksheets
  • this will make one large tab-separated values (.TSV) file
  • the code will then parse the TSV file
  • dynamic features written with Alpine.js then...
• allows the user to view the data from a webpage
  • allow sorting and searching of data (especially long lists)
• allows the user to look through many different datasets
• gathers the different worksheets into a library of datasets (i.e. a "list of lists")

Frameworks

• front-end:
  • alpine.js
  • bootstrap
• "CMS":
  • Google Sheets (!)

Demo

• "website" on loglists.joncoded.com
  • also mirrored on loglists.vercel.app

Code

• on GitHub
  • the setup takes a while but once it works, it WORKS!