Name	Description
No prompts

No prompts

Name	Description
No resources

No resources

Name	Description
No tools

No tools

Name	Required	Description	Default
`SPREADSHEET_ID`	Yes	Your Google Sheets ID
`YOUTUBE_API_KEY`	Yes	Your YouTube Data API v3 key

SPREADSHEET_ID

Yes

Your Google Sheets ID

YOUTUBE_API_KEY

Yes

Your YouTube Data API v3 key

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

GitHub Badge

Glama performs regular codebase and documentation scans to:

Confirm that the MCP server is working as expected.
Confirm that there are no obvious security issues with dependencies of the server.
Extract server characteristics such as tools, resources, prompts, and required parameters.

Our directory badge helps users to quickly asses that the MCP server is safe, server capabilities, and instructions for installing the server.

Copy the following code to your README.md file:

Alternative MCP servers