Templates / Transform Reddit questions into SEO blog posts with OpenAI and Google Sheets

Transform Reddit questions into SEO blog posts with OpenAI and Google Sheets

Needs changes

by Abrar Sami ✓ · 9,999 views · created 2025-07-10 · Content Creation, Multimodal AI

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What to replace before upgrading

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
AI Agent (v1.9), Intro (v1.9), Steps (v1.9), Conclusion (v1.9), slug (v1.9)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (9)

RedditGoogle SheetsAI AgentOpenAI Chat ModelSimple Memory

What it does

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.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.