adalpan/google-sheets-mcp
A fully-featured MCP server for Google Sheets with 28 tools — read, write, format, manage sheets, clean data and more, via OAuth 2.0
A fully-featured MCP (Model Context Protocol) server that lets AI agents interact with Google Sheets via the official Google Sheets API v4.
Supports three authentication methods — auto-detected based on what's available.
Built with Python and FastMCP. Designed to run as a Docker container and integrate with AI clients like Claude Desktop, Cursor, and others.
| # | Tool | Description | |---|------|-------------| | 1 | read_sheet | Read data from a single range | | 2 | write_sheet | Write or update cell values | | 3 | append_rows | Append new rows to a sheet | | 4 | batch_get_values | Read multiple ranges in a single API call | | 5 | batch_update_values | Write to multiple ranges in a single API call | | 6 | batch_clear_values | Clear multiple ranges in a single API call | | 7 | clear_range | Clear all values in a single range |
| # | Tool | Description | |---|------|-------------| | 8 | create_spreadsheet | Create a new Google Spreadsheet | | 9 | get_spreadsheet_info | Get title, sheet names, row/column counts | | 10 | list_sheets | List all sheet tabs | | 11 | add_sheet | Add a new sheet tab | | 12 | delete_sheet | Delete a sheet tab | | 13 | rename_sheet | Rename a sheet tab | | 14 | duplicate_sheet | Duplicate a sheet tab within the same spreadsheet | | 15 | copy_sheet_to | Copy a sheet tab to a different spreadsheet |
| # | Tool | Description | |---|------|-------------| | 16 | insert_rows_columns | Insert empty rows or columns at a specific position |
Loading reviews...