Google Sheets MCP Server

Example Use Cases

• 1

  Read and query spreadsheet data from Google Sheets for downstream analysis or context retrieval.

• 2

  Programmatically add, update, or delete rows and columns in a spreadsheet as part of an automated workflow.

• 3

  Transform or compute new columns (e.g., combine names or reformat dates) and integrate with Claude Desktop for conversational interactions.

Description

This MCP server provides endpoints to fetch and update Google Sheets, including adding, editing, and deleting rows and columns, renaming columns, and applying transformations. It uses proper async implementation for improved performance and supports both service-account and OAuth authentication methods. It is designed to integrate with Claude Desktop and other agents to enable automated spreadsheet workflows and data analysis.

Capabilities(24 total)