YouTube to Sheets
Searches YouTube videos and automatically saves results (title, URL, channel, publish date) to Google Sheets for easy data collection and analysis.
Integrates YouTube search with Google Sheets to automate video data collection and analysis for content creators, marketers, and researchers.
What it does
- Search YouTube videos using API
- Save video results to Google Sheets automatically
- Configure search parameters and result limits
- Extract video metadata including title and channel info
Best for
About YouTube to Sheets
YouTube to Sheets is a community-built MCP server published by rickyyy1116 that provides AI assistants with tools and capabilities via the Model Context Protocol. YouTube to Sheets automates video data collection in Google Sheets—perfect for content creators, marketers, and research It is categorized under search web, productivity.
How to install
You can install YouTube to Sheets in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.
License
YouTube to Sheets is released under the MIT license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.
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.
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
-
YouTube Data API v3 Setup:
- Go to Google Cloud Console
- Create a new project
- Enable YouTube Data API v3
- Create an API key
-
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
NPM Package
Alternatives
Related Skills
Browse all skillsGenerates B2B/B2C leads by scraping Google Maps, websites, Instagram, TikTok, Facebook, LinkedIn, YouTube, and Google Search. Use when user asks to find leads, prospects, businesses, build lead lists, enrich contacts, or scrape profiles for sales outreach.
This skill should be used when the user asks to "유튜브 정리", "영상 요약", "transcript 번역", "YouTube digest", "영상 퀴즈", or provides a YouTube URL for analysis. Extracts transcript, generates summary/insights/Korean translation, and tests comprehension with 9 quiz questions across 3 difficulty levels. Optional Deep Research for web-based follow-up.
Zero-Hassle Crafted Recruitment Automation - From job spec to candidate evaluation in seconds. Automatically search the web, LinkedIn, and GitHub, score candidates, populate tracking sheets, and draft outreach emails by we-crafted.com/agents/recruitment-automation - Buy CRAFTED_API_KEY in our website to start using
Official Google SEO guide covering search optimization, best practices, Search Console, crawling, indexing, and improving website search visibility based on official Google documentation
Convert various file formats (PDF, Office documents, images, audio, web content, structured data) to Markdown optimized for LLM processing. Use when converting documents to markdown, extracting text from PDFs/Office files, transcribing audio, performing OCR on images, extracting YouTube transcripts, or processing batches of files. Supports 20+ formats including DOCX, XLSX, PPTX, PDF, HTML, EPUB, CSV, JSON, images with OCR, and audio with transcription.
Create user-centered, accessible interface copy (microcopy) for digital products including buttons, labels, error messages, notifications, forms, onboarding, empty states, success messages, and help text. Use when writing or editing any text that appears in apps, websites, or software interfaces, designing conversational flows, establishing voice and tone guidelines, auditing product content for consistency and usability, reviewing UI strings, or improving existing interface copy. Applies UX writing best practices based on four quality standards — purposeful, concise, conversational, and clear. Includes accessibility guidelines, research-backed benchmarks (sentence length, comprehension rates, reading levels), expanded error patterns, tone adaptation frameworks, and comprehensive reference materials.