38 tools from the Google Sheets MCP Server, categorised by risk level.
View the Google Sheets policy →GOOGLESHEETS_AGGREGATE_COLUMN_DATA Searches for rows where a specific column matches a value and performs mathematical operations on data from another column. GOOGLESHEETS_BATCH_GET Retrieves data from specified cell ranges in a Google Spreadsheet. GOOGLESHEETS_FIND_REPLACE Tool to find and replace text in a Google Spreadsheet. Use when you need to fix formula errors, update values, or perform bulk text replacements ac... GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE Finds a worksheet by its exact, case-sensitive title within a Google Spreadsheet; returns a boolean indicating if found and the complete metadata o... 2/5 GOOGLESHEETS_GET_SHEET_NAMES Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before further operations. GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER Returns the spreadsheet at the given ID, filtered by the specified data filters. Use this tool when you need to retrieve specific subsets of data f... GOOGLESHEETS_GET_SPREADSHEET_INFO Retrieves comprehensive metadata for a Google Spreadsheet using its ID, excluding cell data. 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 schema of a table in a spreadsheet BEFORE YOU... GOOGLESHEETS_LIST_TABLES This action is used to list all tables in a Google Spreadsheet, call this action to get the list of tables in a spreadsheet. Discover all tables in... GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string, searching within a specified A1 notatio... 3/5 GOOGLESHEETS_QUERY_TABLE This action is used to query a table in a Google Spreadsheet, call this action to query a table in a spreadsheet. Execute SQL-like SELECT queries a... 2/5 GOOGLESHEETS_SEARCH_DEVELOPER_METADATA Tool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries based on filters. GOOGLESHEETS_SEARCH_SPREADSHEETS Search for Google Spreadsheets using various filters including name, content, date ranges, and more. 2/5 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 when you need to retrieve specific data s... 2/5 GOOGLESHEETS_ADD_SHEET Adds a new sheet (worksheet) to a spreadsheet. Use this tool to create a new tab within an existing Google Sheet, optionally specifying its title, ... 2/5 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 columns to an existing sheet. 2/5 GOOGLESHEETS_BATCH_UPDATE Updates a specified range in a Google Sheet with given values, or appends them as new rows if `first_cell_location` is omitted. Auto-expands grid f... 2/5 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 Google Sheet based on criteria rather than fi... 2/5 GOOGLESHEETS_CREATE_CHART Create a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements: - Provide either a simple ch... 2/5 GOOGLESHEETS_CREATE_GOOGLE_SHEET1 Creates a new Google Spreadsheet in Google Drive using the provided title. 2/5 GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN Creates a new column in a Google Spreadsheet, requiring a valid `spreadsheet_id` and an existing `sheet_id`; an out-of-bounds `insert_index` may ap... 2/5 GOOGLESHEETS_CREATE_SPREADSHEET_ROW Inserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatting from the row above. 2/5 GOOGLESHEETS_FORMAT_CELL Applies text and background cell formatting to a specified range in a Google Sheets worksheet. 2/5 GOOGLESHEETS_INSERT_DIMENSION Tool to insert new rows or columns into a sheet at a specified location. Use when you need to add empty rows or columns within an existing Google S... 2/5 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 within a specific range on a sheet. 2/5 GOOGLESHEETS_SHEET_FROM_JSON Creates a new Google Spreadsheet and populates its first worksheet from `sheet_json`, which must be non-empty as its first item's keys establish th... 2/5 GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO Tool to copy a single sheet from a spreadsheet to another spreadsheet. Use when you need to duplicate a sheet into a different spreadsheet. 2/5 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 in a Google Sheet. 2/5 GOOGLESHEETS_UPDATE_SHEET_PROPERTIES Tool to update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab color, or grid properties. ... 2/5 GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES Tool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings. Use when you need to modify the overall conf... 2/5 GOOGLESHEETS_UPSERT_ROWS Upsert rows - update existing rows by key, append new ones. Automatically handles column mapping and partial updates. Use for: CRM syncs (match Lea... 2/5 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 specific sheet within a Google Spreadsheet. 4/5 GOOGLESHEETS_CLEAR_VALUES Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an e... 4/5 GOOGLESHEETS_DELETE_DIMENSION Tool to delete specified rows or columns from a sheet in a Google Spreadsheet. Use when you need to remove a range of rows or columns. 4/5 GOOGLESHEETS_DELETE_SHEET Tool to delete a sheet (worksheet) from a spreadsheet. Use when you need to remove a specific sheet from a Google Sheet document. 4/5 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 specific cells or ranges while keeping formatt... 4/5 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 spreadsheet ID and one or more DataFilters. ... 4/5 The Google Sheets MCP server exposes 38 tools across 4 categories: Read, Write, Destructive, Execute.
Use Intercept, the open-source MCP proxy. Write YAML rules for each tool — rate limits, argument validation, or deny rules — then run Intercept in front of the Google Sheets server.
Google Sheets tools are categorised as Read (14), Write (17), Destructive (6), Execute (1). Each category has a recommended default policy.
Open source. One binary. Zero dependencies.
npx -y @policylayer/intercept