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
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The 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)