Built an end-to-end blog automation workflow in n8n that removes manual content production from the publishing pipeline. Topics are queued in a Google Sheet; the workflow picks them up on a schedule, generates long-form, SEO- and GEO-optimized blog content via AI, and structures it into complete articles — including FAQs, internal and external links, keyword sections, a glossary, a summary, and a call to action.
Three blog posts are generated and assembled automatically each week, converted into properly formatted .mdx files, and pushed to GitHub as a pull request with a live preview link. Reviewing and publishing is reduced to a single step: check the preview, and merge if it looks good — the post deploys automatically from there.