Got the same issue. Found those static site generators somewhat unwieldy to handle, especially for non-tech people. I worked on two different approaches:

* A desktop app for creating static blogs, local preview, generates assets, optional deploy directly to Vercel. [1]

* A cron job which reads the paragraphs of a Notion page. Currently only generates an Atom/RSS feed from each paragraph. Inspired by [2], currently no source available.

[1] https://www.project-daily.com

[2] https://brandur.org/atoms