// Case study

Monthly AI report for a YouTube channel

Once a month the system collects comments, AI finds the sentiment, viewers' questions and ideas for new videos, and the author gets a ready report by email.

ROLEDesign and development
TYPEAI LAB training project
YEAR2026
MAKE.COMAPIFYOPENAIGOOGLE SHEETSGMAIL
Monthly AI report for a YouTube channel

// Task

Hundreds of comments nobody reads systematically

Viewers ask questions and suggest topics for the next videos in the comments, but the author doesn't have time to read everything and draw conclusions.

// Solution

A ready report by email once a month

Apify collects the month's videos and their comments. AI reviews every comment: sentiment (positive, neutral, negative), viewer questions and topic suggestions, including indirect ones like "it would be great to see…".

The results go into a sheet per video, and the author gets a clean HTML email with a summary and recommendations. If the report could not be built, a separate notice is sent so nothing gets lost.

  • Videos and comments for the period via Apify
  • AI sentiment, questions and video ideas
  • A sheet broken down by video
  • HTML report by email and a failure notice

// Architecture

How it works

APIFYCollectvideos and comments for the month
OPENAIAnalysissentiment, questions, ideas
SHEETSSheetreport per video
GMAILEmailHTML report to the author

// Result

The outcome

Make scenario: monthly report
01 · Make scenario: monthly report

// Want the same?

Need regular reports?

YouTube, reviews, CRM or sales — describe what you want to see every month.

Telegram Send a request
Message on Telegram