Automate content research with Reddit scraping, AI analysis, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs on a schedule (every day at 07:00). Along the way it connects Reddit, OpenAI Chat Model and Google Sheets.
How it runs
Trigger: On a schedule (every day at 07:00).
- r/smallbusiness/automation (Reddit): search
- r/smallbusiness/AI Automation (Reddit): search
- r/smallbusiness/automation (Reddit): search
- Merge: merges the data from its input branches
- Edit Fields (Edit Fields (Set)): sets 3 fields: subreddit, text, title
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Append row in sheet (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Reddit
n8n-nodes-base.reddit - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets
From the author
Workflow Summary This workflow automatically scrapes new Reddit posts from your chosen subreddits and keywords, analyzes them with AI to extract summaries, pain points, and content angles, and then saves the insights into a Google Sheet. It’s a fully…