Perfect for content creators, marketers, and researchers who need to understand YouTube trends without expensive analytics platforms.
A powerful YouTube analytics tool that turns complex video data into clear, actionable insights. Perfect for content creators, marketers, and researchers who need to understand YouTube trends without expensive analytics platforms.
- Why YouTube Assistant?
- Features
- Setup
- What You Get
- How to Use
- Data Columns
- Use Cases & Success Stories
- Troubleshooting
- Contributing & Support
💰 Completely Free • ⚡ 1-Minute Setup • 📈 20+ Metrics • 🎯 Smart Analysis
No expensive analytics subscriptions needed - 100% free!
- Shorts Support - Dedicated analytics for videos ≤60 seconds
- Detailed Metrics - Views, likes, comments, engagement rates, subscriber counts
- Trend Analysis - Hashtag extraction and content categorization
- Real-time Progress - Live updates while fetching data
- Performance Score - 0-100 composite performance rating
- Smart Analysis - Automatically identifies high-performing content and gaps
- Export Ready - All data in familiar Google Sheets format
🚀 Get started in just 3 steps!
- Go to Google Sheets and create a new sheet
- Open Extensions → Apps Script
- Delete any existing code in the editor
- Copy and paste ALL the code from
youtube-assistant.js - Save the project (
cmd + sorctrl + s) - Important: Refresh your Google Sheet to see the menu appear
- Visit Google Cloud Console
- Create a new project or select existing one
- Enable YouTube Data API v3 in APIs & Services → Library
- Create credentials → API Key and Copy the API key
Option A: Use the menu (Recommended)
- Refresh your Google Sheet to see the YouTube Assistant menu
- Click YouTube Assistant → Configure API Key from the menu
- Enter your API key when prompted
- Click OK to save
Option B: Edit the code directly
- Find the
setupApiKey()function in the Apps Script editor - Replace
"YOUR_API_KEY_HERE"with your actual API key - Run the
setupApiKeyfunction once from the Apps Script editor
After running the analysis, you'll see a comprehensive spreadsheet like this:
- Top Performers: Videos with highest engagement and performance scores
- Content Gaps: Underrepresented categories and formats in your niche
- Best Upload Times: Optimal days and hours for publishing
- Commonly Used Hashtags: Most effective hashtags in your topic area
- Engagement Patterns: What drives likes, comments, and views
- Click YouTube Assistant → Setup New Sheet to generate a new analysis sheet
- Enter search term in
B1(e.g., "javascript tutorial") - Enter number of results in
D1(recommended: 25-50) - Click YouTube Assistant → Fetch YouTube Data
- Wait for completion (progress shown in F1)
- Research Competitors: Search for your competitors' topics
- Find Content Gaps: Look for underrepresented categories
- Optimize Timing: Use upload pattern analysis for better reach
- Track Trends: Monitor hashtag performance over time
Click to see all 21 data columns and metrics
- Category: Video category (e.g., Education, Entertainment)
- Thumbnail: Clickable video preview image
- Video Title: Clickable link to the video
- Views: Total view count
- Description: Video description (truncated for display)
- Channel Name: Creator name
- Subscribers: Channel subscriber count
- Upload Date: When the video was published
- Tags: Video tags from creator
- Hashtags: Extracted hashtags from title and description
- Duration: Video length
- Content Type: Shorts/Mid-form/Long-form categorization
- Captions Available: Whether video has captions
- Likes: Total like count
- Like Rate (%): Likes as percentage of views
- Comment Rate (%): Comments as percentage of views
- Engagement Rate (%): Combined engagement metric
- Comments: Total comment count
- Performance Score: 0-100 composite rating
- Views/Day: Average daily views since upload
- High Engagement: Yes/No indicator for top performers
See real-world applications and success stories
- Find Winning Topics: Discover high-engagement content in your niche
- Optimize Upload Schedule: Use data-driven timing for maximum reach
- Beat the Algorithm: Identify trending hashtags and formats
- Competitor Analysis: Analyze competitor content strategies
- Campaign Planning: Find the best-performing content types
- ROI Tracking: Measure content performance across campaigns
- Market Research: Understand content trends in any industry
- Academic Studies: Gather YouTube data for research projects
- Trend Analysis: Track content evolution over time
- Check the Execution log in Apps Script for error messages
- Run YouTube Assistant → Test Setup to check if everything is configured
- Make sure you configured your API key using the menu or setupApiKey function
- Refresh your Google Sheet (
cmd + rorF5) - Try running the script again from Apps Script
- Double-check your API key is copied correctly (no extra spaces)
- Make sure YouTube Data API v3 is enabled in Google Cloud Console
- Try reconfiguring using YouTube Assistant → Configure API Key
- Run YouTube Assistant → Test Setup to verify configuration
- Use fewer results (10-25 for quick analysis)
- Try more specific search terms
- Check your internet connection
- Reduce the number of results per search
- Wait a few minutes before trying again
- Run YouTube Assistant → Test Setup from the menu
- Check the execution log in Apps Script for detailed error messages
- Make sure all the code from
youtube-assistant.jsis copied correctly
Help make this tool even better!
- Report Bugs - Found an issue? Help us fix it!
- Suggest Features - Have ideas? We'd love to hear them
- Submit PRs - Code improvements are always welcome
- ⭐️ Star this repo - Help others discover this tool
- Share on social - Spread the word to fellow creators
- Tell friends - Word of mouth is the best marketing
Made with 🤍 for the YouTube creator community
Licensed under the Apache License 2.0