home / mcp / google spreadsheet mcp server

Google Spreadsheet MCP Server

Provides Google Drive and Google Sheets access via MCP, enabling listing, reading, and editing files and spreadsheet data.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "kazz187-mcp-google-spreadsheet": {
      "command": "mcp-google-spreadsheet",
      "args": [],
      "env": {
        "MCPGS_FOLDER_ID": "<your_folder_id>",
        "MCPGS_TOKEN_PATH": "<path_to_token.json>",
        "MCPGS_CLIENT_SECRET_PATH": "<path_to_client_secret.json>"
      }
    }
  }
}

You can use the MCP Google Spreadsheet server to let your AI assistant interact with Google Drive and Google Sheets. It exposes a set of tools to list, read, modify, and organize Drive files and spreadsheet data, enabling automation and conversational workflows that involve documents and spreadsheets.

How to use

You run the MCP Google Spreadsheet server locally and connect it to your MCP client. The server exposes functions to list Drive files, copy or rename items, and manage sheets by listing sheets, reading data, adding or deleting rows/columns, and updating cells. Start the server with the required environment variables, then configure your client to point to the local binary. From your MCP client, call the available tools by their exact names to perform actions on Google Drive and Google Sheets.

How to install

# Prerequisites
- Go 1.24 or newer

# Install the MCP Google Spreadsheet server
go install github.com/kazz187/mcp-google-spreadsheet@latest

# Ensure the binary is in your PATH if you used go install
# On Unix-like systems, this typically means:
# export PATH=$PATH:$GOPATH/bin

Additional content

Configuration, security, and usage notes are provided to help you run and manage the server safely. Explicit details are below to ensure you can set up authentication, point to the correct Google Drive folder, and keep credentials secure.

Available tools

google_drive_list_files

List files and folders in Google Drive to locate spreadsheets and other documents.

google_drive_copy_file

Copy a file or folder to another location within Google Drive.

google_drive_rename_file

Rename a file or folder in Google Drive.

google_sheets_list_sheets

Get a list of sheets (tabs) within a Google Sheets document.

google_sheets_copy_sheet

Copy a sheet from one spreadsheet to another.

google_sheets_rename_sheet

Rename a sheet (tab) in a Google Sheets document.

google_sheets_read_data

Read data from a sheet (open and display content).

google_sheets_add_rows

Insert empty rows into a sheet.

google_sheets_add_columns

Insert empty columns into a sheet.

google_sheets_update_cells

Update values in a specified cell range.

google_sheets_batch_update_cells

Update multiple cell ranges in a single operation.

google_sheets_delete_rows

Delete rows from a sheet.

google_sheets_delete_columns

Delete columns from a sheet.