Skip to main content
Glama

read_sheet_values

Extract data from a specified range in a Google Sheet using the user's email, spreadsheet ID, and range name. Streamlines access to spreadsheet values for analysis or integration.

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

TableJSON Schema
NameRequiredDescriptionDefault
range_nameNoA1:Z1000
spreadsheet_idYes
user_google_emailYes

Other Tools

Latest Blog Posts

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/ZatesloFL/google_workspace_mcp'

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