立即开始
Google Sheets Tools

Googlesheets Create Chart

通过 Aident Loadout 使用 Google Sheets Tools 的 Googlesheets Create Chart。执行前查看输入、输出、设置、价格和风险。

写入操作风险等级 2/5OAuth 连接
使用 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…

价格与限制

价格
免费操作
统一支付
暂不支持

输入

  • titlestring
    Optional title for the chart.
  • sheet_idinteger
    必填
    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
    必填
    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
    必填
    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
    必填
    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
    必填
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    必填
    Whether or not the action execution was successful or not

使用此操作的技能

相关使用场景

尚未关联经过验证的相关使用场景。

官方来源

服务提供商来源