The spreadsheet not being normalized is a bit annoying, but I could fix that if I really wanted to. All in all, I actually find using Google as a data source like this works pretty well.
What add-on are you using to do that? I've been playing around using Lovely Table and Awesome Table for this purpose but not really sure which one I ultimately want.
The site is built with Gatsby using gatsby-source-google-sheets. The source is here: https://github.com/city41/fgbg (warning, it's pretty terrible. I built this thing very rapidly as at its heart it's really just an experiment).
The spreadsheet not being normalized is a bit annoying, but I could fix that if I really wanted to. All in all, I actually find using Google as a data source like this works pretty well.