Google Sheets MCP

Example Use Cases

• 1

  Read and query entire spreadsheets or specific rows and columns to extract structured data for tasks or analysis.

• 2

  Create and modify sheets, insert rows/columns, edit cells, and rename sheets or documents as part of automated workflows.

• 3

  Integrate Google Sheets into larger automation or conversational pipelines, performing spreadsheet operations after user OAuth authentication.

Description

This MCP server provides an interface for AI agents to interact directly with Google Sheets: list sheets, create spreadsheets/tabs, read rows/columns/headings, and edit or insert cells/rows/columns. It uses Google OAuth credentials and the Sheets API so agents can operate on user-owned spreadsheets after authentication. The project is a self-hosted, open-source connector useful for integrating spreadsheet workflows into agent-driven automation.