go_mcp_server_google_sheets
If you are the rightful owner of go_mcp_server_google_sheets 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 for Google Sheets written in Go, providing tools for interacting with Google Spreadsheets.
The Google Sheets MCP Server is a robust tool designed to facilitate seamless interaction with Google Spreadsheets through a Model Context Protocol (MCP) server. Developed in Go, this server offers a comprehensive suite of features that allow users to manage and manipulate spreadsheet data efficiently. It supports various operations such as retrieving and updating cell data, managing sheets and spreadsheets, and sharing documents. The server is equipped with multiple authentication methods, including service accounts, OAuth2, and base64 encoded credentials, ensuring secure and flexible access. This tool is particularly useful for developers and organizations that require automated and programmatic access to Google Sheets, enabling them to integrate spreadsheet functionalities into their applications and workflows.
Features
- Sheet Data: Get/update cell data, formulas, batch operations
- Sheet Management: Create, rename, copy sheets, add rows/columns
- Spreadsheet Management: Create, list, share spreadsheets
- Multiple Authentication Methods: Service account, OAuth2, ADC
Tools
get_sheet_data
Get data from sheet
get_sheet_formulas
Get formulas from sheet
update_cells
Update cell values
batch_update_cells
Batch update multiple ranges
list_sheets
List all sheets in spreadsheet
create_sheet
Create new sheet
rename_sheet
Rename existing sheet
copy_sheet
Copy sheet between spreadsheets
add_rows
Add rows
add_columns
Add columns
create_spreadsheet
Create new spreadsheet
list_spreadsheets
List spreadsheets in Drive
share_spreadsheet
Share spreadsheet with users