Googlesheets 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…

Precio

Action gratuita

Pago unificado

No compatible actualmente

• titlestring
  Optional title for the chart.
• sheet_idinteger

  Obligatorio
  The numeric sheetId (not the sheet name/title) of the worksheet where the chart will be created. This is a unique integer identifier for the sheet within the spreadsheet. The first/default sheet typically has sheetId=0. IMPORTANT: Use 'Get Spreadsheet Info' action to retrieve va…
• subtitlestring
  Optional subtitle for the chart.
• chart_specobject
  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 ht…
• chart_typestring

  Obligatorio
  Type of chart to create. Supported types: BAR, LINE, AREA, COLUMN, SCATTER, COMBO, STEPPED_AREA, PIE, HISTOGRAM, BUBBLE, CANDLESTICK, TREEMAP, WATERFALL, ORG, SCORECARD. Case-insensitive and whitespace-tolerant.
• data_rangestring

  Obligatorio
  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…
• x_axis_titlestring
  Optional title for the X-axis.
• y_axis_titlestring
  Optional title for the Y-axis.
• background_rednumber
  Red component of chart background color (0.0-1.0). If not specified, uses default.
• spreadsheet_idstring

  Obligatorio
  The unique identifier of the Google Sheets spreadsheet where the chart will be created. Must be the actual spreadsheet ID from the URL (e.g., '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'), NOT the spreadsheet name or title. Find it in the URL: https://docs.google.com/spreadshe…
• background_bluenumber
  Blue component of chart background color (0.0-1.0). If not specified, uses default.
• legend_positionstring
  Position of the chart legend. Options: BOTTOM_LEGEND, TOP_LEGEND, LEFT_LEGEND, RIGHT_LEGEND, NO_LEGEND.

• data

  Obligatorio
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  Obligatorio
  Whether or not the action execution was successful or not

Aún no hay casos de uso relacionados verificados.