Googlesheets Move Chart

Move or resize an existing chart on a Google Sheets spreadsheet. Use this action when you need to reposition a chart to a different location on the same or different sheet, move it to a brand-new sheet, or change its size. This action wraps the updateEmbeddedObjectPosition batch…

价格

免费操作

统一支付

暂不支持

• chart_idinteger

  必填
  The unique numeric identifier of the chart to move within the spreadsheet. This is the chartId value (also known as objectId) returned when the chart was created or can be retrieved using GOOGLESHEETS_LIST_CHARTS or 'Get Spreadsheet Info' action (look for sheets[].charts[].chart…
• new_sheetboolean
  Set to true to move the chart to a brand-new sheet. Google Sheets will automatically create and name the new sheet. This is mutually exclusive with target_sheet_id and anchor_sheet_id.
• width_pixelsinteger
  Width of the chart in pixels. Only valid when anchor_sheet_id is provided. If omitted, Google Sheets preserves the existing width.
• height_pixelsinteger
  Height of the chart in pixels. Only valid when anchor_sheet_id is provided. If omitted, Google Sheets preserves the existing height.
• spreadsheet_idstring

  必填
  The unique identifier of the Google Sheets spreadsheet containing the chart to move. 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/spreadsheets…
• anchor_sheet_idinteger
  The numeric sheetId of the sheet to anchor the chart onto when repositioning via overlay coordinates. Required if any of anchor_row_index, anchor_column_index, offset_x_pixels, offset_y_pixels, width_pixels, or height_pixels is provided. This is mutually exclusive with new_sheet…
• offset_x_pixelsinteger
  Horizontal pixel offset from the anchor cell. Only valid when anchor_sheet_id is provided. If omitted, Google Sheets preserves the existing horizontal offset.
• offset_y_pixelsinteger
  Vertical pixel offset from the anchor cell. Only valid when anchor_sheet_id is provided. If omitted, Google Sheets preserves the existing vertical offset.
• target_sheet_idinteger
  The numeric sheetId of an existing sheet to move the chart to. The chart's anchor position on that sheet will remain unchanged. This is mutually exclusive with new_sheet and anchor_sheet_id. Use 'Get Spreadsheet Info' to retrieve valid sheetIds.
• anchor_row_indexinteger
  The 0-based row index of the anchor cell for overlay positioning. Required if anchor_sheet_id is set. Must be used together with anchor_column_index.
• anchor_column_indexinteger
  The 0-based column index of the anchor cell for overlay positioning. Required if anchor_sheet_id is set. Must be used together with anchor_row_index.

• 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

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