Background decoration
Google Sheets logo
Install

Log in if you already have an account.

Quick Info

  • Secure cloud hosting
  • Secure authentication
  • 1.0.0
  • Oct 16, 2025

Google Sheets

By: Google Google workspace

Read, write, format, and analyze data in Google Sheets with full spreadsheet and cell-level control

What can this MCP do?

Add Chart

Adds a chart to a sheet based on specified data. Run without `confirm=True` for a dry run.

Append to Sheet

Adds one or more rows to the end of a table in a sheet. Run without `confirm=True` for a dry run.

Clear Range

Clears all data from a specified range of cells. Run without `confirm=True` for a dry run.

Create Sheet

Creates a new sheet (tab) in a spreadsheet. Run without `confirm=True` for a dry run.

Create Spreadsheet

Creates a new Google Spreadsheet.

Delete Sheet

Deletes a sheet (tab) from a spreadsheet. Run without `confirm=True` for a dry run.

Get Spreadsheet Properties

Gets metadata about a spreadsheet, including its sheets (tabs), timezone, and locale.

List Sheets

Lists all the sheets (tabs) in a given spreadsheet.

Read Range

Reads a range of cells from a sheet.

Update Range

Writes data to a specified range of cells, overwriting existing data. Run without `confirm=True` for a dry run.

Example prompts:

Read the first 5 rows from my "Q4 Sales" spreadsheet
Add a new row to Sheet1 with the data: ["New Product", 500, "In Stock"]
Create a pie chart from the data in A1:B10 of my "Marketing" sheet
What are the names of the tabs in my spreadsheet?
Create a new spreadsheet named "Project Tracker"
Clear all data from the range D1:F10 in "Sheet2"
Update cell C2 in "Inventory" to "Out of Stock"

Copy these prompts to get started quickly with Google Sheets in your Simtheory workspace.

How It Works

1. Install the MCP

Install Google Sheets from your Simtheory workspace with one click.

2. Connect Your Account

Securely authorize access to your Google Sheets account.

3. Start Using

Your AI can now interact with Google Sheets on your behalf.

Users also installed these MCPs

Gmail logo

Gmail

Read, compose, send, and manage all your email from Gmail with comprehensive inbox control
Google Docs logo

Google Docs

Create, edit, format, and manage Google Docs documents with full document control and rich text formatting
Google Drive logo

Google Drive

Upload, download, search, share, and manage all your files and folders in Google Drive with comprehensive file control
Google Calendar logo

Google Calendar

Manage your Google Calendar events, create meetings, set reminders, and organize your schedule with full calendar control
Google Search logo

Google Search

Search the web with Google grounded search

Ready to use Google Sheets MCP Server?

Sign up for Simtheory and install this MCP directly into your workspace to start leveraging its capabilities.

Get Started with Simtheory