Skip to main content
Glama
Sign In
enesjakozh

Google Sheets MCP

by mkummer225
GitHub
JavaScript
MIT License
23
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

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:
  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

This server cannot be installed

-
security - not tested
-
license - not tested
-
quality - not tested

A Model Context Protocol (MCP) connector that allows AI agents to directly interact with Google Sheets, enabling creation, reading, and modification of spreadsheets through natural language.

  1. Demo
    1. Setup
      1. Usage
        1. Available Actions
          1. License

            Related MCP Servers

            • Workers MCP Demo

              akazwz
              -
              security
              F
              license
              -
              quality
              A demonstration project that uses Cloudflare Workers MCP to create custom AI tools that can be integrated with Claude, Cursor, and other AI assistants supporting the Model Context Protocol.
              Last updated 2 months ago
              26
              TypeScript

            • MCP Server

              GobinFan
              -
              security
              F
              license
              -
              quality
              Implements the Model Context Protocol (MCP) to provide AI models with a standardized interface for connecting to external data sources and tools like file systems, databases, or APIs.
              Last updated 2 months ago
              16
              Python
              • Apple
              • Linux

            • Claude MCP x Google Docs

              a-bonus
              -
              security
              A
              license
              -
              quality
              A Model Context Protocol server that enables AI assistants like Claude to read from, append to, and format text in Google Documents programmatically.
              Last updated 3 days ago
              11
              TypeScript
              MIT License
              • Linux
              • Apple

            • Createve.AI Nexus

              spgoodman
              -
              security
              -
              license
              -
              quality
              An open-source implementation of the Model Context Protocol (MCP) that bridges AI agents with enterprise systems, enabling secure access to real-world data and capabilities.
              Last updated a month ago
              1
              Python
              Apache 2.0

            View all related MCP servers

            Appeared in Searches

            ID: j948t2wyu6