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://blog.usejournal.com/how-to-use-google-sheets-as-a-cm...) but I've always wondered if there would really be a market for such a thing. There clearly is anyway for read-only Google Sheet generated sites.

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.

Nothing wrong with them at all! They're each filling a different niche. Very well done too. I'm considering some of them as backend, actually.

My niche happens to be to quickly create a single visually pleasing web page from a sheet.