今すぐ始める
Google Sheets Tools

Googlesheets Create Chart

Aident Loadout を通じて Google Sheets Tools の Googlesheets Create Chart を使用します。実行前に入力、出力、設定、料金、リスクを確認できます。

書き込み Actionリスクレベル 2/5OAuth 接続

プロバイダーの説明

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…

料金と制限

料金
無料 Action
統合支払い
現在未対応

入力

  • 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

この Action を使用する Skills

関連ユースケース

検証済みの関連ユースケースはまだリンクされていません。

公式ソース

プロバイダーのソース