google-sheet-mcp-server
If you are the rightful owner of google-sheet-mcp-server 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@mcpreview.com.
A powerful Model Context Protocol (MCP) server implementation for seamless Google Sheets API integration, enabling AI assistants to create, read, update, and manage Google Sheets.
The Google Sheets MCP Server is designed to facilitate seamless integration with the Google Sheets API, allowing AI assistants to perform a variety of operations on Google Sheets. This server supports creating, reading, updating, and deleting Google Sheets, as well as managing sheet data with cell-level operations. It also provides features for formatting cells and ranges, sharing spreadsheets with other users, and searching for spreadsheets. The server offers comprehensive authentication options, including Service Account Authentication, API Key Authentication, and OAuth2 Authentication, making it versatile for different use cases. The setup process involves installing Node.js, cloning the repository, installing dependencies, setting up authentication, and starting the server. The server also provides a range of tools for interacting with Google Sheets, making it a robust solution for managing spreadsheets programmatically.
Features
- Create, read, update, and delete Google Sheets
- Manage sheet data with cell-level operations
- Format cells and ranges
- Share spreadsheets with other users
- Search for spreadsheets
Tools
google_sheets_create
Create a new Google Sheet
google_sheets_get
Get a Google Sheet by ID
google_sheets_update_values
Update values in a Google Sheet
google_sheets_append_values
Append values to a Google Sheet
google_sheets_get_values
Get values from a Google Sheet
google_sheets_clear_values
Clear values from a Google Sheet
google_sheets_add_sheet
Add a new sheet to an existing spreadsheet
google_sheets_delete_sheet
Delete a sheet from a spreadsheet
google_sheets_list
List Google Sheets accessible to the authenticated user
google_sheets_delete
Delete a Google Sheet
google_sheets_share
Share a Google Sheet with specific users
google_sheets_search
Search for Google Sheets by title
google_sheets_format_cells
Format cells in a Google Sheet
google_sheets_verify_connection
Verify connection with Google Sheets API