FastMCP FastMCP
Sign In
G

Google Sheets

Integrates with Google Drive and Google Sheets to create, read, update, and manage spreadsheets with...

127 views
2 installs
Updated Oct 15, 2025
Not audited
Productivity Automation
Integrates with Google Drive and Google Sheets to create, read, update, and manage spreadsheets with support for both OAuth and service account authentication methods.

  1. Go to the Google Cloud Console

  2. Create or Select a GCP Project

    • In the top menu, select an existing project or click on the project dropdown and choose "New Project" to create one.

  3. Enable Necessary APIs

    • Navigate to “APIs & Services” > “Library.”
    • Search for and enable:
      • Google Sheets API
      • Google Drive API

  4. Create a Service Account (Recommended for Automation)

    • Go to “IAM & Admin” > “Service Accounts.”
    • Click + CREATE SERVICE ACCOUNT.
    • Enter a name (e.g., mcp-sheets-service) and description.
    • Click "Create and Continue."
    • Grant this service account access to project:
      • Add the Editor role (or more granular, e.g., “Drive File” and “Sheets” roles for stricter permissions).
    • Click "Continue" then "Done."

  5. Download the Service Account JSON Key

    • In the service accounts list, find your newly created account.
    • Click the three dots under “Actions” and select “Manage keys.”
    • Under the "Keys" tab, click ADD KEY > "Create new key" > choose JSON > CREATE.
    • The JSON key file will download. Save this file securely.

  6. Create and Share a Google Drive Folder

    • Go to Google Drive.
    • Click "+ New" > "Folder" and give it a name (e.g., "AI Managed Sheets").
    • Open the folder and copy the Folder ID from the URL:
      For example, in https://drive.google.com/drive/folders/THIS_IS_THE_FOLDER_ID, THIS_IS_THE_FOLDER_ID is the value you need.
    • Right-click the folder > "Share" > enter the service account’s email (found in your JSON key under client_email).
    • Grant Editor access, uncheck "Notify people," and click "Share."

  7. Fill In Your Values In The FastMCP Connection Interface

    • Use your button (“Install Now”) to add environment variables.
    • Fill in the fields as follows:
      • SERVICE_ACCOUNT_PATH: Enter the path to your downloaded service account JSON key file.
      • DRIVE_FOLDER_ID: Enter the folder ID of the Google Drive folder you just created.

    (If using “CREDENTIALS_CONFIG” instead: Convert the content of your JSON file to Base64 and use that string, per advanced instructions in the README.)

  8. Save and Connect

    • Complete the FastMCP server setup by saving/proceeding.
    • You are now ready to connect your client!

Note:

  • Use the "Service Account" method for most server and automation scenarios.
  • For detailed steps on OAuth or alternative methods, see the README sections above.
  • If you get a “spawn uvx ENOENT” error on macOS, use the full path to uvx as described.

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.