Google Sheets (verified)
Read, write, and format spreadsheet data. Manage sheets, run formulas, and collaborate on structured data in real time.
Quick Start
# Connect this server (installs CLI if needed)
npx -y smithery mcp add googlesheets
# Browse available tools
npx -y smithery tool list googlesheets
# Get full schema for a tool
npx -y smithery tool get googlesheets GOOGLESHEETS_ADD_SHEET
# Call a tool
npx -y smithery 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 iffirst_cell_locationis …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 validspreadsheet_idand an existingsheet_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 fromsheet_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…
# Get full input/output schema for a tool
npx -y smithery tool get googlesheets