Google Sheets logo

Google Sheets

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

Available tools

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"

How it works

1. Install

One-click install from the Simtheory store.

2. Connect

Authorize access to your Google Sheets account.

3. Use

Your AI can now interact with Google Sheets.

Install

Log in if you already have an account.

Details

Version 1.0.0
Updated Apr 21, 2026
Category Google workspace
Publisher Google

Features

Cloud hosted — no setup required
Secure authentication
Automatic updates
Works with all AI models

Ready to use Google Sheets?

Sign up for Simtheory and install this MCP directly into your workspace.

Get Started