Skip to main content
Glama

Google Workspace MCP Server

MIT License
105
  • Apple
  • Linux

read_sheet_values

Extract formatted data from a specific range in a Google Sheet using the user's email, spreadsheet ID, and range name for precise data retrieval.

Instructions

Reads values from a specific range in a Google Sheet. Args: user_google_email (str): The user's Google email address. Required. spreadsheet_id (str): The ID of the spreadsheet. Required. range_name (str): The range to read (e.g., "Sheet1!A1:D10", "A1:D10"). Defaults to "A1:Z1000". Returns: str: The formatted values from the specified range.

Input Schema

NameRequiredDescriptionDefault
range_nameNoA1:Z1000
serviceYes
spreadsheet_idYes
user_google_emailYes

Input Schema (JSON Schema)

{ "properties": { "range_name": { "default": "A1:Z1000", "title": "Range Name", "type": "string" }, "service": { "title": "service", "type": "string" }, "spreadsheet_id": { "title": "Spreadsheet Id", "type": "string" }, "user_google_email": { "title": "User Google Email", "type": "string" } }, "required": [ "service", "user_google_email", "spreadsheet_id" ], "title": "read_sheet_valuesArguments", "type": "object" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/taylorwilsdon/google_workspace_mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server