Reddit Content Ideas & SEO Questions by Niche
Pull the top upvoted questions from any niche subreddit, mapped to content gaps and blog ideas your audience is actually asking about right now. For SEO teams.
How it works
- 1Open it on Apify
Hit Run on Apify — it opens the tool in the cloud, no install.
- 2Set the inputs
Adjust
sources,subreddits,users(sensible defaults are pre-filled). - 3Click Run
The tool runs on Apify’s cloud and collects the data for you.
- 4Export the results
Download as JSON, CSV or Excel, or pipe straight into your app, Google Sheets, or an AI agent.
Inputs
| Field | What it does | Type |
|---|---|---|
sources | Any mix of subreddits and Reddit user profiles. Accepts: 'askreddit', 'r/tifu', 'u/GallowBoob', 'user/spez', or a full reddit.com URL. Works for ANY subreddit o | array |
subreddits | Optional alternative to 'sources' — plain subreddit names. Merged with 'sources'. | array |
users | Optional — Reddit usernames to scrape submissions from (without u/). Merged with 'sources'. | array |
method | rss = no key/login needed (recommended, default). oauth = use Reddit app creds below (adds score/comments). json = legacy anonymous API (often blocked). | string |
sort | top, hot (trending), new (latest), rising, or controversial. | string |
time | Time window for 'top' and 'controversial' sorts (ignored for hot/new/rising). E.g. top of all time, top this year, top this week. | string |
maxPostsPerSubreddit | How many qualifying stories to return per subreddit. | integer |
minScore | Skip posts below this upvote count. | integer |
minWords | Skip stories shorter than this (too thin for a short). | integer |
maxWords | Skip stories longer than this (won't fit a 30–90s short). | integer |
minHookScore | Filter out weak openers. 0 = keep all. | integer |
requireStory | Keep only self/text-post stories (skip link/image posts) and apply the word-count fit. Off by default = return ALL posts. Turn on for faceless story videos. | boolean |
includeNsfw | Include posts marked over-18. Off by default. | boolean |
cleanText | Strip markdown/links/edit-stamps and produce TTS-ready sentences. Turn off for raw text. | boolean |
rawMode | Output the complete raw Reddit post object instead of the shaped record. | boolean |
dedupeAcrossRuns | Remember post IDs between runs so you never get the same story twice. | boolean |
commentLimit | Fetch up to this many top comments per post (0 = none). Reliable when you add Reddit app credentials below; anonymous Reddit usually blocks comment access. | integer |
redditClientId | Optional. The default RSS method needs no login. Add a free 'script' app's client ID (reddit.com/prefs/apps) only if you want upvote score + comment counts (not | string |
redditClientSecret | The secret for your Reddit app (reddit.com/prefs/apps). | string |
What you get
A structured dataset — each result includes fields like:
authorcreatedUtcfetchedAtfitsShortflairhookScoreidisStorynarrationnumCommentsover18postTypereadTimeSecondsscoreExport every run as JSON, CSV or Excel, or send it to your app, a database, Google Sheets, or an AI agent.
More use cases for Reddit Scraper
Reddit Q&A Dataset for LLM Fine-Tuning & RAG
Harvest upvoted question-and-answer threads from r/askscience, r/AskHistorians and ELI5, cleaned into a Reddit Q&A dataset for LLM fine-tuning and RAG.
Reddit Relationship Stories for Faceless Videos
Faceless video creators get top weekly r/relationship_advice, r/MaliciousCompliance and r/pettyrevenge stories, hook-scored and length-trimmed for scripts.
r/nosleep Horror Stories for Narration Channels
Top r/nosleep and short scary stories, hook-scored and length-filtered, ready for horror and creepypasta narration channels on YouTube and TikTok.
WSB Ticker Mentions & Sentiment Tracker
A daily feed of hot r/wallstreetbets, r/stocks and r/options posts and comments, surfacing the most-mentioned tickers and retail sentiment for traders.
Crypto Subreddit Coin Sentiment & Hype Tracker
Daily hot posts across r/CryptoCurrency, r/solana and r/ethfinance reveal coin mentions, sentiment shifts and early hype so you spot the move first.
Spot Emerging Trends Early in Niche Subreddits
Rising threads in fast-moving subs like r/LocalLLaMA and r/Biohackers, tracked daily so analysts and marketers catch emerging trends before mainstream search.