Google Super
GOOGLESUPER_CREATE_CHART
Create a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements: - Provide either a simple chart via chart_type + data_range (basicChart), OR supply a full chart_spec supporting all chart types. Exactly one approach should be used. - When using chart_spec, set exactly one of the union fields (basicChart | pieChart | bubbleChart | candlestickChart | histogramChart | waterfallChart | treemapChart | orgChart | scorecardChart).
Remote googlesuper
Other tools also called GOOGLESUPER_CREATE_CHART?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"title": {
"type": "string",
"title": "Title",
"default": null,
"examples": [
"Sales Data",
"Monthly Revenue"
],
"nullable": true,
"description": "Optional title for the chart."
},
"sheet_id": {
"type": "integer",
"title": "Sheet Id",
"examples": [
123456789,
987654321
],
"description": "The sheetId of the worksheet where the chart will be created. This is a unique non-zero integer identifier. Use 'Get Sheet Names' or 'Get Spreadsheet Info' actions to retrieve the sheetId for your target worksheet."
},
"subtitle": {
"type": "string",
"title": "Subtitle",
"default": null,
"examples": [
"Q1 2024",
"Year over Year"
],
"nullable": true,
"description": "Optional subtitle for the chart."
},
"chart_spec": {
"type": "object",
"title": "Chart Spec",
"default": null,
"examples": [
{
"pieChart": {
"domain": {
"sourceRange": {
"sources": [
{
"sheetId": 0,
"endRowIndex": 5,
"startRowIndex": 0,
"endColumnIndex": 1,
"startColumnIndex": 0
}
]
}
},
"series": {
"sourceRange": {
"sources": [
{
"sheetId": 0,
"endRowIndex": 5,
"startRowIndex": 0,
"endColumnIndex": 2,
"startColumnIndex": 1
}
]
}
},
"legendPosition": "RIGHT_LEGEND"
}
}
],
"nullable": true,
"description": "Optional full ChartSpec object to send to the Google Sheets API. Use this to support ALL chart types and advanced options. Must set exactly one of: basicChart, pieChart, bubbleChart, candlestickChart, histogramChart, treemapChart, waterfallChart, orgChart, scorecardChart. See https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/charts#ChartSpec.",
"additionalProperties": true
},
"chart_type": {
"type": "string",
"title": "Chart Type",
"examples": [
"COLUMN",
"LINE",
"BAR",
"AREA",
"PIE",
"HISTOGRAM",
"WATERFALL"
],
"description": "The type of chart to create. Supported types: BAR, LINE, AREA, COLUMN, SCATTER, COMBO, STEPPED_AREA (basic charts), PIE, BUBBLE, CANDLESTICK, HISTOGRAM, TREEMAP, WATERFALL, ORG, SCORECARD. If you need full control over the chart specification (including fields not covered by simple inputs), provide chart_spec instead."
},
"data_range": {
"type": "string",
"title": "Data Range",
"examples": [
"A1:C10",
"Sheet1!B2:D20",
"Data!A1:E50"
],
"description": "A single contiguous range of data for the chart in A1 notation (e.g., 'A1:C10' or 'Sheet1!B2:D20'). Must be a single continuous range - comma-separated multi-ranges (e.g., 'A1:A10,C1:C10') are not supported. When chart_spec is not provided, the first column is used as the domain/labels and the remaining columns as series."
},
"x_axis_title": {
"type": "string",
"title": "X Axis Title",
"default": null,
"examples": [
"Time Period",
"Categories"
],
"nullable": true,
"description": "Optional title for the X-axis."
},
"y_axis_title": {
"type": "string",
"title": "Y Axis Title",
"default": null,
"examples": [
"Revenue ($)",
"Count"
],
"nullable": true,
"description": "Optional title for the Y-axis."
},
"background_red": {
"type": "number",
"title": "Background Red",
"default": null,
"examples": [
0,
0.5,
1
],
"nullable": true,
"description": "Red component of chart background color (0.0-1.0). If not specified, uses default."
},
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
],
"description": "The unique identifier of the Google Sheets spreadsheet where the chart will be created."
},
"background_blue": {
"type": "number",
"title": "Background Blue",
"default": null,
"examples": [
0,
0.5,
1
],
"nullable": true,
"description": "Blue component of chart background color (0.0-1.0). If not specified, uses default."
},
"legend_position": {
"type": "string",
"title": "Legend Position",
"default": "BOTTOM_LEGEND",
"examples": [
"BOTTOM_LEGEND",
"RIGHT_LEGEND",
"NO_LEGEND"
],
"description": "Position of the chart legend. Options: BOTTOM_LEGEND, TOP_LEGEND, LEFT_LEGEND, RIGHT_LEGEND, NO_LEGEND."
},
"background_green": {
"type": "number",
"title": "Background Green",
"default": null,
"examples": [
0,
0.5,
1
],
"nullable": true,
"description": "Green component of chart background color (0.0-1.0). If not specified, uses default."
}
}
}