Reddit + Google Sheets: a ready backlog of ideas
You find a killer Reddit post, think “this is a real problem,” and then… it disappears into 12 open tabs, a half-finished Notion page, or a screenshot you’ll never search again.
Founders feel this when they’re hunting for the next product. Marketers hit it when they need messaging that mirrors real language. Consultants doing discovery calls run into the same mess. This Reddit idea backlog automation turns scattered threads into a searchable, sortable backlog inside Google Sheets.
Below, you’ll see how the workflow pulls top posts from multiple subreddits, summarizes the pain with Gemini, and logs everything so you can compare ideas fast (without losing the original context).
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Reddit + Google Sheets: a ready backlog of ideas
flowchart LR
subgraph sg0["When clicking ‘Execute workflow’ Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
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/>Search for a post"]
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Edit Fields", pos: "b", h: 48 }
n3@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
n4@{ icon: "mdi:brain", form: "rounded", label: "Google Gemini Chat Model", pos: "b", h: 48 }
n5@{ icon: "mdi:database", form: "rounded", label: "Append row in sheet", pos: "b", h: 48 }
n6["<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"]
n7["<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/>Search for a post1"]
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/reddit.svg' width='40' height='40' /></div><br/>Search for a post2"]
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/merge.svg' width='40' height='40' /></div><br/>Merge1"]
n6 --> n5
n9 --> n2
n3 --> n6
n2 --> n3
n2 --> n6
n1 --> n9
n7 --> n9
n8 --> n9
n4 -.-> n3
n0 --> n1
n0 --> n7
n0 --> n8
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 n0 trigger
class n3 ai
class n4 aiModel
class n5 database
classDef customIcon fill:none,stroke:none
class n1,n6,n7,n8,n9 customIcon
The Problem: Great ideas get lost (and you can’t compare them)
Reddit is a goldmine for unmet needs, but it’s a chaotic one. You’ll see “Why is there no tool that…” and feel the spark, then you open the thread, skim comments, and promise yourself you’ll come back later. Later rarely happens. Even when you do save posts, you end up with a pile of links and no structure: no quick summary, no clear target user, and no way to spot repeats across subreddits. After a week of “research,” you’ve mostly collected noise and mental clutter.
It adds up fast. Here’s where it breaks down in real life.
- You spend about 10 minutes per thread just extracting the actual problem, then you forget your conclusion a day later.
- Your notes don’t include the original title, upvotes, or URL, so you lose the proof that people cared.
- Patterns are hard to see when everything lives in tabs, bookmarks, and random docs.
- Manual logging invites sloppy fields and duplicates, which makes sorting and filtering basically useless.
The Solution: Reddit → Gemini analysis → Google Sheets backlog
This workflow gives you a repeatable “idea capture” system. You manually run it when you want fresh inputs, and n8n pulls top Reddit posts from multiple subreddits that match problem-signaling phrases like “I wish there was an app for…” or “someone should make…”. Those results get merged into one clean stream, then trimmed down to the fields you actually care about (title, the post text, upvotes, created date, and the URL). Next, an AI agent sends each post to Gemini 1.5 Flash and asks for a useful breakdown: what the core problem is, whether existing solutions already exist, a startup idea if there’s a gap, who the target user is, and a quick implementation outline. Finally, the workflow appends everything into a Google Sheet row, so your backlog builds itself.
It starts with a manual launch in n8n. Reddit searches run in parallel across three subreddit sources, then n8n unifies and maps the output. Gemini generates the insight text, and Google Sheets becomes your single place to review, filter, and decide what’s worth deeper validation.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you review 30 Reddit posts a week across a few subreddits. Manually, you might spend about 10 minutes per post to capture the title, paste the URL, skim selftext, and write a quick summary, which is roughly 5 hours. With this workflow, you run one manual trigger (about 1 minute), let n8n collect and merge posts, and Gemini writes the structured summary for each. You still review the sheet, of course, but the “copy, paste, rewrite, repeat” part drops to a quick scan.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Reddit API for searching and retrieving subreddit posts.
- Google Sheets to store your backlog in a spreadsheet.
- Google Gemini (PaLM) API key (get it from Google AI Studio / Google Cloud credentials).
Skill level: Intermediate. You’ll connect credentials and map a few fields, but you won’t be writing code.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You launch it manually. Open the workflow in n8n and click run when you want a fresh batch of idea inputs (daily, weekly, whenever).
Reddit searches run across multiple subreddits. The workflow queries three subreddit sources for top posts that match “problem” phrasing, then collects the results into a single stream you can work with.
The workflow cleans the data before AI touches it. n8n merges the results and maps only the fields that matter (title, selftext, ups, created, url) so your spreadsheet stays consistent.
Gemini generates a structured insight per post. An AI agent asks Gemini to explain the core pain, check for existing solutions, suggest a startup idea if needed, define the target user, and outline a basic implementation approach.
Everything is logged to Google Sheets. Each post becomes one new row, with the original context plus the AI output in an “output” column.
You can easily modify the subreddit list and the keyword phrases to match your niche, so you’re not stuck with generic “startup ideas.” See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Manual Trigger
This workflow starts manually so you can run idea discovery on demand.
- Add and open Manual Workflow Launch.
- Confirm it is a manual trigger (no fields required).
- Connect Manual Workflow Launch to Retrieve Reddit Posts A, Retrieve Reddit Posts B, and Retrieve Reddit Posts C.
Manual Workflow Launch outputs to both Retrieve Reddit Posts A, Retrieve Reddit Posts B, and Retrieve Reddit Posts C in parallel.
Step 2: Connect Reddit Searches
These nodes collect idea prompts from three subreddits using the same keyword.
- Open Retrieve Reddit Posts A and set Operation to
search, Keyword toWhy is there no tool that, Subreddit tocrazyideas, Limit to25, and Sort tocomments. - Open Retrieve Reddit Posts B and set Operation to
search, Keyword toWhy is there no tool that, Subreddit toLightbulb, Limit to25, and Sort tocomments. - Open Retrieve Reddit Posts C and set Operation to
search, Keyword toWhy is there no tool that, Subreddit tosidehustle, Limit to25, and Sort totop. - Credential Required: Connect your redditOAuth2Api credentials in Retrieve Reddit Posts A, Retrieve Reddit Posts B, and Retrieve Reddit Posts C.
Retrieve Reddit Posts A, Retrieve Reddit Posts B, and Retrieve Reddit Posts C all feed into Unify Search Results.
Step 3: Merge and Map Reddit Data
Combine the three result streams, then normalize fields for AI processing and logging.
- Open Unify Search Results and set Number Inputs to
3. - Open Map Entry Fields and add the following assignments:
- Set title to
={{ $json.title }}. - Set selftext to
={{ $json.selftext }}. - Set ups to
={{ $json.ups }}. - Set created to
={{ $json.created }}. - Set url to
={{ $json.url }}. - Connect Unify Search Results to Map Entry Fields.
Map Entry Fields outputs to both Insight Generation Agent and Combine Streams in parallel.
Step 4: Set Up AI Insight Generation
Use the AI agent to generate a startup idea analysis from each Reddit post.
- Open Insight Generation Agent and set Prompt Type to
define. - Set Text to the full prompt provided, including expressions like
{{ $json["title"] }},{{ $json["selftext"] }},{{ $json["ups"] }},{{ $json["url"] }}, and{{ $json.created }}. - Open Gemini Chat Model and set Model Name to
models/gemini-1.5-flash-8b-latest. - Credential Required: Connect your googlePalmApi credentials in Gemini Chat Model.
Gemini Chat Model is connected as the language model for Insight Generation Agent — ensure credentials are added to Gemini Chat Model, not the agent.
Step 5: Combine and Log to Google Sheets
Merge the raw mapped fields and AI insights, then append the result to a spreadsheet.
- Open Combine Streams and set Mode to
combineand Combine By tocombineByPosition. - Connect Map Entry Fields to Combine Streams (main input) and Insight Generation Agent to Combine Streams (secondary input).
- Open Append Sheet Row and set Operation to
append. - Select the target spreadsheet in Document ID and the target tab in Sheet Name.
- Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Sheet Row.
⚠️ Common Pitfall: Append Sheet Row has empty Document ID and Sheet Name by default. If these are not set, the workflow will fail when writing results.
Step 6: Test and Activate Your Workflow
Run a manual test to confirm data flows from Reddit to AI insights and into your spreadsheet.
- Click Execute Workflow to run Manual Workflow Launch.
- Verify that Unify Search Results outputs items and Map Entry Fields maps the expected fields.
- Check that Insight Generation Agent returns an AI analysis and Combine Streams merges both streams.
- Confirm a new row is appended by Append Sheet Row in your target sheet.
- Once verified, toggle the workflow to Active for production use.
Common Gotchas
- Reddit API credentials can expire or be blocked by missing scopes. If things break, check your Reddit app settings and the credential test inside n8n first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Gemini prompts default to bland, generic language. Add a short “how we write” style note in the AI Agent prompt early, or you will be rewriting summaries every run.
Frequently Asked Questions
About 30 minutes if your APIs are ready.
No. You’ll connect credentials and copy/paste a few values into nodes.
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 Gemini API usage costs, which are usually small for short summaries.
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.
Yes, and it’s the first thing you should do. Update the subreddit inputs in the “Retrieve Reddit Posts A/B/C” nodes, then tweak the keyword phrases they search for (the “why is there no tool…” style terms). If you want a different output format, adjust the prompt in the “Insight Generation Agent” so Gemini returns shorter ideas, stricter structure, or a score. You can also change the “Map Entry Fields” node to add extra columns like comment count or a tag for your market segment.
Usually it’s an expired Google token or the wrong Google account connected. Re-authenticate the Google Sheets credential in n8n, then confirm the spreadsheet and sheet tab still exist and match what the “Append Sheet Row” node expects. Also double-check your header order (title, selftext, ups, created, url, output), because mismatched columns can look like a connection issue when it’s really a mapping problem.
It can handle a lot, but the practical limit is your n8n plan and API rate limits. On n8n Cloud, your monthly execution cap depends on the plan; self-hosting removes that cap, but your server still needs enough memory and CPU. Reddit can throttle heavy scraping, so pulling a few dozen posts per run is usually smoother than trying to ingest thousands at once. If you need high volume, run it on a schedule and batch your subreddits.
For this use case, n8n is usually the better fit because it can merge multiple Reddit searches, keep logic flexible, and run self-hosted without charging you per tiny step. The AI agent setup is also easier to control when you want structured output (problem, existing solutions, target user, and so on). Zapier or Make can still work if you’re doing a very small version of this, like one subreddit and a single summary field. Once you start adding more sources, filtering, and richer prompts, the cost and complexity tend to creep up. If you’re unsure, Talk to an automation expert and get a recommendation based on volume.
A clean backlog changes how you decide. Run this once a week, skim the sheet, and keep moving with evidence instead of hunches.
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.
