mcp-google-sheets

mcp-google-sheets: A Google Sheets MCP server

This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets.

Overview

A Model Context Protocol server for interacting with Google Sheets. This server provides tools to create, read, update, and manage spreadsheets through the Google Sheets API.

Tools

• get_sheet_data
  • Get data from a specific sheet in a Google Spreadsheet
  • Input:
    • spreadsheet_id (string): The ID of the spreadsheet (found in the URL)
    • sheet (string): The name of the sheet
    • range (optional string): Cell range in A1 notation (e.g., 'A1:C10')
  • Returns: A 2D array of the sheet data
• update_cells
  • Update cells in a Google Spreadsheet
  • Input:
    • spreadsheet_id (string): The ID of the spreadsheet
    • sheet (string): The name of the sheet
    • range (string): Cell range in A1 notation
    • data (2D array): Values to update
  • Returns: Result of the update operation
• batch_update_cells
  • Batch update multiple ranges in a Google Spreadsheet
  • Input:
    • spreadsheet_id (string): The ID of the spreadsheet
    • sheet (string): The name of the sheet
    • ranges (object): Dictionary mapping range strings to 2D arrays of values
  • Returns: Result of the batch update operation
• list_sheets
  • List all sheets in a Google Spreadsheet
  • Input:
    • spreadsheet_id (string): The ID of the spreadsheet
  • Returns: List of sheet names
• list_spreadsheets
  • List all spreadsheets in the configured Google Drive folder
  • Returns: List of spreadsheets with their ID and title
  • Note: If using service account authentication, this will list spreadsheets in the shared folder
• create_spreadsheet
  • Create a new Google Spreadsheet
  • Input:
    • title (string): The title of the new spreadsheet
  • Returns: Information about the newly created spreadsheet including its ID
  • Note: When using service account authentication with a configured folder ID, the spreadsheet will be created in that folder
• create_sheet
  • Create a new sheet tab in an existing Google Spreadsheet
  • Input:
    • spreadsheet_id (string): The ID of the spreadsheet
    • title (string): The title for the new sheet
  • Returns: Information about the newly created sheet
• Additional tools: add_rows, add_columns, copy_sheet, rename_sheet

Resources

• spreadsheet://{spreadsheet_id}/info
  • Get basic information about a Google Spreadsheet
  • Returns: JSON string with spreadsheet information