AcademyMCP serversProductivity

MCP Google Sheets Server

Finance, operations and reporting teams that keep data in Google Sheets and want an assistant to read and update it.

  • Recommendedour rating
  • 100gitHub stars
  • MITlicence
  • 7 days agolast update
claude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=your-project-id -e GOOGLE_APPLICATION_CREDENTIALS=/absolute/path/to/service-account-key.json -- npx -y mcp-gsheets@latest
README.md

Loading the file...

What it does

An MCP server for the Google Sheets API. It lets an assistant in Claude Code, Claude Desktop or Cursor read, write and manage spreadsheets, including batch operations, formatting, charts and conditional formatting. Credentials can come from a file or a JSON string.

Use cases

  1. 01Read a sheet and summarize its contents
  2. 02Append new rows from a list of records
  3. 03Apply formatting and conditional rules to a report

Questions about
MCP Google Sheets Server.

What is MCP Google Sheets Server used for?

Finance, operations and reporting teams that keep data in Google Sheets and want an assistant to read and update it. An MCP server for the Google Sheets API. It lets an assistant in Claude Code, Claude Desktop or Cursor read, write and manage spreadsheets, including batch operations, formatting, charts and conditional formatting. Credentials can come from a file or a JSON string.

How do I install MCP Google Sheets Server?

Run this in your terminal: claude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=your-project-id -e GOOGLE_APPLICATION_CREDENTIALS=/absolute/path/to/service-account-key.json -- npx -y mcp-gsheets@latest

Is MCP Google Sheets Server open source?

Yes. The code is on GitHub (freema/mcp-gsheets) under the MIT licence.

Is MCP Google Sheets Server safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.