YouTube to Google Sheets

Local

API Integration

Integrate this MCP server into your applications.

Get your API Key

You'll need to login and generate a Smithery API key to connect to this server.

Installation

Install the official MCP SDKs using npm:

bash

npm install @modelcontextprotocol/sdk

TypeScript SDK

typescript


import { StdioClientTransport } from "@modelcontextprotocol/sdk/client/stdio.js"

const transport = new StdioClientTransport({
  "command": "npx",
  "args": [
    "-y",
    "@rikukawa/youtube-sheets-server"
  ],
  "env": {
    "YOUTUBE_API_KEY": "YOUR_YOUTUBE_API_KEY",
    "SPREADSHEET_ID": "YOUR_SPREADSHEET_ID",
    "PATH": process.env.PATH
  }
})

// Create MCP client
import { Client } from "@modelcontextprotocol/sdk/client/index.js"

const client = new Client({
	name: "Test client",
	version: "1.0.0"
})
await client.connect(transport)

// Use the server tools with your LLM application
const tools = await client.listTools()
console.log(`Available tools: ${tools.map(t => t.name).join(", ")}`)

Configuration Schema

Full JSON Schema for server configuration:

json

{
  "type": "object",
  "required": [
    "youtubeApiKey",
    "spreadsheetId"
  ],
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "The ID of your Google Spreadsheet."
    },
    "youtubeApiKey": {
      "type": "string",
      "description": "Your YouTube Data API key."
    }
  }
}