Google Sheets

MCP server for Google Sheets : read, write, format, and manage spreadsheets through 23 tools.

От сообществаРаботаетНужен API-ключГлобальныйБесплатноМожет изменять данные

Что умеет

  • Gs Create Spreadsheet: Create a new Google Sheets spreadsheet. Optionally specify sheet/tab names, locale, and timezone. Returns the spreadsheet ID and URL.
  • Gs Get Spreadsheet: Get spreadsheet metadata — title, sheets list with properties (ID, title, row/column count, frozen rows), and optionally cell data for specific ranges.
  • Gs Read Values: Read cell values from a range using A1 notation (e.g. "Sheet1!A1:C10", "A1:Z", "Sheet1"). Returns a 2D array of values.

Какие данные видит

Нужен ли аккаунт

Нужен API-ключ из настроек сервиса

MCP server for Google Sheets : read, write, format, and manage spreadsheets through 23 tools.

Features

  • Read and write cell values with A1 notation
  • Batch read/write for multiple ranges at once
  • Full formatting: bold, italic, colors, fonts, alignment, number formats
  • Sheet management: add, delete, rename, copy, duplicate tabs
  • Data operations: sort, find & replace, filters, protected ranges
  • Add charts (bar, line, column, scatter, etc.)
  • Raw batchUpdate pass-through for any Sheets API operation

23 Tools

  • Spreadsheet: create and get spreadsheet metadata
  • Values: read, batch read, write, append, clear, batch write
  • Sheet Management: add, delete, rename, copy, duplicate sheets
  • Formatting: format cells, merge/unmerge, auto-resize
  • Data Operations: sort, find & replace, basic filter, protected ranges
  • Advanced: add chart, raw batchUpdate

Configuration

  • GOOGLE_CLIENT_ID : OAuth 2.0 Client ID from Google Cloud Console
  • GOOGLE_CLIENT_SECRET : OAuth 2.0 Client Secret
  • GOOGLE_REFRESH_TOKEN : Refresh token with spreadsheets scope
Список инструментов сервера (23)

Технические названия из tools/list. Нужны только разработчикам.

gs_create_spreadsheetCreate a new Google Sheets spreadsheet. Optionally specify sheet/tab names, locale, and timezone. Returns the spreadsheet ID and URL.
gs_get_spreadsheetGet spreadsheet metadata — title, sheets list with properties (ID, title, row/column count, frozen rows), and optionally cell data for specific ranges.
gs_read_valuesRead cell values from a range using A1 notation (e.g. "Sheet1!A1:C10", "A1:Z", "Sheet1"). Returns a 2D array of values.
gs_batch_readRead values from multiple ranges at once. More efficient than multiple gs_read_values calls.
gs_write_valuesWrite values to a range. Values are provided as a 2D array (rows of columns). By default uses USER_ENTERED input (formulas and formatting are parsed).
gs_append_valuesAppend rows after the last row with data in the specified range. Automatically finds the end of existing data and adds new rows below.
gs_clear_valuesClear all values in a range. Only clears values — formatting, data validation, and other properties are preserved.
gs_batch_writeWrite values to multiple ranges at once. More efficient than multiple gs_write_values calls.
gs_add_sheetAdd a new sheet/tab to a spreadsheet. Optionally set row/column count and tab color.
gs_delete_sheetDelete a sheet/tab from a spreadsheet. Use gs_get_spreadsheet to find the sheet_id first. This action is irreversible.
gs_rename_sheetRename a sheet/tab in a spreadsheet.
gs_copy_sheetCopy a sheet/tab to another spreadsheet. The authenticated user must have edit access to the destination spreadsheet.
gs_duplicate_sheetDuplicate a sheet/tab within the same spreadsheet. Creates a copy with an optional new name.
gs_format_cellsApply formatting to cells in a range — bold, italic, font size, colors, alignment, number format, and more. Uses 0-based row/column indices.
gs_merge_cellsMerge cells in a range. All values except the top-left cell are cleared.
gs_unmerge_cellsUnmerge previously merged cells in a range.
gs_auto_resizeAuto-resize columns or rows to fit their content.
gs_sort_rangeSort a range of data by a specific column. Uses 0-based indices for the range and sort column.
gs_find_replaceFind and replace text across one sheet or all sheets. Supports case-sensitive and regex search.
gs_set_basic_filterSet or clear a basic filter (auto-filter) on a sheet. When set, filter dropdowns appear in column headers.
gs_add_protected_rangeProtect a range of cells from editing. Optionally allow specific editors or show a warning instead of blocking.
gs_add_chartAdd a chart to a sheet. Specify chart type, data range, and anchor position. The chart is overlaid on the sheet.
gs_batch_updateSend 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.