Schema | Google Sheets MCP Server

Google Sheets MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`GOOGLE_SPREADSHEET_ID`	No	The ID of the Google Sheet to interact with.
`GOOGLE_APPLICATION_CREDENTIALS`	No	Path to the service account JSON key file.

Features and capabilities supported by this server

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
sheets_list_tabsA	List all sheet tabs in the connected Google Spreadsheet. Use this to discover available sheets before reading or writing data.
sheets_read_rangeA	Read data from a Google Sheet range. Range format: 'SheetName!A1:Z100' or just 'SheetName' for the whole sheet. First row is treated as headers and data is returned as an array of objects.
sheets_get_sheetB	Get spreadsheet metadata: title, URL, locale, and all tabs with row/column counts.
sheets_write_rangeA	Write values to a Google Sheet range. Values should be a 2D array: each inner array is a row. Example: [['name','age'],['Anton','30']]
sheets_create_tabB	Create a new sheet tab in the spreadsheet.
sheets_append_rowA	Append a row to a sheet. The row is a JSON object with column names as keys. The tool automatically reads the header row to align columns. Example: {"name": "Anton", "email": "anton@example.com"}

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/we2go/google-mcp'

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