YouTube to Google Sheets

Queries YouTube Data API v3 and saves results to Google Sheets for easy logging and access.

javascript

11

GitHub Stars

javascript

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "rickyyy1116-mcp-youtube-sheets": {
      "command": "node",
      "args": [
        "path/to/youtube-sheets-server/build/index.js"
      ],
      "env": {
        "SPREADSHEET_ID": "your-spreadsheet-id",
        "YOUTUBE_API_KEY": "your-youtube-api-key"
      }
    }
  }
}

This MCP server lets you search YouTube videos and automatically save the results to a Google Sheet, enabling AI assistants to fetch video details and log them for easy analysis or reporting.

How to use

You will run a local MCP server for YouTube searches and Google Sheets logging. Connect an MCP client to this server and ask it to perform a YouTube search with your chosen query and a desired number of results. The server will return the video details and automatically append them to your Google Sheet, including video title, URL, channel name, and publish date. Use this to build workflows where AI assistants gather video data and store it in a shared sheet for teammates to review.

How to install

Prerequisites you need before installing this MCP server:

YouTube Data API v3 setup: create a project in the Google Cloud Console, enable YouTube Data API v3, and create an API key.
Google Sheets API setup: enable Google Sheets API in the same project, create a service account, download the service account key (JSON), and share your target Google Sheet with the service account email.

Install the MCP server package using npm.

npm install @rikukawa/youtube-sheets-server

Configuration

Add the MCP server to your MCP settings with the following configuration snippet.

{
  "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": []
    }
  }
}

Output format and usage notes

The server saves the following fields to your Google Sheet for each search result: Video Title, Video URL, Channel Name, Publish Date.

Typical usage is to perform a YouTube search with a chosen query and a specified max results, then rely on the server to append the results to your sheet automatically.

Notes and capabilities

This server supports searching YouTube videos via the YouTube Data API v3 and logging results into Google Sheets. It is designed to work with Claude and other AI assistants that support the Model Context Protocol.

Available tools

search_youtube

Search YouTube videos by query and max results using the YouTube Data API v3.

log_to_sheets

Save search results to Google Sheets, including title, URL, channel, and publish date.