Related MCP Server Resources

Explore more AI models, providers, and integration options:

  • Explore AI Models
  • Explore AI Providers
  • Explore MCP Servers
  • LangDB Pricing
  • Documentation
  • AI Industry Blog
  • Google Drive MCP Server
  • Google Workspace MCP Server
  • Kubectl MCP Tool
  • MongoDB MCP Server for LLMs
  • Jira MCP Server
Back to MCP Servers
Google Sheets MCP

Google Sheets MCP

Public
mkummer225/google-sheets-mcp

Enables AI agents to seamlessly interact with Google Sheets via Model Context Protocol, offering comprehensive spreadsheet management including reading, editing, creating, and organizing sheets and data.

javascript
0 tools
May 30, 2025
Updated Jun 4, 2025

Supercharge Your AI with Google Sheets MCP

MCP Server

Unlock the full potential of Google Sheets MCP through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.

Unified API Access
Complete Tracing
Instant Setup
Get Started Now

Free tier available • No credit card required

Instant Setup
99.9% Uptime
10,000+Monthly Requests

Google Sheets MCP

A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.

Demo

https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3

Setup

  1. Clone this repository:
git clone https://github.com/mkummer225/google-sheets-mcp cd google-sheets-mcp
  1. Install dependencies: npm install

  2. Build: npm run build

  3. Create OAuth credentials in Google Cloud Platform:

    • Create a new project in Google Cloud Console
    • Enable the Google Sheets API
    • Configure the OAuth consent screen
    • Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback)
    • Download the credentials and save as gcp-oauth.keys.json in the dist subdirectory
  4. Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary): npm run start

Usage

Sample config:

{ "mcpServers": { "google-sheets-mcp": { "command": "node", "args": [ "/{path_to_dir}/google-sheets-mcp/dist/index.js" ] } } }

Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.

Available Actions

ActionDescription
refresh_authRe-authenticate your Google Account when credentials expire
list_sheetsList all sheets/tabs in a Google Spreadsheet
create_sheetCreate a new sheet/tab in a Google Spreadsheet
create_spreadsheetCreate a new Google Spreadsheet
read_all_from_sheetRead all data from a specified sheet
read_headingsRead the column headings from a sheet
read_rowsRead specific rows from a sheet
read_columnsRead specific columns from a sheet
edit_cellEdit a single cell in a sheet
edit_rowEdit an entire row in a sheet
edit_columnEdit an entire column in a sheet
insert_rowInsert a new row at specified position
insert_columnInsert a new column at specified position
rename_sheetRename a sheet/tab in a spreadsheet
rename_docRename a Google Spreadsheet

License

MIT

Publicly Shared Threads0

Discover shared experiences

Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!

Share your threads to help others
Related MCPs5
  • Google Drive MCP Server
    Google Drive MCP Server

    Integrates with Google Drive via Model Context Protocol to enable searching, reading, and managing f...

    Added May 30, 2025
  • Google Workspace MCP Server
    Google Workspace MCP Server

    Provides Model Context Protocol (MCP) tools for seamless programmatic management of Gmail and Google...

    8 tools
    Added May 30, 2025
  • Kubectl MCP Tool
    Kubectl MCP Tool

    Enables AI assistants to interact with Kubernetes clusters via natural language using the Model Cont...

    Added May 30, 2025
  • MongoDB MCP Server for LLMs
    MongoDB MCP Server for LLMs

    Enables LLMs to seamlessly interact with MongoDB databases via Model Context Protocol, offering sche...

    Added May 30, 2025
  • Jira MCP Server
    Jira MCP Server

    Enables AI assistants to seamlessly interact with Jira via Model Context Protocol, offering project ...

    Added May 30, 2025