Google Spreadsheet MCP

Example Use Cases

• 1

  Read tabular data from Google Sheets and render it as Markdown tables for reports or chat responses.

• 2

  List or find sheet names and sheet URLs inside a spreadsheet to navigate or reference specific sheets.

• 3

  Upload CSV files into Google Sheets or copy contents between sheets to automate data ingestion and replication.

Description

This open-source MCP server provides programmatic operations for Google Spreadsheets, including fetching sheet data as Markdown tables, retrieving header/column names, discovering sheet URLs, listing all sheets, uploading CSV files, and copying sheet contents. It is designed for tabular sheets with the first row as column headers and assumes no duplicate column names. Authentication uses gspread/OAuth2, so a Google account and appropriate credentials are required. Useful for automating spreadsheet access and manipulation from agents or other automation tooling.

Capabilities(6 total)