Y

YouTube to Sheets

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

135 views
0 installs
Updated Nov 22, 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

Report Issue

Thank you! Your issue report has been submitted successfully.