I very love Publii, the developpers knows the web, but:
it is not easy/impossible to automate to inject content in their SQLite
they are kind of in their world where you need to cut and past the last process
Before GDPR and Publii; I had a flow before that was obsidian to Hugo, then I switch to Obsidian which push to Notion to -> NextJS with (
https://github.com/transitive-bullshit/nextjs-notion-starter-kit)
But since GDPR; I always come back to Publii since, most of my user/customer are low publisher and care more about being compliant and secure.
I sync it with Google Drive (
NextCloud and SyncThing were awful with it.
Publii delete and recreate the whole preview and output directory for every preview).
to answer your question
Publii is not a CMS, so no I would not recommend it for that case.
I would prefer you tell me to use AirTable or Notion as CMS than Publii.
- but for a in between target Ghost or WordPress might be a great.