A favicon of YouTube to Google Sheets

YouTube to Google Sheets

MCP server for searching YouTube videos and saving results to Google Sheets.

Installation

Installing for Claude Desktop

Option 1: One-Command Installation

npx mcpbar@latest install Rickyyy1116/mcp-youtube-sheets -c claude

This command will automatically install and configure the YouTube to Google Sheets MCP server for your selected client.

Option 2: Manual Configuration

Run the command below to open your configuration file:

npx mcpbar@latest edit -c claude

After opening your configuration file, copy and paste this configuration:

View JSON configuration
{
  "mcpServers": {
    "YouTube to Google 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": []
    }
  }
}

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

  1. YouTube Data API v3 Setup:

  2. 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

Share:
Details:
  • Stars


    10
  • Forks


    5
  • Last commit


    7 months ago
  • Repository age


    7 months
  • License


    MIT
View Repository

Auto-fetched from GitHub .

MCP servers similar to YouTube to Google Sheets:

 

 
 
  • Stars


  • Forks


  • Last commit


 

 
 
  • Stars


  • Forks


  • Last commit


 

 
 
  • Stars


  • Forks


  • Last commit


YouTube to Google Sheets: MCP Server – MCP.Bar