Reddit to Microsoft Excel, MVP ideas you can sort
Copying Reddit links into a doc feels productive, until you try to turn that chaos into actual MVP options. You end up with repeats, half-baked notes, and “great idea, where did I see that?” moments.
This is where Reddit Excel automation pays off. Marketing managers hunting positioning angles feel it. Startup founders validating pain points feel it too. And consultants building research deliverables for clients get stuck in the same grind.
This workflow pulls trending Reddit posts and comments, extracts the real pain points, has AI generate structured MVP ideas, and drops everything into Microsoft Excel 365 so you can sort, score, and decide.
How This Automation Works
See how this solves the problem:
n8n Workflow Template: Reddit to Microsoft Excel, MVP ideas you can sort
flowchart LR
subgraph sg0["Select a subreddit Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/reddit.svg' width='40' height='40' /></div><br/>Get Comments"]
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/reddit.svg' width='40' height='40' /></div><br/>Get Trending Posts"]
n2@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Chat Model", pos: "b", h: 48 }
n3@{ icon: "mdi:robot", form: "rounded", label: "Structured Output Parser", pos: "b", h: 48 }
n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>Select a subreddit"]
n5@{ icon: "mdi:cog", form: "rounded", label: "Get used reddit post slugs", pos: "b", h: 48 }
n6@{ icon: "mdi:cog", form: "rounded", label: "Flatten list of slugs", pos: "b", h: 48 }
n7@{ icon: "mdi:cog", form: "rounded", label: "Extract subreddits and post ..", pos: "b", h: 48 }
n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Create post slugs"]
n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Create list of posts"]
n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge used post slugs with n.."]
n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Create list of all post slugs"]
n12@{ icon: "mdi:cog", form: "rounded", label: "Remove duplicate post slugs", pos: "b", h: 48 }
n13@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split out post slugs", pos: "b", h: 48 }
n14@{ icon: "mdi:cog", form: "rounded", label: "Update 'Used Posts' with new..", pos: "b", h: 48 }
n15["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge new post slugs with po.."]
n16["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Filter out used posts"]
n17@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop over posts", pos: "b", h: 48 }
n18["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge post with comments"]
n19["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Flatten post and comments"]
n20@{ icon: "mdi:robot", form: "rounded", label: "AI powered MVP Generator", pos: "b", h: 48 }
n21@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split llm output prep for sp..", pos: "b", h: 48 }
n22@{ icon: "mdi:cog", form: "rounded", label: "Append new row to Excel sheet", pos: "b", h: 48 }
n0 --> n18
n17 --> n20
n17 --> n0
n17 --> n18
n8 --> n10
n1 --> n7
n1 --> n9
n4 --> n5
n4 --> n1
n9 --> n15
n13 --> n14
n16 --> n17
n6 --> n10
n2 -.-> n20
n20 --> n21
n18 --> n19
n3 -.-> n20
n19 --> n17
n5 --> n6
n12 --> n15
n12 --> n13
n11 --> n12
n7 --> n8
n15 --> n16
n21 --> n22
n10 --> n11
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n4 trigger
class n3,n20 ai
class n2 aiModel
class n8,n9,n11,n16,n19 code
classDef customIcon fill:none,stroke:none
class n0,n1,n4,n8,n9,n10,n11,n15,n16,n18,n19 customIcon
The Challenge: Turning Reddit noise into sortable MVP ideas
Reddit is full of gold, but it’s buried under messy threads, hot takes, and context you forget the next day. You might find three great pain points in r/smallbusiness, then lose 30 minutes trying to retrace your steps and capture the comments that made the post “click.” Even when you do save it, the notes are inconsistent, which makes comparing ideas honestly impossible. And if you revisit the same subreddit next week, you’ll often analyze the same post again without realizing it.
It adds up fast. Here’s where it breaks down in real life.
- Comment threads are where the pain is, but pulling them out manually is slow and easy to mess up.
- Your “idea backlog” ends up as links and fragments, so you can’t rank ideas by startup cost, revenue potential, or industry.
- Duplicates sneak in every week because trending posts get re-shared and you don’t keep a reliable blocklist.
- By the time you format everything into a spreadsheet, the momentum is gone and the research goes stale.
The Fix: Reddit pain points → structured MVP rows in Excel
This n8n workflow turns Reddit discovery into a repeatable system. You start by choosing a target subreddit from a simple intake form, not by editing nodes or rewriting queries. The workflow pulls top trending posts, then fetches the comment threads and flattens them into clean text that an AI model can actually analyze. Next, an AI “MVP builder” generates structured idea outputs (as JSON) with fields like industry, business type, pain point, startup cost estimate, and revenue potential. Finally, each idea is appended to a Microsoft Excel 365 sheet in consistent columns, ready for sorting and review.
The workflow starts with a form trigger and Reddit data collection. From there, it deduplicates posts using a “used slugs” list stored in Excel, then processes posts in batches so it doesn’t fall over on big threads. The last mile is simple: one row per MVP idea, added directly into your sheet.
What Changes: Before vs. After
| What This Eliminates | Impact You’ll See |
|---|---|
|
|
Real-World Impact
Say you review 15 trending posts in a subreddit and you usually spend about 10 minutes per post to skim, open comments, capture notes, and paste into a spreadsheet. That’s roughly 2.5 hours, and the formatting still isn’t consistent. With this workflow, you spend about 5 minutes picking the subreddit and checking the output columns, then let it run while you do other work. Even if the AI processing takes a bit, your hands-on time drops to minutes, not an afternoon.
Requirements
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Reddit developer credentials to fetch posts and comments.
- OpenRouter API key to run the AI idea generator.
- Microsoft Excel 365 to store and deduplicate results.
Skill level: Intermediate. You will connect accounts, paste API keys, and confirm your Excel table columns match the workflow.
Need help implementing this? Talk to an automation expert (free 15-minute consultation).
The Workflow Flow
You choose the subreddit. A built-in form trigger collects your selection so you can switch from r/entrepreneur to r/marketing without touching the workflow logic.
Reddit content gets collected and cleaned. The workflow pulls trending posts, fetches comment threads for each post, and flattens everything into plain text so the next step is analyzing the full context, not just the headline.
Duplicates get filtered before AI runs. It loads a list of previously used post slugs from Excel, combines old and new slugs, then removes duplicates so you’re not paying for AI analysis on the same post twice.
AI generates structured MVP ideas. The OpenRouter chat model and a structured output parser produce consistent fields (industry, business type, pain point, startup costs, revenue potential), then split those results into rows.
Excel becomes your backlog. Each MVP idea is appended to Microsoft Excel 365, and the “used posts” sheet gets updated so next run stays clean.
You can easily modify the subreddit list and the output columns to match how you score ideas (ICE, RICE, MoSCoW, simple “gut feel,” whatever works). See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Form Trigger
This workflow starts when a user submits the intake form and then branches into subreddit scraping and slug history lookup.
- Add and open Subreddit Intake Form to configure your form fields for subreddit input.
- Confirm the form webhook is generated and accessible so the workflow can be triggered by submissions.
- Note that Subreddit Intake Form outputs to both Fetch Used Post Slugs and Retrieve Trending Posts in parallel.
- Keep Flowpast Branding as an optional sticky note for documentation and team context.
Step 2: Connect Reddit
Reddit data is pulled from both trending posts and comment threads to build the idea pipeline.
- Open Retrieve Trending Posts and connect your Reddit account.
- Open Fetch Comment Threads and connect the same Reddit account for comment retrieval.
- Ensure Retrieve Trending Posts outputs to both Extract Subreddit IDs and Build Post List in parallel.
Step 3: Set Up Slug Processing and Filtering
This section creates and deduplicates post slugs, merges them with post data, and filters out previously used ideas.
- Configure Fetch Used Post Slugs to read your historical slug list from Microsoft Excel.
- Verify Fetch Used Post Slugs flows into Condense Slug List, then into Combine Old/New Slugs.
- Ensure Extract Subreddit IDs feeds Generate Post Slugs, and Generate Post Slugs outputs to Combine Old/New Slugs.
- Confirm Combine Old/New Slugs outputs to Assemble All Slugs, which then sends into Remove Duplicate Slugs.
- Note that Remove Duplicate Slugs outputs to both Merge Slugs With Post Data and Split Post Slugs in parallel.
- Confirm Merge Slugs With Post Data passes into Filter Used Posts, then into Iterate Posts Batch.
Step 4: Set Up the AI Processing Chain
Posts and comments are combined and passed into the LLM chain to generate structured idea outputs.
- Confirm Iterate Posts Batch outputs to Fetch Comment Threads and Combine Post With Comments as shown in the flow.
- Verify Fetch Comment Threads connects to Combine Post With Comments, and then to Flatten Post & Comments.
- Ensure Flatten Post & Comments outputs to Iterate Posts Batch for batching continuity.
- Open AI MVP Builder and confirm that it uses OpenRouter Chat Engine as the language model and Structured Result Parser as the output parser.
Step 5: Configure Output to Excel
The workflow writes both used slugs and AI-generated idea rows back to Microsoft Excel.
- Confirm Split Post Slugs outputs to Update Used Posts Sheet to log newly used slugs.
- Verify AI MVP Builder outputs to Split LLM Output Rows, which then outputs to Append Row to Excel.
- Configure Update Used Posts Sheet to write to your slug history table.
- Configure Append Row to Excel to append each generated idea row to your output table.
Step 6: Test and Activate Your Workflow
Run a controlled test to validate data flow, AI output, and Excel updates before enabling production runs.
- Click Execute Workflow and submit a sample entry through Subreddit Intake Form.
- Watch for successful parallel execution from Subreddit Intake Form into Fetch Used Post Slugs and Retrieve Trending Posts.
- Confirm that rows are appended in Append Row to Excel and slug history updates in Update Used Posts Sheet.
- Once verified, toggle the workflow to Active for production use.
Watch Out For
- Microsoft Excel 365 credentials can expire or need specific permissions. If things break, check the connection in n8n’s Credentials panel and confirm your workbook/table still exists.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Common Questions
About an hour if your Reddit and Excel credentials are ready.
Yes, but you will need someone comfortable with API keys and account permissions. Once it’s connected, running it is just picking a subreddit and reviewing the Excel rows.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenRouter API usage, which is usually a few cents per run depending on the model and how many posts you analyze.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
You can adjust the subreddit intake form to include your own curated list, then tune the AI MVP Builder prompt to match how you like to evaluate ideas (for example: B2B only, budget under $5k, or “must be sellable to agencies”). If you prefer a different model provider, swap the OpenRouter chat engine for another chat model node and keep the Structured Result Parser the same. Common customizations include adding a “score” column, tagging ideas by persona, and storing the raw Reddit URL alongside the MVP row for quick review.
Usually it’s expired OAuth permissions or the workbook/table changed. Reconnect the Microsoft Excel 365 credential in n8n, then confirm the target worksheet and table name still match what the “Append Row to Excel” node expects. If it fails only on some runs, check for column mismatches caused by empty AI fields, because Excel tables are picky about required columns.
On a typical n8n Cloud starter plan you can run plenty of weekly research jobs, and higher plans handle larger volumes. If you self-host, there’s no execution limit, but you’re limited by your server and API rate limits. Practically, most people process a few dozen posts per run, in batches, to keep costs and review time sane. If you try to analyze hundreds of posts at once, the AI spend and runtime can jump fast. The workflow is built with batching and deduping, so scaling up is more about budget and how many ideas you can realistically review.
Often, yes. This workflow relies on batching, deduplication, and structured AI outputs, which is where n8n tends to feel less cramped and less expensive at scale. Zapier or Make can work if you only want “new Reddit post → send me a message,” but turning threads into structured MVP rows is a more complex chain. n8n also gives you a self-hosting option, which matters when you’re running idea mining frequently. If you’re unsure, Talk to an automation expert and map it to your volume and goals.
Once this is running, your “idea research” stops being a messy activity and becomes an asset you can sort and reuse. The workflow handles the repetitive work so you can focus on picking the few MVPs actually worth building.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
