MCP Google Sheets Server

What is MCP Google Sheets Server?

MCP Google Sheets Server is a Model Context Protocol (MCP) server that integrates the Google Sheets API directly into MCP clients such as Claude Desktop. It enables reading, writing, and managing Google Sheets documents programmatically. Designed for developers and users who need to control spreadsheets via natural language or automation in an MCP environment.

How to use MCP Google Sheets Server?

Requires Node.js 18+, a Google Cloud project with the Sheets API enabled, and a service account JSON key. Install via git clone, then run npm install and npm run build. Use the interactive setup script (npm run setup) or manually configure your MCP client (e.g., Claude Desktop) by adding the server configuration with absolute paths to the built script and environment variables for GOOGLE_PROJECT_ID and GOOGLE_APPLICATION_CREDENTIALS. After configuration, restart your MCP client.

Key features of MCP Google Sheets Server

• Read cell values, ranges, and metadata from spreadsheets
• Write, update, append, and clear cell data
• Add, delete, duplicate, and copy sheets
• Format cells with colors, fonts, alignment, and borders
• Merge and unmerge cells; add conditional formatting rules

Use cases of MCP Google Sheets Server

• Automatically populate a spreadsheet from chat prompts
• Read and summarize spreadsheet data in natural language
• Manage sheet structure (add/delete sheets) from an MCP client
• Apply consistent formatting across multiple ranges
• Check permissions before performing operations

FAQ from MCP Google Sheets Server

What are the prerequisites?

Node.js v18 or higher, a Google Cloud project with the Sheets API enabled, and a service account JSON key file.

How do I authenticate with Google Sheets?

Create a service account in Google Cloud Console, download its JSON key, and share your spreadsheet with the service account email (Editor permissions). Set the GOOGLE_APPLICATION_CREDENTIALS environment variable to the absolute path of that key.

How do I find a spreadsheet ID?

The spreadsheet ID is the long string in the sheet’s URL: https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit.

What tools does MCP Google Sheets Server provide?

It offers tools for reading data (sheets_get_values, sheets_batch_get_values, sheets_get_metadata, sheets_check_access), writing data (sheets_update_values, sheets_batch_update_values, sheets_append_values, sheets_clear_values), sheet management (sheets_insert_sheet, sheets_delete_sheet, sheets_duplicate_sheet, sheets_copy_to, sheets_update_sheet_properties), and cell formatting (sheets_format_cells, sheets_update_borders, sheets_merge_cells, sheets_unmerge_cells, sheets_add_conditional_formatting).

How can I debug connection issues?

Ensure you are using the built version (dist/index.js), that the Node.js path in your MCP client config is correct, and check the client logs. You can also run npm run inspector to debug the MCP server.