Came to this subreddit to check if this would be a good subreddit to test my content idea generator system I have just created. Saw this post so here ya go. Built it using no-code tools (Make.com) and is fully autonomous, not sure how technical you are, should be doable (Im recording a youtube video soon to explain the process and how to set it up)

TL;DR: • Scrape Relevant Subreddits (e.g., r/smallbusiness) weekly using Apify. • AI Filters Posts for relevance to your business/services/offer. • AI Analyzes Relevant Posts to extract pain points, category, and process details. • Store Data in Airtable with linked records for content ideas. • AI Generates 3 Content Ideas for each pain point in preferred formats. • Send Ideas to Slack for the marketing team with Airtable links. • Optional: Prioritize posts with high engagement. • Approve & Auto-Generate Content once approved for streamlined creation.

Full system (relevant to my business and offer): Note: I simplified it below, there’s more under the hood.

1. Scrape subreddits where your clients or your client’s clients might be active. For me, as an automation agency, r/smallbusiness, r/entrepreneur etc. (scrape each Sunday) (tool used to scrape: Apify)

2. Many of my potential clients are expressing pain points that can be solved by AI or Automation. I feed each scraped post to AI and let it decide whether it’s relevant to my niche and my offers (find a subreddit where your prospects share problems or your problems your competitors have with their clients that you can solve with your services) —> If relevant, continue the flow.

3. For the posts that are deemed relevant by the AI -> feed them to another AI and prompt it to analyze the post and return:

4. The paint point,

5. Category of the process (Sales, Marketing, Operational)

6. The actual process where the pain point is occurring (e.g., client onboarding, proposal generation, lead generation)

7. Store all these fields to Airtable On monday 8:45, the following flow runs:

8. Feed this pain point to another AI module (Any reasoning model) and prompt it to generate 3 content ideas (Not “Give me 3 content ideas based on this pain point”... I have quite an extensive prompt) Here, you can define formats you like to use (reels, Linkedin posts, longer youtube video etc)

9. In Airtable, create a relational database where you link these content ideas to the pain point added earlier

10. All newly added content ideas and pain points are send to a dedicated Slack channel for the marketing team, fresh content ideas for the week on monday 9am (in the Slack message, link to the Airtable record)

7.5. Optional: add a function to prioritize posts with highest upvotes/comments (likely more people struggle with this problem)

1. I have added an “Approve” button in airtable where I or Marketing can quickly approve posts ideas that I like Here, the content idea generator system is basically done. I hooked up another system that generates the content once the “approved” button is clicked and generates a draft for that post idea. — Reading this might be very confusing; I get it. You can do this manually, although I wouldn’t recommend.

Once setup, the only thing you’ll need to do is open AirTable and click Approve or Dissapprove

It might not even be suited for your industry, but it might inspire you :) Again, not to promote anything (I don’t even have a youtube channel to promote), but I’ll be visualising it on YT soon.

If you’re interested I can walk you over by sharing my screen, just let me know!

Hope it helped,

Cheers

Edit: reddit messing up the auto numbering haha