MCP Tool Directory

Searches for places (e.g., restaurants, parks) within a specified circular area, with options to filter by place types and customize the returned fields and number of results.

DEPRECATED: Exports Google Workspace files (max 10MB) to a specified format using `mime_type`, or downloads other file types; use `GOOGLEDRIVE_DOWNLOAD_FILE` instead.

Partially updates (PATCHes) an existing Google Calendar, modifying only the fields provided; `summary` is mandatory and cannot be an empty string, and an empty string for `description` or `location` clears them.

Update specified fields of an existing event in a Google Calendar using patch semantics (array fields like `attendees` are fully replaced if provided); ensure the `calendar_id` and `event_id` are valid and the user has write access to the calendar.

Patches the specified label.

Partially updates an existing task (identified by `task_id`) within a specific Google Task list (identified by `tasklist_id`), modifying only the provided attributes from `TaskInput` (e.g., `title`, `notes`, `due` date, `status`) and requiring both the task and list to exist.

Updates the title of an existing Google Tasks task list.

Tool to query a completed audience export. Use when you need to fetch user rows with pagination.

Tool to query an audience list. Use when you need to retrieve user rows from a GA4 audience list with pagination.

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 against spreadsheet tables. Supports WHERE conditions, ORDER BY, LIMIT clauses. Call this action after calling the GET_TABLE_SCHEMA action to query a table in a spreadsheet.

Parses natural language text to quickly create a basic Google Calendar event with its title, date, and time, suitable for simple scheduling; does not support direct attendee addition or recurring events, and `calendar_id` must be valid if not 'primary'.

Removes an attendee from a specified event in a Google Calendar; the calendar and event must exist.

Add a chart to a sheet. Specify chart type, data range, and anchor position. The chart is overlaid on the sheet.

Protect a range of cells from editing. Optionally allow specific editors or show a warning instead of blocking.

Add a new sheet/tab to a spreadsheet. Optionally set row/column count and tab color.

Append rows after the last row with data in the specified range. Automatically finds the end of existing data and adds new rows below.

Auto-resize columns or rows to fit their content.

Read values from multiple ranges at once. More efficient than multiple gs_read_values calls.

Send a raw batchUpdate request with one or more request objects. Use this for advanced operations not covered by other tools (e.g. conditional formatting, data validation, dimension properties). See Google Sheets API batchUpdate documentation for available request types.

Write values to multiple ranges at once. More efficient than multiple gs_write_values calls.

Clear all values in a range. Only clears values — formatting, data validation, and other properties are preserved.

Copy a sheet/tab to another spreadsheet. The authenticated user must have edit access to the destination spreadsheet.

Create a new Google Sheets spreadsheet. Optionally specify sheet/tab names, locale, and timezone. Returns the spreadsheet ID and URL.

Delete a sheet/tab from a spreadsheet. Use gs_get_spreadsheet to find the sheet_id first. This action is irreversible.

Duplicate a sheet/tab within the same spreadsheet. Creates a copy with an optional new name.

Find and replace text across one sheet or all sheets. Supports case-sensitive and regex search.

Apply formatting to cells in a range — bold, italic, font size, colors, alignment, number format, and more. Uses 0-based row/column indices.

Get spreadsheet metadata — title, sheets list with properties (ID, title, row/column count, frozen rows), and optionally cell data for specific ranges.

Merge cells in a range. All values except the top-left cell are cleared.

Read cell values from a range using A1 notation (e.g. "Sheet1!A1:C10", "A1:Z", "Sheet1"). Returns a 2D array of values.