google-sheet-mcp-server

google-sheet-mcp-server

3.2

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

  1. google_sheets_create

    Create a new Google Sheet

  2. google_sheets_get

    Get a Google Sheet by ID

  3. google_sheets_update_values

    Update values in a Google Sheet

  4. google_sheets_append_values

    Append values to a Google Sheet

  5. google_sheets_get_values

    Get values from a Google Sheet

  6. google_sheets_clear_values

    Clear values from a Google Sheet

  7. google_sheets_add_sheet

    Add a new sheet to an existing spreadsheet

  8. google_sheets_delete_sheet

    Delete a sheet from a spreadsheet

  9. google_sheets_list

    List Google Sheets accessible to the authenticated user

  10. google_sheets_delete

    Delete a Google Sheet

  11. google_sheets_share

    Share a Google Sheet with specific users

  12. google_sheets_search

    Search for Google Sheets by title

  13. google_sheets_format_cells

    Format cells in a Google Sheet

  14. google_sheets_verify_connection

    Verify connection with Google Sheets API