Weekly Reddit pain-point miner to Notion content backlog

Build me a weekly Reddit pain-point miner that fills our content backlog in Notion. The trigger is a cron that runs every Monday at 8am in my local timezone.

On each run, work through a configured list of audience subreddits (the communities where our customers hang out, default to about five). For each subreddit, use the Reddit Retrieve Posts from Subreddit operation sorted by top with the time filter set to week, and pull roughly ten posts. For the most upvoted handful of those posts, also call Retrieve Post Comments to capture how the community is actually phrasing the problem. Stay under Reddit's 100 requests per minute rate limit.

Use AI to cluster everything into 5 to 8 recurring themes: questions people keep asking, frustrations, is-there-a-tool-that-does-X requests, and comparisons. For each theme, draft a content idea card containing a working blog title, the underlying pain in the audience's own words (a short quote is fine), 2 or 3 supporting Reddit permalinks, a suggested target keyword, and a recommended format such as blog post, video, or comparison page.

Write each idea as a new entry in our Notion Content Backlog database using Create a Page. Map the working title to the page title and fill properties for theme, urgency, and source subreddits. Put the pain quote, supporting Reddit links, target keyword, and recommended format into the page body so a writer can pick it up and run with it.

Configurable inputs I want to be able to edit later: the list of subreddits, the post limit per subreddit, the time filter, the number of themes, and the Notion database ID. Skip themes the agent has already filed in the last 30 days so we don't get duplicates week over week.

Additional information

What does this prompt do?

Pulls the top weekly posts from a configured list of audience subreddits and reads the comment threads on the most engaged ones.
Clusters everything into 5 to 8 recurring themes: questions people keep asking, frustrations, tool-request posts, and comparisons.
Drafts a content idea card for each theme with a working title, the pain in the audience's own words, supporting Reddit links, a target keyword, and a recommended format.
Writes every idea as a new page in your Notion Content Backlog database with theme, urgency, and source-subreddit properties already filled in.

What do I need to use this?

A Reddit account connected to General Input with read access (the identity and read scopes).
A Notion internal integration token, with your Content Backlog database shared with the integration.
A short list of subreddits where your customers actually hang out (5 is the sweet spot).
A Notion database to act as the Content Backlog, with properties for theme, urgency, and source subreddits.

How can I customize it?

Swap the subreddit list, change the post limit per subreddit, or adjust the time filter (week, month, year).
Tune the clustering prompt: ask for more themes, fewer themes, or only specific shapes like comparisons or tool requests.
Change the Notion property mapping if your backlog uses different fields, or add extras like priority, owner, or recommended channel.

Frequently asked questions

Why pull from Reddit instead of using a paid tool like GummySearch?

You already pay for Reddit access through OAuth, and you control exactly which subreddits to mine and how the themes are shaped. The output lands in the same Notion database your content team already lives in, so there is no second tool to check.

Why a weekly cron instead of polling for new posts?

Top-of-week sorting only makes sense once a week's worth of upvotes have accumulated. Polling would give you raw firehose noise; the weekly run gives you the curated highlights your audience actually engaged with.

How does it stay under Reddit's rate limit?

The default config caps at five subreddits and roughly ten posts per subreddit, with comment fetches only on the most upvoted handful. That keeps the run well under Reddit's 100 requests per minute cap.

What goes into each Notion page?

A working blog title, the underlying pain quoted from the community, two or three supporting Reddit permalinks, a suggested target keyword, a recommended format like blog post or comparison page, plus structured properties for theme, urgency, and source subreddits.

Can I review the ideas before they hit my backlog?

Yes. Point the workflow at a triage database first, or add a Status property that defaults to Needs Review so the content team can approve before anything moves into the active backlog.