Hello there! After struggling for too long without being able to get a proper Notion Page within an automation, I created an API to transform Markdown into a compatible JSON for Notion API to append content to a page.
You can find it here : Write2Notion
It will allow you to create beautiful Notion pages with Titles and subtitles, bold text, etc by sending a Markdown format text to it! Enjoy!