Daily subreddit research into WordPress blog drafts

I want an agent workflow that mines my customers' subreddits every morning and stages FAQ-style blog post drafts in WordPress so my editor can review and publish them. The goal is to write about what people are actually asking, in their own words, because Reddit threads consistently appear in Google's discussions panel and rank well for question-style queries.

Trigger: cron, every weekday (Monday through Friday) at 7am in my local timezone.

Inputs I want to configure:

1) A list of subreddit names to mine (e.g. r/Entrepreneur, r/SmallBusiness, plus my own niche communities). Treat this as a simple editable list.

2) The maximum number of drafts to create per run (default 1 to 3).

3) The WordPress category or tag to apply to every draft (optional).

Reddit data comes from the XPOZ integration. Per run, for each subreddit in my list:

a) Use XPOZ "Get Subreddit with Posts" to pull the top posts from the last day. Rank by upvotes and comment count to find the highest-signal threads.

b) For the top handful of threads across all subreddits, use XPOZ "Get Reddit Post with Comments by ID" to pull the full comment tree. This is where the actual questions and pain points live, not just the headline.

Then the agent should cluster everything it has read into one to three recurring themes (a real recurring question or pain point, not a single one-off post). If nothing clusters cleanly, skip the run with a short note in the workflow log explaining what it saw.

For each theme, draft a full FAQ-style blog post with this structure:

- Title: the question framed clearly and naturally, the way a human would type it into Google.

- Body in scannable HTML with H2 sections covering: (1) Context, why this comes up and who is asking; (2) The answer, direct and practical; (3) A worked example or concrete scenario.

- A final "Research notes" H2 block listing the source Reddit thread URLs used, so my editor can click through and verify quotes before publishing.

Save each post in WordPress using "Create a Post" with status set to draft, the question as the title, and the WordPress category or tag from my config (if set). Never publish directly.

At the end of each run, log a one-line summary: which subreddits were scanned, how many threads were read, how many drafts were created, and the WordPress draft URLs. If the run was skipped, log why.

Additional information

What does this prompt do?

Pulls the top conversations of the day from the subreddits where your customers and prospects hang out
Reads the highest-signal threads in full so the recurring questions and pain points get heard, not just headlines
Clusters what people are saying into one to three blog topics and drafts an FAQ-style post for each, with a clear question as the title and scannable sections covering context, the answer, and a worked example
Stages every post in WordPress as a draft with the source Reddit threads attached as research notes, so your editor can verify quotes before publishing

What do I need to use this?

A WordPress site you can publish to (self-hosted or a WordPress.com plan that allows editor access)
An XPOZ account, which is how we pull Reddit posts and comments without managing Reddit credentials
The list of subreddits your customers actually read (a mix of broad and niche works best)

How can I customize it?

Change the schedule, the timezone, or which weekdays it runs
Swap the subreddit list as your audience shifts, or run a separate list per product line
Tune the output: how many drafts per day, the section structure, tone, target length, and which WordPress category or tag the drafts land under

Frequently asked questions

Do I need a Reddit developer account to use this?

No. Reddit data comes in through XPOZ, which gives you a single login that covers Reddit search, post retrieval, and comments without managing Reddit credentials.

Will the posts publish automatically?

No. Every post lands in WordPress with the status set to draft, so your editor can review, edit, and decide what to publish.

How does it decide which threads to read?

Each morning it pulls the top posts of the previous day from your subreddit list, then reads the full comment tree on the highest-signal threads, because that is where the real questions and pain points show up.

Can I run this for more than one product line or audience?

Yes. Configure a separate subreddit list per product or persona and run the workflow once per group, or have it tag the drafts with the matching category so your editors can filter.

What happens on quiet days when nothing interesting is being discussed?

The agent only creates drafts when conversations cluster into clear themes. On quiet days it can skip silently or leave a short note in WordPress explaining what it saw, your choice.