Google Spreadsheet MCP
JSON →Full Google Sheets integration - read, write, format cells, create charts, use formulas, and manage spreadsheets.
Install
npx (Alternative) Tools · 27
- create_spreadsheet Creates a new Google Spreadsheet with optional initial data.
- get_spreadsheet_info Retrieves metadata about a spreadsheet.
- list_sheets Lists all sheets within a spreadsheet.
- add_sheet Adds a new sheet to a spreadsheet.
- delete_sheet Deletes a sheet from a spreadsheet.
- rename_sheet Renames an existing sheet.
- get_values Retrieves values from a specified range.
- update_values Updates values in a specified range.
- append_values Appends values to a sheet.
- clear_values Clears values from a specified range.
- get_cell Retrieves the value of a single cell.
- update_cell Updates the value of a single cell.
- find_replace Finds and replaces text in a sheet.
- get_row Retrieves an entire row of data.
- get_column Retrieves an entire column of data.
- insert_row Inserts a new row at a specified position.
- insert_column Inserts a new column at a specified position.
- delete_row Deletes a row at a specified position.
- delete_column Deletes a column at a specified position.
- set_row_height Sets the height of a row.
- set_column_width Sets the width of a column.
- format_range Applies formatting to a range of cells.
- merge_cells Merges cells in a specified range.
- unmerge_cells Unmerges previously merged cells.
- add_borders Adds borders to a range of cells.
- sort_range Sorts a range of cells by specified columns.
- create_chart Creates a chart in the spreadsheet.
Links
★ 15 GitHub stars