Google Sheets MCP

Overview

The Google Sheets MCP server enables AI agents to read and write data in Google Sheets spreadsheets. Perfect for data analysis, report generation, and automated data entry tasks.

Features

• Read Sheets: Fetch data from specific sheets or ranges
• Write Data: Update cells and ranges
• Create Sheets: Create new spreadsheets
• List Spreadsheets: Browse all accessible spreadsheets
• Append Rows: Add new rows of data

Installation

npx -y @modelcontextprotocol/server-google-sheets

Configuration

{
  "mcpServers": {
    "google-sheets": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-google-sheets"],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "/path/to/credentials.json"
      }
    }
  }
}

Available Tools

Tool	Description
list_spreadsheets	List all accessible spreadsheets
read_sheet	Read data from a sheet
update_sheet	Update cell values
append_rows	Append new rows
create_spreadsheet	Create a new spreadsheet

Usage Examples

Read Budget Data

Read the "Budget" sheet from my "Finance 2026" spreadsheet.

Add New Entry

Add a new row to the "Expenses" sheet with date, category, and amount.

Create Tracking Sheet

Create a new spreadsheet called "Project Tracker" with columns for Task, Status, and Due Date.

Pros

• ✅ Direct spreadsheet access
• ✅ Easy data manipulation
• ✅ Good for data analysis workflows

Cons

• ❌ Requires OAuth setup
• ❌ Limited to Google Sheets format
• ❌ Large sheets may be slow

Resources

• MCP Server Repository
• Google Sheets API Docs