Install

Quick Info

Secure cloud hosting
Secure authentication
1.0.0
Oct 07, 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.

Users also installed these MCPs

Google Docs

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

Task planner

Your very own personal project manager, built with love by us, to keep all your brilliant ideas organized! ❤️ Create projects, add tasks, update their status, and view your progress.

Todoist

Connect your Todoist account to manage tasks and projects with natural language.

Linear

Connect your Linear workspace for issue tracking and project management.

Helpscout

Helpscout AI empowers support agents with intelligent automation, instant conversation context, and streamlined communication to resolve customer queries faster and more accurately.

Notion

Connect your Notion workspace for notes, tasks, and databases.

Ready to use Google Sheets MCP Server?

Get Started with Simtheory

WORKSPACE

CONTEXT

SKILLS