I found the best setup using Obsidian to write the content for my website, which is by utilizing GitHub & submodules. Might sound complicated but it's quite simple, it is just another repository that stores all markdown content which is then added to the main repository as a "submodule".
(My website is built with Astro and uses markdown for all blog posts.)
Wrote about how to do this here: https://bryanhogan.com/blog/obsidian-astro-submodule
Bryan Hogan · How To Use Obsidian To Write Astro Markdown ContentHow to use Obsidian to write Astro markdown content in a simple and intuitive way using GitHub submodules.