Google Sheets MCP server

Connect Google Sheets to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Google Sheets MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the delete spreadsheet tool in Google Sheets
  • Use the format cells tool in Google Sheets
  • Use the create pivot table tool in Google Sheets
  • Use the manage protected ranges tool in Google Sheets
  • Use the batch update tool in Google Sheets
  • Use the create spreadsheet tool in Google Sheets

How teams use Google Sheets with agents

Sheets is the shared database for many teams: trackers, forecasts and lists that nobody moved into a real system. An agent can read ranges, write results back and build charts or pivot tables on top of them.

Update a tracker

Write new rows or status changes into a pipeline or project sheet using A1 ranges or named ranges.

Quick analysis

Read a range, compute totals or trends, and add a pivot table or chart to the same spreadsheet.

Clean imports

Clear stale ranges, set data validation and format cells after loading data from another system.

Protect what matters

Lock formula columns with protected ranges so the agent and teammates only edit input cells.

Tools to start with

  • Read Cells: Reads one or several ranges in a single call.
  • Batch Update: Applies many structural changes at once.
  • Create Pivot Table: Summarises a range without leaving the sheet.

Sign-in and permissions

Sheets offers three sign-in options: OAuth for acting as a person, a service account for shared automation, and an API key for public sheets only. With a service account, share each spreadsheet with its email address, because it has no access of its own.

Sign-in options on Metorial: Service Account, API Key, OAuth.

Supported Tools

delete_spreadsheet

Delete Spreadsheet

Permanently deletes a spreadsheet from Google Drive. This action cannot be undone. Requires Drive file access.

format_cells

Format Cells

Applies formatting to cells in a spreadsheet range. Supports text styling (bold, italic, font, color), cell backgrounds, number formats, text alignment, borders, and text wrapping. Multiple formatting options can be applied in a single call.

create_pivot_table

Create Pivot Table

Creates a pivot table that summarizes data from a source range. Configure row and column groupings, value aggregations (sum, count, average, etc.), and filters. The pivot table is placed at a specified cell location.

manage_protected_ranges

Manage Protected Ranges

Add or remove protection on cell ranges to prevent modifications. Optionally specify which users can still edit the protected range. Can protect an entire sheet or a specific range within a sheet.

batch_update

Batch Update

Executes multiple spreadsheet update operations atomically in a single request. Supports any combination of operations such as formatting, adding/removing sheets, creating charts, merging cells, adding conditional formatting, and more. Operations are applied in order. Use this for complex updates that need to be applied together, or when you need to perform operations not covered by other tools (e.g., conditional formatting rules, merge cells, add charts, pivot tables, filter views).

create_spreadsheet

Create Spreadsheet

Creates a new Google Sheets spreadsheet with optional initial sheet tabs. Returns the spreadsheet ID and URL for immediate use.

create_filter_view

Create Filter View

Creates a filter view that provides a filtered perspective of data without affecting what other users see. Configure filter criteria per column including value-based and condition-based filters.

update_spreadsheet

Update Spreadsheet

Updates the properties of a Google Sheets spreadsheet, such as its title, locale, or time zone.

create_chart

Create Chart

Creates an embedded chart in a spreadsheet. Supports bar, line, pie, area, scatter, and column chart types. Configure the data source range, chart position, title, and axis labels.

manage_named_ranges

Manage Named Ranges

Add, update, or delete named ranges in a spreadsheet. Named ranges assign a custom name to a cell range, making it easier to reference in formulas and API calls.

get_spreadsheet

Get Spreadsheet

Retrieves metadata and properties of a Google Sheets spreadsheet, including its title, locale, list of sheets/tabs, and named ranges. Use this to inspect spreadsheet structure before performing operations.

manage_sheets

Manage Sheets

Add, delete, duplicate, update, or copy individual sheet tabs. Rename a tab by using action "update" with the numeric sheetId and new title. Use "copy_to_spreadsheet" to copy a tab into another spreadsheet. Configure sheet properties like grid size, frozen rows/columns, tab color, and visibility.

read_cells

Read Cells

Reads values from one or more ranges in a spreadsheet. Supports A1 notation (e.g., "Sheet1!A1:B10") and named ranges. Can read a single range or multiple ranges at once. Returns values as formatted strings, raw values, or formulas.

clear_cells

Clear Cells

Clears all values from a specified range in a spreadsheet while preserving formatting. Use this to remove cell contents without deleting the cells themselves.

merge_cells

Merge Cells

Merge or unmerge a range of cells in a spreadsheet. Supports merging all cells into one, merging by rows, or merging by columns.

set_data_validation

Set Data Validation

Sets data validation rules on a range of cells. Restrict input to dropdown lists, number ranges, date constraints, checkbox, or custom formulas. Can show warnings or reject invalid input.

write_cells

Write Cells

Writes values to one or more ranges in a spreadsheet. Supports single-range writes, multi-range batch writes, and appending data to the end of a table. Values can be written as raw data or interpreted as user input (parsing dates, formulas, etc.).

Connect Google Sheets to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Google Sheets in Metorial. In your Metorial portal, enable the Google Sheets MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Google Sheets tools.

Run Google Sheets through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Google Sheets and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Google Sheets tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Google Sheets

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

Google Drive

Upload, download, create, copy, move, rename, trash, and permanently delete files and folders in Google Drive. Search for files using complex queries filtering by name, MIME type, owner, modification date, labels, and other metadata. Share files and folders with specific users, groups, or domains with role-based permissions (owner, writer, commenter, reader). Manage shared drives and their members. Export Google Workspace files (Docs, Sheets, Slides) to standard formats like PDF, DOCX, and XLSX. Track file revision history and restore earlier versions. Create, read, update, and delete threaded comments and replies on files. Read label definitions and search files by label. Browse the Drive apps installed for your account. Store app-specific data in a hidden per-user folder.

Technical notes for Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

Frequently asked questions

Common questions about connecting Google Sheets to AI agents with Metorial.

  1. How many tools does the Google Sheets MCP server have?
    The Google Sheets MCP server exposes 17 tools, including Delete Spreadsheet, Format Cells, Create Pivot Table. Each one is governed and traced through Metorial.
  2. Yes. Google Sheets has 2 triggers you can use to start workflows from Google Sheets events.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Google Sheets MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Google Sheets and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Google Sheets MCP server yourself or use the hosted gateway.

Connect Google Sheets to production AI agents

See how Metorial gives your team governed access to Google Sheets, with tracing and security controls built in.