MCP Libraries
mcp-gsheetsTools Reference

sheets_get_metadata

Get spreadsheet information and structure

sheets_get_metadata

Get metadata about a spreadsheet including sheets, properties, and structure.

Parameters

ParameterTypeRequiredDescription
spreadsheetIdstringYesThe spreadsheet ID

Example

{
  "tool": "sheets_get_metadata",
  "arguments": {
    "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
  }
}

Response

Returns spreadsheet metadata including:

  • Title and locale
  • List of sheets with IDs and names
  • Sheet properties (grid size, frozen rows/columns)

On this page