Google Sheets MCP Server

What is Google Sheets MCP Server?

Google Sheets MCP Server is a Model Context Protocol (MCP) server written in Go that provides comprehensive tools for interacting with Google Spreadsheets.

How to use Google Sheets MCP Server?

To use the server, build the project using make build, set up Google API credentials, configure the environment variables, and run the server in either Stdio or SSE mode.

Key features of Google Sheets MCP Server?

• Sheet Data: Get/update cell data, formulas, and perform batch operations.
• Sheet Management: Create, rename, copy sheets, and add rows/columns.
• Spreadsheet Management: Create, list, and share spreadsheets.
• Multiple Authentication Methods: Supports service account, OAuth2, and Base64 encoded service account.

Use cases of Google Sheets MCP Server?

1. Automating data entry and updates in Google Sheets.
2. Managing multiple spreadsheets programmatically.
3. Integrating Google Sheets with other applications using the MCP protocol.

FAQ from Google Sheets MCP Server?

• What programming language is used?

The server is written in Go.

• What authentication methods are supported?

It supports service accounts, OAuth2, and Base64 encoded service accounts.

• Is there a detailed setup guide?

Yes, detailed instructions are provided in the documentation.