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.