Google Sheets API MCP Server

What is Google Sheets API MCP Server?

A comprehensive Model Context Protocol (MCP) server for interacting with the Google Sheets API. It provides tools and resources for managing spreadsheets, sheets, values, and developer metadata, intended for developers building AI or automation workflows that need to read and write Google Sheets data.

How to use Google Sheets API MCP Server?

Clone the repository, install dependencies with npm install, and create a .env file with your Google OAuth 2.0 credentials (CLIENT_ID, CLIENT_SECRET, REDIRECT_URI, REFRESH_TOKEN). Run the server with npm start, or use npm run dev for development mode and npm run inspect to test with the MCP Inspector.

Key features of Google Sheets API MCP Server

• Create, read, update, and delete spreadsheets
• Manage sheets within spreadsheets
• Read, write, append, and clear cell values
• Work with developer metadata
• Access spreadsheet data through MCP resources

Use cases of Google Sheets API MCP Server

• Automating spreadsheet creation and population
• Reading and updating cell ranges in existing sheets
• Managing sheet properties and metadata programmatically
• Copying sheets between different spreadsheets
• Batch reading or writing values across multiple ranges

FAQ from Google Sheets API MCP Server

What are the prerequisites to use this server?

Node.js 16 or higher, a Google Cloud Platform project with the Google Sheets API enabled, and OAuth 2.0 credentials (client ID, client secret, refresh token).

How does authentication work?

The server uses OAuth 2.0. You must provide a CLIENT_ID, CLIENT_SECRET, REDIRECT_URI, and a REFRESH_TOKEN in the .env file.

What tools are available?

Tools for spreadsheet management (create, get, batch update), sheet management (copy, add, delete, update properties), values management (get, update, append, clear, batch get/update), and developer metadata (get, create, update, delete).

What resources does the server expose?

Resources follow the pattern sheets://spreadsheet/{spreadsheetId}, sheets://spreadsheet/{spreadsheetId}/sheet/{sheetName}, sheets://spreadsheet/{spreadsheetId}/values/{range}, and sheets://spreadsheet/{spreadsheetId}/metadata.

What license is this server distributed under?

MIT.