Turn YouTube comments into weekly video topic ideas

Each week, AI reads your video comments and emails you five ready-to-use video topic ideas.

How the work actually flows

A straight line.

Pattern: Sequence (1)

flowchart TD trig(["weekly scheduled run"]):::trigtime s0["fetch videos and comments"]:::task s1[("save comments to spreadsheet")]:::store s2["analyze comments for themes"]:::svc s3["email top five topics"]:::task trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"weekly email with five video ideas"/]:::out pay{{"content ideas grounded in viewer feedback"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
AI Agents & Autonomous SystemsSEO & Search OptimizationEmail AutomationSpreadsheet & Database Ops
Connects
YouTubeGoogle SheetsGmailOpenAI

The problem it solves

You know your audience is telling you what they want in the comments, but reading through hundreds of them takes forever. Without a clear process, good video ideas get buried and you end up guessing what to make next.

Who it fits

YouTube creators and social media managers who want content ideas based on real audience feedback.

How it works

  1. Every week, the automation starts on a schedule
  2. It fetches your latest YouTube videos and comments
  3. It saves all comments to Google Sheets as a backup
  4. OpenAI reviews the comments to find recurring themes and requests
  5. It emails you the top five suggested video topics
What you get

Video ideas worth filming next

You get five suggested video topics each week, pulled straight from the comments and requests your audience already left you.

What you get

A weekly email listing five suggested video topics based on real viewer comments.

What you need

A YouTube channel, a Google Sheets account, a Gmail account, and an OpenAI API key.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Auto-upload videos to YouTube with AI-written titles and tags

Takes a raw video file and uploads it to YouTube with an AI-optimized title, description, and tags.

Advanced

Turn podcast episodes into ready-to-post TikTok and Instagram clips

Watches your podcast feed and turns each episode into short clips with captions, ready for TikTok and Instagram.

Advanced

Get an AI sentiment summary of your YouTube comments by email

Add a video to a spreadsheet and receive an emailed summary of what viewers are saying in the comments.

Advanced

Turn YouTube comments into an AI-written sentiment report by email

Analyzes the comments on your YouTube video with AI and emails you a report on sentiment, themes, and viewer questions.

Advanced
Back to the AI Playbook