# Google Sheets MCP

> Google Sheets connects your AI agent directly to Google Sheets. It lets you treat spreadsheet data like a chat conversation—you ask it to pull KPIs from specific ranges, append new client leads, or reorganize entire tabs without ever opening the actual program. This MCP handles everything from reading multiple data sets at once to creating entirely new spreadsheets on demand.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Tags:** spreadsheet, data-entry, row-manipulation, csv-export, data-sync, automation

## Description

Your AI agent can now read and write data directly into Google Sheets using natural language commands. You don't need to remember formulas or manually copy ranges anymore; you just tell your client what you want done, and it handles the spreadsheet logic for you. Need project updates logged? Tell it to append a row with today’s task status and assignees. Want to analyze sales data across three different tabs? Your agent can fetch multiple non-contiguous ranges instantly so you get all the numbers in one go. It even manages the sheet structure, letting you create new spreadsheets or add whole tabs just by talking to it. This integration is available through Vinkius, giving your AI client access to this powerful tool alongside thousands of others.

## Tools

### update_sheet_values
Changes the content of values within a specified range on any sheet.

### delete_sheet
Removes an entire tab or sheet from your Google Spreadsheet file.

### get_sheet_values
Reads and returns the content of values from a specific, targeted range on a sheet.

### get_spreadsheet
Retrieves basic metadata about the entire spreadsheet file, including all sheets it contains.

### add_sheet
Creates and adds a completely new, blank tab to your existing workbook.

### append_sheet_values
Adds an entirely new row of data to the bottom of an existing table structure.

### batch_get_values
Reads values from multiple, distinct ranges within one request for comprehensive data analysis.

### batch_update_spreadsheet
Applies bulk updates to the formatting or overall structure of a spreadsheet section.

### clear_sheet_values
Empties all values from a specific, designated range without deleting the sheet itself.

### create_spreadsheet
Generates and creates an entirely new Google Spreadsheet file in your drive.

## Prompt Examples

**Prompt:** 
```
Read the data in range A1:C10 from spreadsheet ID '1abcxyz'.
```

**Response:** 
```
Fetching data... Here are the values from A1:C10:
- [ Name | Department | Q1 Sales ]
- [ John Doe | Marketing | $45,000 ]
- [ Jane Smith | Sales | $82,000 ]...
```

**Prompt:** 
```
Append a new row to the 'Q1 Sales' sheet with the values: 'Mike T', 'Engineering', '$12,000'.
```

**Response:** 
```
Appending data... Success! I've appended the row ['Mike T', 'Engineering', '$12,000'] to the next available line.
```

**Prompt:** 
```
Create a new sheet called 'Finances 2026' and populate the headers.
```

**Response:** 
```
Tab successfully instantiated in spreadsheet ID '1abcxyz'. The empty array logic has been set.
```

## Capabilities

### Extracting specific data ranges
You can read values from precise areas like 'Sheet1!A1:D10' or gather multiple separate ranges for immediate analysis.

### Adding and modifying rows
The agent will append a new row of data to an existing table, or overwrite specific cells with updated values.

### Managing sheet structure
You can create brand-new spreadsheets, add entirely new tabs to existing files, and even delete unwanted sheets.

### Batch data retrieval
Fetch values from multiple, varied ranges simultaneously, perfect for combining metrics from different sources.

### Applying structural updates
Execute batch requests to programmatically change the formatting or underlying structure of a spreadsheet section.

## Use Cases

### Quarterly Financial Review
A financial analyst needs to pull Q1 sales figures from three different regional sheets. Instead of running `get_sheet_values` multiple times, they ask the agent via their client to use `batch_get_values` across all three required ranges. The result is a single, combined report summary.

### Onboarding New Clients
A marketing coordinator receives 20 new leads and needs them added to the master tracking sheet. They instruct the agent to use `append_sheet_values` repeatedly with the lead data, ensuring all columns are populated in bulk.

### Project Status Cleanup
A project manager finds an old tracker full of irrelevant notes and needs a clean slate. The agent uses `clear_sheet_values` on the 'Notes' tab to wipe out all data, leaving only the headers intact for re-use.

### Structural Data Audit
A team lead realizes they need a completely new project area. They ask their agent to use `create_spreadsheet` and name it 'Project X Tracker', instantly generating the necessary file in their drive.

## Benefits

- Stop writing boilerplate formulas. Use the agent to calculate and update data directly, specifying ranges like 'Sheet1!A1:D10' without needing complex syntax.
- Log new entries instantly with `append_sheet_values`. Simply tell your client, 'Add Mike T to the Q3 Leads sheet,' and it handles the row creation.
- Need quick data insights? Use `batch_get_values` to pull metrics from five different tabs at once, giving you a consolidated view without manual copy-pasting.
- Managing files is easy. If you need a new tracker, use `create_spreadsheet`. Need a fresh section? Command the agent to execute `add_sheet` and it'll appear in your workbook.
- Updating existing records is precise. You can target specific cells using `update_sheet_values`, ensuring only the required data gets modified while leaving everything else untouched.

## How It Works

The bottom line is that your agent translates plain English requests into structured API calls against your Google Sheets account.

1. First, subscribe to this MCP and enter your Google OAuth Client ID and Secret.
2. Next, complete the secure Google authorization flow to link your account credentials.
3. After setup, you can start giving conversational commands to your AI client to manipulate data.

## Frequently Asked Questions

**How do I read specific data ranges using the Google Sheets MCP?**
You use `get_sheet_values` to target exact areas. You just tell your agent, 'Read values from Sheet2!B5:F10,' and it pulls that precise block of data for you.

**Can I update multiple cells at once with Google Sheets MCP?**
Yes, if you need to change a few scattered pieces of information across different spots, use `update_sheet_values` and specify all the ranges in your command.

**Does Google Sheets MCP let me create new spreadsheets?**
Absolutely. Use the `create_spreadsheet` tool to instantly generate a brand-new, blank sheet file directly into your connected Google Drive space.

**What if I need data from multiple tabs? Is it possible with this MCP?**
Yes. The `batch_get_values` tool is built for this; you can request values from several non-contiguous ranges in one single API call.

**How do I add a whole new tab to an existing workbook using Google Sheets MCP?**
You use the `add_sheet` tool. Just ask your agent to create a new sheet and give it the name you want, and the tab will appear instantly.