MCP Servers

mcp-youtube-sheets

Provides functionality to search YouTube videos and automatically save the results to Google Sheets.

Rickyyy1116

Entertainment & Media

Developer Tools

README

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

YouTube Data API v3 Setup:
- Go to Google Cloud Console
- Create a new project
- Enable YouTube Data API v3
- Create an API key
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

Recommended Servers

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

MCP Package Docs Server

Facilitates LLMs to efficiently access and fetch structured documentation for packages in Go, Python, and NPM, enhancing software development with multi-language support and performance optimization.

Claude Code MCP

An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.

@kazuph/mcp-taskmanager

Model Context Protocol server for Task Management. This allows Claude Desktop (or any MCP client) to manage and execute tasks in a queue-based system.

Linear MCP Server

Enables interaction with Linear's API for managing issues, teams, and projects programmatically through the Model Context Protocol.

YouTube Transcript MCP Server

This server retrieves transcripts for given YouTube video URLs, enabling integration with Goose CLI or Goose Desktop for transcript extraction and processing.

mermaid-mcp-server

A Model Context Protocol (MCP) server that converts Mermaid diagrams to PNG images.

The Verge News MCP Server

Provides tools to fetch and search news from The Verge's RSS feed, allowing users to get today's news, retrieve random articles from the past week, and search for specific keywords in recent Verge content.

Jira-Context-MCP

MCP server to provide Jira Tickets information to AI coding agents like Cursor