Transform Reddit Questions into SEO Blog Posts with OpenAI and Google Sheets

Description

Turn Reddit Questions into SEO Articles Automatically

This workflow takes real user questions from Reddit and transforms them into fully structured blog posts — title, intro, steps, and conclusion — using AI.

How it works

Manually triggered when you want to run it
Scrapes the latest posts from a specific subreddit (e.g. r/n8n)
Filters only posts that are real questions (based on keywords like “how,” “what,” “why”)
Logs relevant questions into a Google Sheet as raw input
Enhances each question using AI (rephrases, creates a clean title and slug)
Generates full-length blog content:
✏️ Intro paragraph
✅ Step-by-step guide
🧠 Clear conclusion
Saves the final blog content to a second Google Sheet for publishing

Set up steps

You’ll need access to:
Reddit API (OAuth)
OpenAI API
Google Sheets
Takes around 15–20 minutes to connect all the credentials and tweak prompts
Customize the subreddit or topic focus by changing the Reddit node config

Perfect for content teams who want to scale content output using real community pain points — without ever starting from a blank page.