Google Sheets MCP Server

Example Use Cases

• 1

  Programmatically create and populate new Google Sheets as part of a workflow (reports, exports, or data capture).

• 2

  Read, update, and format ranges or write formulas in existing spreadsheets to automate data processing and presentation.

• 3

  Manage sheet structure and metadata—adding or deleting sheets, listing available files, or searching for specific spreadsheets in Drive.

Description

This repository implements a Model Context Protocol server that exposes Google Sheets operations (create sheets, read/write data, format ranges, add/delete sheets, write formulas, and list/search files) to Claude Desktop. It handles OAuth2 authentication with Google, integrates with the Sheets and Drive APIs, and provides callable tools for agent-driven spreadsheet workflows. The server is intended to simplify automation and agent interactions with spreadsheets without building direct API integrations inside the agent.