Y

YouTube to Sheets

Integrates YouTube search with Google Sheets to automate video data collection and analysis for cont...

67 views
0 installs
Updated Sep 10, 2025
Not audited
Integrates YouTube search with Google Sheets to automate video data collection and analysis for content creators, marketers, and researchers.
  1. Obtain a YouTube Data API Key

    • Go to the Google Cloud Console.
    • Create a new project (or select an existing one).
    • Navigate to “APIs & Services” > “Library”.
    • Search for “YouTube Data API v3” and click on it.
    • Click “Enable” to enable the API.
    • Go to “APIs & Services” > “Credentials”.
    • Click “Create Credentials” > “API key”.
    • Copy the generated API key.
  2. Obtain a Google Sheets Spreadsheet ID

    • Open your Google Sheet in a browser.
    • The Spreadsheet ID is the long string in your sheet’s URL between /d/ and /edit (e.g., in https://docs.google.com/spreadsheets/d/abc123XYZ456/edit, your ID is abc123XYZ456).
  3. Enable the Google Sheets API and Set Up a Service Account

    • In the Google Cloud Console, make sure your project is still selected.
    • Go to “APIs & Services” > “Library”.
    • Search for “Google Sheets API” and enable it.
    • Go to “APIs & Services” > “Credentials”.
    • Click “Create Credentials” > “Service Account”.
    • Fill out the form and click “Create and Continue” (no special roles needed for simple access).
    • Click “Done”.
    • Find your new service account in the list and click on it.
    • Go to the “Keys” tab.
    • Click “Add Key” > “Create new key”, select “JSON”, and click “Create”.
    • Download and save the JSON key file securely.
    • Open the JSON file and copy the “client_email” value.
  4. Share Your Google Sheet With the Service Account

    • Open your Google Sheet.
    • Click the “Share” button.
    • Add the service account email (copied from “client_email” in the JSON file) as an editor.
  5. Fill in the Install Now Interface

    • In the FastMCP connection interface, use your obtained values:
      • YOUTUBE_API_KEY: Paste the API key obtained in Step 1.
      • SPREADSHEET_ID: Paste the Spreadsheet ID obtained in Step 2.
      • You may also need to upload or reference the service account key JSON if required by the interface. If so, follow any upload prompts.

Note: All of these values should be filled into the FastMCP “Install Now” connection interface where prompted.

Quick Start

View on GitHub

More for Web Search

View All →

More for Productivity

View All →

Similar MCP Servers

Y

YouTube Subtitles

Integrates YouTube subtitle retrieval for natural language queries about video content.

Web Scraping Entertainment and Media
Y

YouTube Transcript

Fetches and analyzes YouTube video transcripts by accepting URLs or video IDs and returning formatted transcript data with timestamps for video content analysis without watching.

Web Scraping Entertainment and Media
Y

YouTube Transcript

Extracts and formats YouTube video transcripts with language selection, paragraph formatting, and metadata enrichment for content analysis and research workflows.

Web Scraping Entertainment and Media

Report Issue

Thank you! Your issue report has been submitted successfully.