Automated Blog Generation and Publishing Workflow

This comprehensive n8n workflow automates the entire process of creating, formatting, and publishing a blog post based on a specific topic. It begins with scheduling or manual trigger, retrieves a topic from a Google Sheet, searches the web for relevant information using Tavily, and then uses an AI language model (Gemini) to generate a detailed Markdown-formatted blog post. The content is then prepared and committed directly to a GitHub repository, which is connected to a Jekyll static site hosted on GitHub Pages. The process concludes with updating the Google Sheet to mark the topic as ‘done,’ ensuring seamless automation from ideation to publication. This setup is ideal for content creators, bloggers, or technical teams looking to streamline content production and maintain an up-to-date blog automatically.