Skip to content
Kitbay
Submit
MCP server

google-sheets-mcp

Runs locallyMITUpdated on Apr 7, 2025138GitHub starsCan change dataNeeds an API key

A Node.js MCP server for Google Sheets that you clone, build and run locally.

What it does

A Node.js MCP server for Google Sheets that you clone, build and run locally. It can create a spreadsheet, list, add and rename sheet tabs, rename the spreadsheet, read a whole sheet, its headings, or chosen rows and columns, edit a cell, a row or a column, and insert rows or columns at a position. Authentication uses your own Google Cloud desktop OAuth client: you enable the Sheets API, save the client file in the build folder, and the server asks you to sign in to Google when needed, with a tool to re-authenticate when credentials expire. The README gives a generic mcpServers config.

Capabilities

  • Create spreadsheets and sheet tabs
  • Read rows, columns or a whole sheet
  • Edit cells, rows and columns
  • Insert rows and columns