mcp-gsheetsTools Reference
sheets_create_chart
Create various types of charts
sheets_create_chart
Create a chart in a spreadsheet.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
sheetId | number | Yes | Sheet ID where chart will be placed |
chartType | string | Yes | Type of chart |
sourceRange | string | Yes | Data range for the chart |
position | object | No | Chart position |
Chart Types
BAR, LINE, AREA, COLUMN, PIE, SCATTER, COMBO
Example
{
"tool": "sheets_create_chart",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"sheetId": 0,
"chartType": "LINE",
"sourceRange": "Sheet1!A1:B10",
"position": {
"overlayPosition": {
"anchorCell": { "sheetId": 0, "rowIndex": 0, "columnIndex": 5 }
}
}
}
}