Searches YouTube videos and writes the results into a Google Sheets spreadsheet.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add youtube-sheets --env SPREADSHEET_ID='<SPREADSHEET_ID>' --env YOUTUBE_API_KEY='<YOUTUBE_API_KEY>' -- node path/to/youtube-sheets-server/build/index.js~/.codex/config.toml
[mcp_servers.youtube-sheets]
command = "node"
args = ["path/to/youtube-sheets-server/build/index.js"]
env = { SPREADSHEET_ID = "<SPREADSHEET_ID>", YOUTUBE_API_KEY = "<YOUTUBE_API_KEY>" }
# codex mcp add youtube-sheets --env SPREADSHEET_ID='<SPREADSHEET_ID>' --env YOUTUBE_API_KEY='<YOUTUBE_API_KEY>' -- node path/to/youtube-sheets-server/build/index.js~/.cursor/mcp.json
{
"mcpServers": {
"youtube-sheets": {
"command": "node",
"args": [
"path/to/youtube-sheets-server/build/index.js"
],
"env": {
"SPREADSHEET_ID": "<SPREADSHEET_ID>",
"YOUTUBE_API_KEY": "<YOUTUBE_API_KEY>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"youtube-sheets": {
"type": "stdio",
"command": "node",
"args": [
"path/to/youtube-sheets-server/build/index.js"
],
"env": {
"SPREADSHEET_ID": "<SPREADSHEET_ID>",
"YOUTUBE_API_KEY": "<YOUTUBE_API_KEY>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"youtube-sheets": {
"command": "node",
"args": [
"path/to/youtube-sheets-server/build/index.js"
],
"env": {
"SPREADSHEET_ID": "<SPREADSHEET_ID>",
"YOUTUBE_API_KEY": "<YOUTUBE_API_KEY>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"youtube-sheets": {
"command": "node",
"args": [
"path/to/youtube-sheets-server/build/index.js"
],
"env": {
"SPREADSHEET_ID": "<SPREADSHEET_ID>",
"YOUTUBE_API_KEY": "<YOUTUBE_API_KEY>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"youtube-sheets": {
"command": "node",
"args": [
"path/to/youtube-sheets-server/build/index.js"
],
"env": {
"SPREADSHEET_ID": "<SPREADSHEET_ID>",
"YOUTUBE_API_KEY": "<YOUTUBE_API_KEY>"
}
}
}
}Environment variables
SPREADSHEET_IDYOUTUBE_API_KEY
Replace the placeholders with your own credentials and keep them out of version control.