🔌 MCP Servers
Google Sheets
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
Description
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 ConsoleGOOGLE_CLIENT_SECRET: OAuth 2.0 Client SecretGOOGLE_REFRESH_TOKEN: Refresh token with spreadsheets scope
Reviews (0)
Sign in to write a review.
No reviews yet. Be the first to review!
Comments (0)
No comments yet. Be the first to share your thoughts!