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

Name	Required	Default
`range_name`	No	A1:Z1000
`service`	Yes
`spreadsheet_id`	Yes
`user_google_email`	Yes

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"
}

Google Workspace MCP Server - Control Gmail, Calendar, Docs, Sheets, Slides, Chat, Forms & Drive

read_sheet_values

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Google Workspace MCP Server - Control Gmail, Calendar, Docs, Sheets, Slides, Chat, Forms & Drive

Related Tools

MCP directory API