📊 Automate content research with Reddit scraping, AI analysis, and Google Sheets
⚡ 3,655 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
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 automated Content Research Engine that delivers fresh marketing ideas and community pain points straight into your database.
Setting up the workflow
-
Connect Reddit • In n8n, create a Reddit credential. • Add the subreddits and keywords you want to track.
-
Connect Google Sheets • Make a copy of the database sheet. • Connect your Google account in n8n.
-
Connect OpenAI • Add your OpenAI API key as a credential. • The AI will summarize posts, extract pain points, and suggest content ideas.
-
Run the workflow • The workflow will search Reddit on a schedule. • Results are processed by AI and automatically added to your Google Sheet.
🔗 Nodes Used
Google Sheets, Reddit, Schedule Trigger, AI Agent, OpenAI Chat Model, Structured Output Parser
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File