Google Sheets
Enables creating, reading, updating, and managing Google Sheets spreadsheets programmatically.
About
This tool provides a Model Context Protocol (MCP) server that integrates with Google Sheets, allowing users to programmatically create, read, update, and manage spreadsheets directly from applications like Claude. Utilizing the Google Sheets API, it offers functionalities ranging from retrieving specific sheet data to batch updating multiple cell ranges, along with creating and managing spreadsheets and sheets within a configured Google Drive folder.
Key Features
- Retrieves data from Google Sheets using spreadsheet ID, sheet name, and cell range.
- Lists all spreadsheets in the configured Google Drive folder.
- Updates cells in Google Sheets by specifying spreadsheet ID, sheet name, cell range, and data.
- Creates new spreadsheets and sheets with specified titles.
- Performs batch updates of multiple ranges within a Google Sheet.
Use Cases
- Automating data entry and updates in Google Sheets.
- Integrating spreadsheet data into AI workflows.
- Generating reports and dashboards programmatically.
Sponsored