What This Workflow Does
This automation solves a critical problem for entrepreneurs and innovators: finding validated startup ideas efficiently. Instead of manually browsing forums for hours, this workflow systematically scans Reddit for posts containing phrases like "I wish there was," "Why doesn't anyone make," or "Someone should create." It identifies genuine pain points people are discussing, then uses Google's Gemini AI to analyze each problem and suggest potential solutions.
The system transforms unstructured social media complaints into structured business opportunities. Each discovered problem gets evaluated for existing solutions, target audience, implementation complexity, and market potential. All insights are automatically organized in a Google Sheet, creating a searchable database of vetted startup concepts you can prioritize based on your expertise and resources.
This approach turns what was traditionally a time-consuming, hit-or-miss research process into a scalable, repeatable system. You're not just collecting random ideas—you're building a pipeline of market-validated opportunities with AI-powered analysis attached to each one.
How It Works
The workflow follows a logical five-step process that transforms Reddit discussions into actionable business insights.
1. Manual Trigger & Reddit Scraping
The workflow begins with a manual trigger, allowing you to run it on demand or schedule it for regular execution. It then queries multiple subreddits simultaneously, searching for posts containing specific keyword patterns that indicate unmet needs or frustrations. The system filters for high-engagement content to ensure you're seeing what actually matters to people.
2. Data Merging & Cleaning
Results from different subreddit queries are merged into a single dataset. The workflow extracts only the most relevant fields: post title, full text, upvote count, creation date, and URL. This cleaning step removes noise and ensures the AI receives focused, high-quality input for analysis.
3. AI Analysis with Gemini
Each qualifying post is sent to Google's Gemini 1.5 Flash model with a structured prompt that asks for: the core problem explained in business terms, whether existing solutions exist, a novel startup idea if none exist, the ideal target customer profile, and a high-level implementation overview. The AI provides consistent, structured analysis across all discovered problems.
4. Google Sheets Logging
The original Reddit data and AI-generated insights are appended as new rows in a pre-configured Google Sheet. This creates a living database of opportunities that you can sort, filter, and prioritize. The sheet includes columns for problem severity, market size estimates, and implementation difficulty scores.
5. Quality Control & Iteration
The workflow includes error handling for API limits and data validation to ensure only complete, usable records are saved. You can easily adjust search parameters, subreddits, and AI prompts based on what types of opportunities you're finding most valuable.
Who This Is For
This template is ideal for solo founders, startup studios, product managers, and innovation teams who need to systematically discover market opportunities. It's particularly valuable for:
Indie hackers and solopreneurs looking for their next project with built-in market validation. VC associates and angel investors scouting emerging trends and pain points. Corporate innovation teams monitoring adjacent markets for expansion opportunities. Digital agencies seeking client-relevant service offerings. Product managers researching feature gaps in competitive landscapes.
If you've ever spent hours browsing forums hoping to stumble upon a good idea, this automation replaces that randomness with a reliable, scalable process.
What You'll Need
- n8n instance (self-hosted version required for community nodes)
- Reddit API credentials (free developer access from Reddit)
- Google Gemini API key (available through Google AI Studio)
- Google Sheets access with API enabled in Google Cloud Console
- Google Cloud Service Account with Sheets API permissions
- A Google Sheet with columns: Title, Selftext, Ups, Created, URL, Output
Pro tip: Start with smaller, niche subreddits related to your expertise area. The signal-to-noise ratio is much higher in specialized communities compared to large general subreddits.
Quick Setup Guide
Follow these steps to get this automation running in your n8n environment:
- Download and import the JSON template into your n8n instance.
- Create your Google Sheet with the exact column structure: Title, Selftext, Ups, Created, URL, Output.
- Set up credentials in n8n for Reddit API, Google Gemini, and Google Sheets.
- Configure subreddits in the Reddit node—start with 2-3 relevant to your interests.
- Adjust search keywords to match problem-indicating phrases you want to track.
- Test with a manual trigger to verify all connections work properly.
- Schedule execution (daily or weekly) once testing is complete.
The workflow includes detailed instructions within each node. Pay special attention to the AI prompt configuration—this determines the quality and structure of the business analysis you'll receive.
Key Benefits
Save 10+ hours weekly on market research by automating what was previously manual browsing and note-taking. The system works while you sleep, continuously scanning for opportunities.
Discover validated problems, not just ideas. By focusing on actual complaints and wishlist items, you're building solutions for real pain points rather than hypothetical needs.
Scale your opportunity discovery across multiple niches simultaneously. One workflow can monitor dozens of subreddits across different industries, something impossible to do manually.
Create a searchable opportunity database that grows over time. Unlike scattered notes, all discoveries are organized in a structured format you can filter, sort, and analyze.
Leverage AI for consistent analysis that applies the same evaluation criteria to every opportunity, removing human bias and inconsistency from early-stage idea screening.