G

Google Sheets

Integrates with Google Sheets API to provide spreadsheet automation through 25 specialized tools for...

85 views
1 installs
Updated Sep 19, 2025
Not audited
Integrates with Google Sheets API to provide spreadsheet automation through 25 specialized tools for sheet management, table operations, CRUD functionality, column type management, sorting, and cell manipulation with structured data validation and batch processing capabilities.
  1. Create a Google Cloud Project

    • Go to the Google Cloud Console.
    • Click "Select a project" and then "New Project".
    • Enter a project name (e.g., "my-sheets-automation") and click "Create".
  2. Enable Google APIs

    • In your new project, go to "APIs & Services" → "Library".
    • Search for "Google Sheets API", click it, and then click "Enable".
    • Search for "Google Drive API", click it, and then click "Enable".
  3. Create a Google Service Account

    • Navigate to "IAM & Admin" → "Service Accounts".
    • Click "Create Service Account".
    • Set the service account name (e.g., "sheets-mcp-service") and click "Create and Continue".
    • Skip the role assignment and click "Continue".
    • Click "Done".
  4. Generate a Service Account JSON Key

    • Select your new service account from the list.
    • Go to the "Keys" tab.
    • Click "Add Key" → "Create new key".
    • Choose "JSON" format and click "Create".
    • A JSON file containing your credentials will download automatically.
  5. Extract Required Environment Values

    • Open the downloaded JSON file.
    • Copy these values to use in the next step:
      • project_id
      • private_key_id
      • private_key
      • client_email
      • client_id
      • client_x509_cert_url
  6. Fill in Values in the FastMCP Connection Interface

    • Click the "Install Now" button to add a new server connection in FastMCP.
    • Fill in the fields using the values you copied from the Google Service Account JSON:
      • project_id
      • private_key_id
      • private_key (copy the entire key, including "-----BEGIN PRIVATE KEY-----" and "-----END PRIVATE KEY-----")
      • client_email
      • client_id
      • client_x509_cert_url
  7. Share your Google Sheet with the Service Account

    • Open your target Google Spreadsheet in your browser.
    • Click the Share button.
    • Enter the service account email you copied (e.g., your-service@your-project.iam.gserviceaccount.com) and assign "Editor" access.
    • Click "Send" to grant access.

You’re done! The Google Sheets MCP integration is now ready to use with FastMCP.

Quick Start

View on GitHub

More for Productivity

View All →

More for Automation

View All →

Similar MCP Servers

Report Issue

Thank you! Your issue report has been submitted successfully.