StacksGPT
Marketing & Content

YouTube Channel Strategist

Study what works in your YouTube niche, from video titles to thumbnails, and collect the insights in Google Sheets.

The Problem

Creators guess at titles and thumbnails. Researching what top channels in a niche do is slow, manual and quickly out of date.

How This Template Solves It

A creator or agency sets a broad niche, a specific niche and their own channel. On separate schedules the workflow scrapes niche videos through Apify, an AI agent pulls out the words that make titles clickable, a vision model explains why thumbnails get attention, and the findings go into Google Sheets.

How It Works

  1. 1Scheduled runs collect broad niche and specific niche insights, and a form lets you test individual channels.
  2. 2Apify scrapers fetch YouTube channel and video data.
  3. 3An AI agent analyzes video titles for the words and phrases that make them compelling.
  4. 4An OpenAI vision step analyzes thumbnails for what grabs attention.
  5. 5Results are sorted and saved to the author's Google Sheet template, with Slack available for updates.

What You Need

  • An Apify account
  • An OpenRouter API key, plus an OpenAI API key for image analysis
  • A copy of the author's Google Sheet template
  • A Slack workspace, optional

What Stays Under Your Control

  • You choose the niches and channels to study.
  • Content decisions stay with the creator.

Watch Out For

  • After copying the sheet, link every Google Sheets node to the correct tab.
  • Scraping volume drives Apify cost. Start with a narrow niche.

Adapted from a community workflow template. Before publishing we removed credentials, account and file IDs, email addresses and sample data. The original author's setup notes are kept inside the workflow file.

More Marketing & Content Templates

Marketing & Content

Create and Schedule Branded LinkedIn Posts

Research topics with Perplexity, write LinkedIn posts in your voice, generate a branded image and publish on a schedule.

Starts on: Schedule

Anthropic ClaudeGoogle DriveGoogle Sheets+1 more