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