// MCP TOOL REFERENCE

GOOGLE SHEETS TOOLS

38 tools from the Google Sheets MCP Server, categorised by risk level.

View the Google Sheets policy → Token cost: 20,576 tokens →
// ALL 38 GOOGLE SHEETS TOOLS
READ 14 tools
Read GOOGLESHEETS_AGGREGATE_COLUMN_DATA Searches for rows where a specific column matches a value and performs mathematical operations on data from... Read GOOGLESHEETS_BATCH_GET Retrieves data from specified cell ranges in a Google Spreadsheet. Read GOOGLESHEETS_FIND_REPLACE Tool to find and replace text in a Google Spreadsheet. Use when you need to fix formula errors, update valu... Read GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE Finds a worksheet by its exact, case-sensitive title within a Google Spreadsheet; returns a boolean indicat... Read GOOGLESHEETS_GET_SHEET_NAMES Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sh... Read GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER Returns the spreadsheet at the given ID, filtered by the specified data filters. Use this tool when you nee... Read GOOGLESHEETS_GET_SPREADSHEET_INFO Retrieves comprehensive metadata for a Google Spreadsheet using its ID, excluding cell data. Read GOOGLESHEETS_GET_TABLE_SCHEMA This action is used to get the schema of a table in a Google Spreadsheet, call this action to get the schem... Read GOOGLESHEETS_LIST_TABLES This action is used to list all tables in a Google Spreadsheet, call this action to get the list of tables ... Read GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string,... Read GOOGLESHEETS_QUERY_TABLE This action is used to query a table in a Google Spreadsheet, call this action to query a table in a spread... Read GOOGLESHEETS_SEARCH_DEVELOPER_METADATA Tool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries... Read GOOGLESHEETS_SEARCH_SPREADSHEETS Search for Google Spreadsheets using various filters including name, content, date ranges, and more. Read GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER Tool to return one or more ranges of values from a spreadsheet that match the specified data filters. Use w...
WRITE 17 tools
Write GOOGLESHEETS_ADD_SHEET Adds a new sheet (worksheet) to a spreadsheet. Use this tool to create a new tab within an existing Google ... Write GOOGLESHEETS_APPEND_DIMENSION Tool to append new rows or columns to a sheet, increasing its size. Use when you need to add empty rows or ... Write GOOGLESHEETS_BATCH_UPDATE Updates a specified range in a Google Sheet with given values, or appends them as new rows if `first_cell_l... Write GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER Tool to update values in ranges matching data filters. Use when you need to update specific data in a Googl... Write GOOGLESHEETS_CREATE_CHART Create a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional re... Write GOOGLESHEETS_CREATE_GOOGLE_SHEET1 Creates a new Google Spreadsheet in Google Drive using the provided title. Write GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN Creates a new column in a Google Spreadsheet, requiring a valid `spreadsheet_id` and an existing `sheet_id`... Write GOOGLESHEETS_CREATE_SPREADSHEET_ROW Inserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheri... Write GOOGLESHEETS_FORMAT_CELL Applies text and background cell formatting to a specified range in a Google Sheets worksheet. Write GOOGLESHEETS_INSERT_DIMENSION Tool to insert new rows or columns into a sheet at a specified location. Use when you need to add empty row... Write GOOGLESHEETS_SET_BASIC_FILTER Tool to set a basic filter on a sheet in a Google Spreadsheet. Use when you need to filter or sort data wit... Write GOOGLESHEETS_SHEET_FROM_JSON Creates a new Google Spreadsheet and populates its first worksheet from `sheet_json`, which must be non-emp... Write GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO Tool to copy a single sheet from a spreadsheet to another spreadsheet. Use when you need to duplicate a she... Write GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND Tool to append values to a spreadsheet. Use when you need to add new data to the end of an existing table i... Write GOOGLESHEETS_UPDATE_SHEET_PROPERTIES Tool to update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, vis... Write GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES Tool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings. Use ... Write GOOGLESHEETS_UPSERT_ROWS Upsert rows - update existing rows by key, append new ones. Automatically handles column mapping and partia...
DESTRUCTIVE 6 tools
Destructive GOOGLESHEETS_CLEAR_BASIC_FILTER Tool to clear the basic filter from a sheet. Use when you need to remove an existing basic filter from a sp... Destructive GOOGLESHEETS_CLEAR_VALUES Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spread... Destructive GOOGLESHEETS_DELETE_DIMENSION Tool to delete specified rows or columns from a sheet in a Google Spreadsheet. Use when you need to remove ... Destructive GOOGLESHEETS_DELETE_SHEET Tool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a ... Destructive GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR Tool to clear one or more ranges of values from a spreadsheet. Use when you need to remove data from specif... Destructive GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR_BY_DATA_FILTER Clears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spre...
EXECUTE 1 tools
Execute GOOGLESHEETS_EXECUTE_SQL Execute SQL queries against Google Sheets tables. Supports SELECT, INSERT, UPDATE, and DELETE operations wi...
// RUNNING THIS SERVER

The managed route: connect Google Sheets through the PolicyLayer gateway — every tool call above is checked against your policy before it runs, with a full audit log.

DIRECT INSTALL (UNMANAGED) npx -y google-sheets-mcp
// FAQ
How many tools does the Google Sheets MCP server have? +

The Google Sheets MCP server exposes 38 tools across 4 categories: Read, Write, Destructive, Execute.

How do I enforce policies on Google Sheets tools? +

Route the Google Sheets server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard — they are enforced on every call before it reaches the server.

What risk categories do Google Sheets tools fall into? +

Google Sheets tools are categorised as Read (14), Write (17), Destructive (6), Execute (1). Each category has a recommended default policy.

Let agents act without letting them run wild.

Route your MCP servers through PolicyLayer and every tool call is checked against your policy before it runs — allow, deny, or require approval. Per-identity grants. Full audit log. Live in minutes.

SECURE YOUR MCP →

Free to start. No card required.

4,600+ MCP servers and 31,000+ tools scanned and risk-classified.

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.