# Google Sheets (verified) Read, write, and format spreadsheet data. Manage sheets, run formulas, and collaborate on structured data in real time. ## Quick Start ```bash # Connect this server (installs CLI if needed) npx -y @smithery/cli@latest mcp add googlesheets # Browse available tools npx -y @smithery/cli@latest tool list googlesheets # Get full schema for a tool npx -y @smithery/cli@latest tool get googlesheets GOOGLESHEETS_ADD_SHEET # Call a tool npx -y @smithery/cli@latest tool call googlesheets GOOGLESHEETS_ADD_SHEET '{}' ``` ## Direct MCP Connection Endpoint: `https://googlesheets.run.tools` ## Tools (38) - `GOOGLESHEETS_ADD_SHEET` — Adds a new sheet (worksheet) to a spreadsheet. Use this tool to create a new tab within an existing Google Sheet, optio… - `GOOGLESHEETS_AGGREGATE_COLUMN_DATA` — Searches for rows where a specific column matches a value and performs mathematical operations on data from another col… - `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 a… - `GOOGLESHEETS_BATCH_GET` — Retrieves data from specified cell ranges in a Google Spreadsheet. - `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 … - `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 base… - `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… - `GOOGLESHEETS_CLEAR_VALUES` — Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the r… - `GOOGLESHEETS_CREATE_CHART` — Create a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements: … - `GOOGLESHEETS_CREATE_GOOGLE_SHEET1` — Creates a new Google Spreadsheet in Google Drive using the provided title. - `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-… - `GOOGLESHEETS_CREATE_SPREADSHEET_ROW` — Inserts a new, empty row into a specified sheet of a Google Spreadsheet at a given index, optionally inheriting formatt… - `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 r… - `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… - `GOOGLESHEETS_EXECUTE_SQL` — Execute SQL queries against Google Sheets tables. Supports SELECT, INSERT, UPDATE, and DELETE operations with familiar … - `GOOGLESHEETS_FIND_REPLACE` — Tool to find and replace text in a Google Spreadsheet. Use when you need to fix formula errors, update values, or perfo… - `GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE` — Finds a worksheet by its exact, case-sensitive title within a Google Spreadsheet; returns a boolean indicating if found… - `GOOGLESHEETS_FORMAT_CELL` — Applies text and background cell formatting to a specified range in a Google Sheets worksheet. - `GOOGLESHEETS_GET_SHEET_NAMES` — Lists all worksheet names from a specified Google Spreadsheet (which must exist), useful for discovering sheets before … - `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 retriev… - `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… - `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… - `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 spreads… - `GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW` — Finds the first row in a Google Spreadsheet where a cell's entire content exactly matches the query string, searching w… - `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. Execu… - `GOOGLESHEETS_SEARCH_DEVELOPER_METADATA` — Tool to search for developer metadata in a spreadsheet. Use when you need to find specific metadata entries based on fi… - `GOOGLESHEETS_SEARCH_SPREADSHEETS` — Search for Google Spreadsheets using various filters including name, content, date ranges, and more. - `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 specif… - `GOOGLESHEETS_SHEET_FROM_JSON` — Creates a new Google Spreadsheet and populates its first worksheet from `sheet_json`, which must be non-empty as its fi… - `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 di… - `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 S… - `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 … - `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 a… - `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… - `GOOGLESHEETS_UPDATE_SHEET_PROPERTIES` — Tool to update properties of a sheet (worksheet) within a Google Spreadsheet, such as its title, index, visibility, tab… - `GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES` — Tool to update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings. Use when you nee… - `GOOGLESHEETS_UPSERT_ROWS` — Upsert rows - update existing rows by key, append new ones. Automatically handles column mapping and partial updates. U… ```bash # Get full input/output schema for a tool npx -y @smithery/cli@latest tool get googlesheets ```