go_mcp_server_google_sheets

go_mcp_server_google_sheets

3.2

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

  1. get_sheet_data

    Get data from sheet

  2. get_sheet_formulas

    Get formulas from sheet

  3. update_cells

    Update cell values

  4. batch_update_cells

    Batch update multiple ranges

  5. list_sheets

    List all sheets in spreadsheet

  6. create_sheet

    Create new sheet

  7. rename_sheet

    Rename existing sheet

  8. copy_sheet

    Copy sheet between spreadsheets

  9. add_rows

    Add rows

  10. add_columns

    Add columns

  11. create_spreadsheet

    Create new spreadsheet

  12. list_spreadsheets

    List spreadsheets in Drive

  13. share_spreadsheet

    Share spreadsheet with users