Earlier quoted context omitted.
What's wrong with the existing solutions: https://sheetsu.com https://sheety.co https://www.sheet2site.com https://steinhq.com https://www.glideapps.com
There's lots of platforms in that space and yet I am surprised that pretty much all of them are "read-only". I have yet to see one that allows writing to the sheet so users browsing the generated site can submit their own content or even use like counters or other dynamic functions that would update in the sheet. I wrote an article about how to set up a platform like those mentioned + with write functionality ( https…
I think with the exception of Sheet2Site (and SheetUI, of course), the aforementioned platforms do provide write to sheet as well. Judging by the fact that they've been around for a while, I believe there is a market for platform with write functionality.
Your article is pretty well written! More people should look to using sheets before hand-rolling a heavy weight solution.