Transform Reddit Questions into SEO Blog Posts with OpenAI & Sheets

This n8n workflow automates turning real user questions from Reddit into high-quality, SEO-friendly blog posts. Manually triggered, it scrapes the latest posts from a specified subreddit (e.g., r/n8n), filters for genuine questions using keywords like 'how', 'what', or 'why', and logs them into a Google Sheet as raw input.

Next, OpenAI enhances each question by rephrasing it, creating a compelling title and slug. It then generates full-length content including an engaging intro paragraph, step-by-step guide, and clear conclusion, tailored for SEO and reader value.

The final structured blog post is saved to a second Google Sheet, ready for publishing on your CMS. Benefits include scaling content from community pain points, saving hours of research and writing, and ensuring posts resonate with audiences. Ideal for content teams, marketers, or solopreneurs in SaaS, tech, or any niche with active Reddit communities.

Setup requires Reddit OAuth, OpenAI API, and Google Sheets credentials—takes 15-20 minutes. Customize subreddit or prompts for any topic.