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

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.