by rickyyy1116
YouTube to Sheets automates video data collection in Google Sheets—perfect for content creators, marketers, and research
Searches YouTube videos and automatically saves results (title, URL, channel, publish date) to Google Sheets for easy data collection and analysis.
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.
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.
MIT
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.
Fetch and extract information from websites automatically
Example
Research competitor pricing, scrape product reviews, monitor news mentions
Automate 5-10 hours/week of manual web research
Track website changes, new content, price updates
Example
Monitor competitor blog for new posts, track stock availability, watch for pricing changes
Stay informed without manual checking, never miss important updates
Extract structured data from multiple websites
Example
Compile product listings from 10 e-commerce sites, aggregate job postings, collect real estate data
Build datasets 100x faster than manual copying
Share your MCP server with the developer community
YouTube to Sheets reduced integration guesswork — categories and install configs on the listing matched the upstream repo.
We wired YouTube to Sheets into a staging workspace; the listing’s GitHub and npm pointers saved time versus hunting across READMEs.
YouTube to Sheets is a well-scoped MCP server in the explainx.ai directory — install snippets and categories matched our Claude Code setup.
YouTube to Sheets is among the better-indexed MCP projects we tried; the explainx.ai summary tracks the official description.
We evaluated YouTube to Sheets against two servers with overlapping tools; this profile had the clearer scope statement.
YouTube to Sheets is a well-scoped MCP server in the explainx.ai directory — install snippets and categories matched our Claude Code setup.
Useful MCP listing: YouTube to Sheets is the kind of server we cite when onboarding engineers to host + tool permissions.
Strong directory entry: YouTube to Sheets surfaces stars and publisher context so we could sanity-check maintenance before adopting.
I recommend YouTube to Sheets for teams standardizing on MCP; the explainx.ai page compares cleanly with sibling servers.
We wired YouTube to Sheets into a staging workspace; the listing’s GitHub and npm pointers saved time versus hunting across READMEs.
showing 1-10 of 74
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.
npm install @rikukawa/youtube-sheets-server
YouTube Data API v3 Setup:
Google Sheets API Setup:
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": []
}
}
}
“Ask the AI assistant to ‘search for YouTube videos with “ChatGPT usage” and retrieve 10 videos’ and try using it in that way.”
The tool will save the following information to your Google Sheet:
MIT
Riku Kawashima
Interact with services that don't offer APIs
Example
Check form submissions, validate website functionality, test user flows
Automate interactions with any website, even without API
Prerequisites
Time Estimate
20-40 minutes including configuration and testing
Steps
Troubleshooting
✓ Do
✗ Don't
💡 Pro Tips
Architecture
MCP server handles HTTP requests, HTML parsing, JavaScript rendering (if headless browser), and returns structured data to Claude.
Protocols
Compatibility
✓ Use when
Use for research automation, content monitoring, data aggregation from multiple sources, and when official APIs don't exist. Best for read-only information gathering.
✗ Avoid when
Avoid for sites with APIs (use API instead), sites that explicitly forbid scraping, when data is copyrighted, or for login-required content without proper authorization.