I made an AI Agent that turn Reddit Rants into viral content that ranks on LLMs (on Autopilot)

Build an AI-powered workflow that scrapes Reddit, filters real user pain points, and turns them into content ideas your audience actually cares about.

Jun 16, 2025

Friends,

Earlier in my previous essay, I wrote about how LLMs source Reddit queries in their answers. So if you’re looking to rank on these LLMs, you need to use Reddit to find queries that people are asking for on Reddit and bring that solution in one place - either via a standalone Reddit post, on your blog or on your newsletter.

The point is Reddit is unbundled and people in your niche are continuously asking questions. You can use Ahrefs to do Keyword research and that’s okay but everyone is using Google Keyword research - in today’s newsletter, I’m gonna show you how to do Reddit Keyword Research.

Brought to you by:

Market Curve is a premium tech storytelling studio run by me Shounak that turns tech companies into media companies. I’ve had the fortune of working with some of the top tech companies backed by some of the top investors like YCombinator, 20VC who have gone on to be acquired by companies like Roblox & Amplitude.

Here are a few things I can help you with —

Design a custom content system that helps your brand show up on LLMs.
Optimize your entire buyer journey across your landing page, pricing page and onboarding flow so you can get more customers without spending more on customer acquisition costs.
Build custom AI agents for your marketing/GTM/content teams that are embedded deep into your tech stack and can function autonomously.
Take over your LinkedIn profile via my Service with a Software system which will help you get more followers & help grow your personal brand without breaking the bank.

Interested?

Let's talk

So Reddit Keyword research. Here’s how this works. I’ve made a (rather unpolished) Youtube video showing how this whole thing works so if you’re a video person, you can follow that step by step and build your own Reddit Keyword Research Tool in a few hours.

How does this work though?

So, imagine you have a startup in legal-tech, something like a case management software. (Clio for example). There are subreddits (like r/law or r/lawyertalk) where your customers are talking about stuff like “what Case management system is best to use”, or “What Case Management Software should I use if I run a personal injury firm” or “How do you fix this problem in XYZ Case Management Software” - you get the idea. There’s tons and tons of content ideas lying around in plain sight on Reddit, which customers are begging for answers to.

With this agent, you will be able to turn real community problems into content ideas using automation + AI

Reddit is full of real people venting real frustrations — and that’s gold for content marketers.

This tutorial walks you through building a no-code agent using n8n that scrapes Reddit for problems your customers are talking about, then uses AI to turn those into content ideas.

You’ll go from raw community chatter ➝ filtered insights ➝ content prompts ➝ a clean Google Sheet.

Here’s the video. Below is the step by step guide on how to do it. Let’s dive in.

Check out the YouTube

What You'll Need

A free n8n account (or self-hosted instance)
Reddit API credentials (for pulling subreddit data)
OpenAI API key (for classification + summarization)
Google account (to store outputs in Sheets)

Step 1: Trigger the Workflow

What it is:
A manual trigger that starts the workflow.

During testing or manual runs, this gives you control over when the agent activates. You can replace this later with a Slack command, Telegram message, or scheduled run.

Step 2: Search Reddit Posts

Node: Reddit → Search Posts
Inputs:

Resource: Post
Operation: Search
Location: Subreddit (e.g., lawyertalk, productmanagement)
Limit: 10–25
Sort by: Top

Using Top ensures we prioritize high-engagement posts (upvotes = signal).

This is how we pull real user posts from a subreddit. We want to listen in on discussions where people talk about pain points and needs — that’s where the content opportunities lie.

Step 3: Filter Useful Posts

Node: IF Condition
Conditions:

upvotes ≥ 2
selftext is not empty

This filters out noise:

Posts with no upvotes haven’t resonated
Posts without selftext don’t give us enough context (they may just be links or memes)

This ensures you're only analyzing actual discussions that others found useful.

Step 4: Clean the Output

Node: Edit Fields
Keep only:

selftext (the main body of the post)
(Optional: also keep title, upvotes, comments if relevant)

Reddit’s API gives you a ton of metadata (author name, flair, flair color, thumbnail URL, etc.) — most of which you don’t need. This step cleans up the output and keeps it lean for AI processing.

Step 5: Use AI to Detect Business Problems

Node: AI Agent (ChatGPT or GPT-4 via OpenAI)
Prompt:

Is this Reddit post describing a business-related problem or a need for a solution? Output only “Yes” or “No”.

Not every Reddit post is relevant to your business. Some are just casual questions or jokes. This step uses AI to intelligently decide which ones are actually describing business-relevant pain points.

Step 6: Merge the Post + AI Output

Node: Merge
Inputs:

Cleaned Reddit Post (selftext)
AI Output (Yes / No)

We now combine the original post with the AI's decision about whether it's a business-relevant problem. This way, we can filter further and retain full context for only the right ones.

Step 7: Filter Only “Yes” Results

🔧 Node: Filter
Condition:

AI Output = "Yes"

📌 Why it exists:
This is a second filter pass — we want to work only with Reddit posts that the AI validated as describing a real business challenge.

This makes sure we don’t waste resources summarizing or generating content for irrelevant posts.

Step 8: Summarize the Problems

Node: Summarization Chain
Config:

Input: The filtered Reddit post
Chunk size: 1000 characters
Output: Concise summary of the problem

Reddit posts can be long, emotional, or scattered. This step condenses each post into a short, clear summary that captures the user’s pain point.

Think of it as the AI’s version of, "Here’s what they’re really trying to say."

Step 9: Generate Content Ideas with AI

Node: OpenAI Chat Model
Prompt:

Based on the following Reddit post, suggest a content idea I can create to solve this problem for this business and others like it. Provide a concise content idea.

Now we turn pain into possibility.
For each summarized Reddit post, the AI generates a clear content idea — a guide, checklist, framework, or story you could create to solve that problem.

This is the payoff moment: turning insight into creative output.

Step 10: Send to Google Sheets

Node: Google Sheets → Append Row
Sheet Columns:

Problem (Summarized Reddit post)
Content Idea (Generated by AI)

Store everything in a spreadsheet for easy access, review, and collaboration. You can share it with your team, plug into a Notion CMS, or route into a content calendar workflow.

Bonus: Automate Content Writing

Once you have ideas, you can build a second n8n agent that:

Writes a blog post or LinkedIn post in your tone of voice
Sends drafts to Notion, Sheets WordPress
Notifies your content team on Slack

You now have a fully automated ideation → creation → publication pipeline.

This system helps you:

Create relevant content based on what people are already asking
Improve your SEO + show up in LLMs like ChatGPT & Perplexity
Save hours of research and brainstorming
Ship faster

Whether you're in SaaS, legal tech, fitness, or finance — just change the subreddit.

Want the entire workflow template? Just Send me a DM here or email me and I’ll send over the JSON file so you can directly upload it into n8n and start using it.

In the meantime, if you found this useful, share it with your friends and peers.

See you next week,

Shounak.