MCP Youtube Sheets

🚀 YouTube to Google Sheets MCP Server

This MCP server provides the functionality to search for YouTube videos and automatically save the results to a Google Sheet. It is designed for Claude and other AI assistants that support the Model Context Protocol.

English | 中文

🚀 Quick Start

This MCP server enables you to search for YouTube videos and automatically save the results to a Google Sheet. It's tailored for Claude and other AI assistants supporting the Model Context Protocol.

✨ Features

• Search for YouTube videos using the YouTube Data API v3.
• Automatically save search results to a Google Sheet.
• Configurable search parameters (query, maximum number of results).
• Results include video title, URL, channel name, and publication date.

📦 Installation

npm install @rikukawa/youtube-sheets-server

Prerequisites

1. YouTube Data API v3 Setup:

   • Visit the Google Cloud Console.
   • Create a new project.
   • Enable the YouTube Data API v3.
   • Create an API key.

2. Google Sheets API Setup:

   • In the same project, enable the Google Sheets API.
   • Create a service account.
   • Download the service account key (in JSON format).
   • Share the 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 Examples

Basic Usage

Try using it in this way: "Ask the AI assistant to search for YouTube videos with the phrase 'ChatGPT Usage' and retrieve 10 videos."

Output Format

The tool saves the following information to your Google Sheet:

• Video title
• Video URL
• Channel name
• Publication date

📄 License

MIT

Author

Riku Kawashima

Repository

GitHub Repository

NPM Package

@rikukawa/youtube-sheets-server