What is Mcp Youtube Sheets

mcp-youtube-sheets is an MCP server that allows users to search for YouTube videos and automatically save the results to Google Sheets. It is designed to integrate with AI assistants that support the Model Context Protocol.

Use cases

Use cases include automating the collection of video data for analysis, tracking trends in video content, compiling lists of resources for educational purposes, and managing video marketing campaigns.

How to use

To use mcp-youtube-sheets, install the package via npm, set up the necessary APIs, and configure the server in your MCP settings. You can then ask your AI assistant to search for YouTube videos with specific queries and retrieve the results.

Key features

Key features include searching YouTube videos using the YouTube Data API v3, automatically saving search results to Google Sheets, configurable search parameters (such as query and max results), and outputting video title, URL, channel name, and publish date.

Where to use

mcp-youtube-sheets can be used in various fields such as content creation, digital marketing, education, and research, where tracking and analyzing video content is beneficial.

YouTube to Google Sheets MCP Server

This MCP server provides functionality to search YouTube videos and automatically save the results to Google Sheets. It’s designed to work with Claude and other AI assistants that support the Model Context Protocol.

English | 日本語

Features

• Search YouTube videos using the YouTube Data API v3
• Save search results to Google Sheets automatically
• Configurable search parameters (query, max results)
• Results include video title, URL, channel name, and publish date

Installation

npm install @rikukawa/youtube-sheets-server

Prerequisites

1. YouTube Data API v3 Setup:

   • Go to Google Cloud Console
   • Create a new project
   • Enable YouTube Data API v3
   • Create an API key

2. Google Sheets API Setup:

   • In the same project, enable Google Sheets API
   • Create a service account
   • Download the service account key (JSON format)
   • Share your target Google Sheet with the service account email

Configuration

Add the server to your MCP settings file:

{
  "mcpServers": {
    "youtube-sheets": {
      "command": "node",
      "args": [
        "path/to/youtube-sheets-server/build/index.js"
      ],
      "env": {
        "YOUTUBE_API_KEY": "your-youtube-api-key",
        "SPREADSHEET_ID": "your-spreadsheet-id"
      },
      "disabled": false,
      "alwaysAllow": []
    }
  }
}

Usage

“Ask the AI assistant to ‘search for YouTube videos with “ChatGPT usage” and retrieve 10 videos’ and try using it in that way.”

Output Format

The tool will save the following information to your Google Sheet:

• Video Title
• Video URL
• Channel Name
• Publish Date

License

MIT

Author

Riku Kawashima

Repository

GitHub Repository

NPM Package

@rikukawa/youtube-sheets-server