mcp-youtube-sheets
YouTube 到 Google Sheets MCP 服务器
此 MCP 服务器提供搜索 YouTube 视频并自动将搜索结果保存到 Google 表格的功能。它旨在与 Claude 以及其他支持模型上下文协议 (MCP) 的 AI 助手协同工作。
特征
使用 YouTube 数据 API v3 搜索 YouTube 视频
自动将搜索结果保存到 Google 表格
可配置的搜索参数(查询、最大结果)
结果包括视频标题、URL、频道名称和发布日期
Related MCP server: YouTube MCP Server
安装
npm install @rikukawa/youtube-sheets-server先决条件
YouTube 数据 API v3 设置:
创建新项目
启用 YouTube 数据 API v3
创建 API 密钥
Google Sheets API 设置:
在同一个项目中,启用 Google Sheets API
创建服务帐户
下载服务帐号密钥(JSON格式)
与服务帐户电子邮件共享您的目标 Google Sheet
配置
将服务器添加到您的 MCP 设置文件:
{
"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": []
}
}
}用法
“让 AI 助手‘使用‘ChatGPT 使用方法’搜索 YouTube 视频并检索 10 个视频’,然后尝试以这种方式使用它。”
输出格式
该工具将把以下信息保存到您的 Google Sheet:
视频标题
视频网址
频道名称
发布日期
执照
麻省理工学院
作者
川岛陆
存储库
NPM 包
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Search YouTube and read video, channel and transcript data as JSON. No Google Cloud project.
YouTube search, whole channels, video stats, comments and full transcripts with timestamps.
YouTube discovery, transcripts, library search, and monitors with API keys or OAuth.
YouTube transcripts, comments, video details, heatmaps, search, channels and playlists.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables interaction with YouTube through the YouTube Data API, allowing users to search for videos, playlists, and channels, generate video titles using AI, and manage YouTube content through natural language commands.22ISC
- FlicenseBqualityDmaintenanceEnables interaction with YouTube through search and transcript extraction functionality. Allows searching for videos and retrieving full transcripts with timestamps for content analysis.28-
- AlicenseNot gradedqualityDmaintenanceProvides tools for searching YouTube videos, retrieving transcripts, and performing semantic search over video content.MIT
- AlicenseBqualityDmaintenanceProvides tools for reading, modifying, and analyzing Google Sheets, as well as searching and managing Google Drive spreadsheets with access control.25MIT