mcp-server-spreadsheet
If you are the rightful owner of mcp-server-spreadsheet and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server implementation that integrates with Google Spreadsheets, allowing AI assistants to retrieve and modify spreadsheet data.
The MCP Server for Google Spreadsheets is designed to facilitate seamless interaction between AI assistants, like Claude, and Google Sheets. By leveraging the Google Sheets API, this server allows users to perform various operations on spreadsheets, such as retrieving sheet information, updating cell values, and adding new sheets. The server is built using Node.js and requires Google Cloud authentication credentials to access the Sheets API. It is particularly useful for users who need to automate spreadsheet tasks or integrate spreadsheet data into AI-driven workflows. The server supports a range of operations, from simple data retrieval to complex batch updates, making it a versatile tool for managing spreadsheet data programmatically.
Features
- get_sheets: Retrieve all sheet information from a Google Spreadsheet, including names, dimensions, and IDs.
- get_sheet_values: Retrieve values from a specific sheet with optional range specification.
- update_cells: Update values in a specific range of cells within a sheet.
- batch_update_cells: Update multiple ranges across different sheets in a single operation.
- add_sheet: Add a new sheet to an existing spreadsheet with customizable dimensions.