google-sheets-mcp

by Warren McBrideUpdated May 4, 2026

Converts any Google Sheet into a REST API, enabling read, query, append, update, and delete operations on rows via MCP tools. Developers integrate Sheets as a backend database in applications; data analysts automate data ingestion and reporting without Apps Script.

google-sheets
rest-api
crud-operations
|

Overview

The google-sheets-mcp server transforms Google Sheets into a RESTful API accessible via MCP tools. It supports full CRUD operations on sheet rows, treating spreadsheets as a lightweight, shareable database without needing Google Apps Script or external hosting.

Key Capabilities

  • read: Retrieves specific rows or entire ranges from a sheet by ID or range.
  • query: Filters rows using conditions like column values, dates, or text matches.
  • append: Adds new rows to the end of a sheet with provided data.
  • update: Modifies cells or entire rows in place by row index or key.
  • delete: Removes rows based on index, range, or query conditions.

These tools use standard HTTP-like requests over MCP, with authentication via Google OAuth.

Use Cases

  1. App Backend: A web app uses read and query to fetch user-submitted data from a Sheet acting as a database, displaying filtered results in real-time.

  2. Data Pipeline: ETL process appends scraped web data to a Sheet, then querys for analysis before updateing summaries in another tab.

  3. Inventory Sync: E-commerce tool deletes sold items via query on stock levels and updates quantities across linked Sheets.

  4. Reporting Automation: Daily cron job reads sales Sheet, querys for trends, and appends aggregates to a master report Sheet.

Who This Is For

Developers building prototypes or MVPs needing quick data storage; data analysts scripting workflows in Python/Node.js; teams sharing live data via Sheets without full databases like Airtable or Supabase.