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 02, 2025

Google Sheets

By: Google Productivity

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.

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