YoutubeAssistant

🥈Silver

Transform YouTube research into actionable insights with Google Sheets - Free YouTube analytics tool for content creators and marketers

500Updated 2mo ago

Intermediate30min to implementmarketing

Saves ~45 min per use

Quick InstallView Source

git clone https://github.com/clairechung/YoutubeAssistant.git

Works with:

Claude

Overview

About This Skill

YouTube Assistant is a free analytics tool that transforms YouTube video data into actionable insights within Google Sheets. It fetches 20+ metrics including views, engagement rates, performance scores, and hashtag analysis without requiring expensive third-party platforms. The tool categorizes content by type (Shorts, mid-form, long-form), calculates engagement patterns, and identifies top-performing videos. Content creators and marketers use it to discover winning topics, analyze competitors, optimize upload timing, and track trending hashtags. Setup takes three steps: create a Google Sheet, get a free YouTube API key, and configure it through the built-in menu.

How to Use

Create a new Google Sheet, add the YouTube Assistant code via Extensions > Apps Script, then obtain a free YouTube API key from Google Cloud Console. Configure your API key through the YouTube Assistant menu, enter a search term and result count, then click 'Fetch YouTube Data' to populate your analytics sheet.

Use Cases

Analyze competitor YouTube content strategy and identify successful formats

Research high-performing videos and hashtags in your niche

Discover content gaps and underrepresented topics in your category

Determine optimal upload timing based on competitor patterns

Setup & Installation

Quick Install

No install command available. Check the GitHub repository for manual installation instructions.

Alternative Install (Git Clone)

git clone https://github.com/clairechung/YoutubeAssistant

Requirements

Claude Code or compatible AI agent
Works with: Claude

Quick Start Guide

Install the Skill

Copy the install command above and run it in your terminal.

Open Your AI Agent

Launch Claude Code, Cursor, or your preferred AI coding agent.

Try It Out

Use the prompt template or examples below to test the skill.

Customize

Adapt the skill to your specific use case and workflow.

Usage Examples

Prompt Template

Act as a YouTubeAssistant. Analyze the following YouTube channel [CHANNEL_NAME] and provide insights on its content strategy, audience demographics, and engagement metrics. Focus on [INDUSTRY] and compare it with [COMPETITOR_CHANNEL]. Generate a report in markdown format with clear headings and bullet points.

Example Output

# YouTube Channel Analysis: [CHANNEL_NAME]

## Content Strategy
- **Video Topics**: Primarily focuses on [INDUSTRY] tutorials and product reviews.
- **Posting Frequency**: 2-3 videos per week, maintaining consistency.
- **Video Length**: Average duration of 12-15 minutes, optimized for viewer retention.

## Audience Demographics
- **Age Group**: Predominantly 18-34 years old.
- **Gender Distribution**: 60% male, 40% female.
- **Geographic Location**: Majority of viewers from the US, UK, and Canada.

## Engagement Metrics
- **Average Views**: 50,000 per video.
- **Likes to Dislikes Ratio**: 98:2, indicating high audience satisfaction.
- **Comment Engagement**: Average of 500 comments per video, fostering community interaction.

## Comparison with [COMPETITOR_CHANNEL]
- **Content Strategy**: [COMPETITOR_CHANNEL] focuses more on vlogs and behind-the-scenes content.
- **Engagement Metrics**: [COMPETITOR_CHANNEL] has a slightly higher average view count but lower comment engagement.

Apply to these tools

Browse all tools

Prayas Analytics

A/B testing for physical stores

Simple Analytics

Privacy-first analytics for modern businesses

Interstate Analytics

Multi-touch marketing analytics platform

Visitor Analytics

Cookie-free analytics with heatmaps and surveys

Syft Analytics

The only AI-first financial reporting platform

Moby Analytics

AI-powered financial auditing for accurate insights

Compatible MCP servers

Browse all MCP servers

Find the right skills for your stack

Take a free 3-minute scan and get personalized AI skill recommendations.

Take free scan

Overview

About This Skill

How to Use

Use Cases

Analyze competitor YouTube content strategy and identify successful formats

Research high-performing videos and hashtags in your niche

Discover content gaps and underrepresented topics in your category

Determine optimal upload timing based on competitor patterns

Quick Install

No install command available. Check the GitHub repository for manual installation instructions.

Alternative Install (Git Clone)

git clone https://github.com/clairechung/YoutubeAssistant

Requirements

Claude Code or compatible AI agent
Works with: Claude

Quick Start Guide

Install the Skill

Copy the install command above and run it in your terminal.

Open Your AI Agent

Launch Claude Code, Cursor, or your preferred AI coding agent.

Try It Out

Use the prompt template or examples below to test the skill.

Customize

Adapt the skill to your specific use case and workflow.

Usage Examples

Prompt Template

Act as a YouTubeAssistant. Analyze the following YouTube channel [CHANNEL_NAME] and provide insights on its content strategy, audience demographics, and engagement metrics. Focus on [INDUSTRY] and compare it with [COMPETITOR_CHANNEL]. Generate a report in markdown format with clear headings and bullet points.

Example Output

# YouTube Channel Analysis: [CHANNEL_NAME]

## Content Strategy
- **Video Topics**: Primarily focuses on [INDUSTRY] tutorials and product reviews.
- **Posting Frequency**: 2-3 videos per week, maintaining consistency.
- **Video Length**: Average duration of 12-15 minutes, optimized for viewer retention.

## Audience Demographics
- **Age Group**: Predominantly 18-34 years old.
- **Gender Distribution**: 60% male, 40% female.
- **Geographic Location**: Majority of viewers from the US, UK, and Canada.

## Engagement Metrics
- **Average Views**: 50,000 per video.
- **Likes to Dislikes Ratio**: 98:2, indicating high audience satisfaction.
- **Comment Engagement**: Average of 500 comments per video, fostering community interaction.

## Comparison with [COMPETITOR_CHANNEL]
- **Content Strategy**: [COMPETITOR_CHANNEL] focuses more on vlogs and behind-the-scenes content.
- **Engagement Metrics**: [COMPETITOR_CHANNEL] has a slightly higher average view count but lower comment engagement.

YoutubeAssistant

Overview

About This Skill

How to Use

Use Cases

Tags

Setup & Installation

Quick Install

Alternative Install (Git Clone)

Requirements

Quick Start Guide

Install the Skill

Open Your AI Agent

Try It Out

Customize

Usage Examples

Prompt Template

Example Output

Apply to these tools

Prayas Analytics

Simple Analytics

Interstate Analytics

Visitor Analytics

Syft Analytics

Moby Analytics

Compatible MCP servers

AWS Bedrock Logs MCP

bitcoin-mcp.server

Inbox Zero AI MCP

s

s

s

Find the right skills for your stack

YoutubeAssistant

Overview

About This Skill

How to Use

Use Cases

Tags

Setup & Installation

Quick Install

Alternative Install (Git Clone)

Requirements

Quick Start Guide

Install the Skill

Open Your AI Agent

Try It Out

Customize

Usage Examples

Prompt Template

Example Output

Apply to these tools

Prayas Analytics

Simple Analytics

Interstate Analytics

Visitor Analytics

Syft Analytics

Moby Analytics

Compatible MCP servers

AWS Bedrock Logs MCP

bitcoin-mcp.server

Inbox Zero AI MCP

s

s

s

Find the right skills for your stack