Automate Content Research with Reddit Scraping, AI Analysis, and Google Sheets

Go to Workflow
0 views
Built by Michael Taleb Michael Taleb
Created on June 08, 2026

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 (5)

AI Agent
@n8n/n8n-nodes-langchain.agent
Google Sheets
n8n-nodes-base.googleSheets
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Reddit
n8n-nodes-base.reddit
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured