Actions17
Sheet → Append
AI-generatedSummary
Append new rows to a specified table within a Microsoft Excel worksheet by providing data mapped to table columns or as raw JSON arrays.
Inputs
- Workbook (required) — The Microsoft Excel workbook containing the target worksheet and table, selectable by list or ID.
- Sheet (required) — The worksheet within the workbook containing the table, selectable by list or ID.
- Table (required) — The target table in the worksheet to which rows will be appended, selectable by list or ID.
- Data Mode (required) — Controls how input data is provided and mapped: autoMap to match input properties to column names, define to specify each column and value, or raw for raw JSON array input.
- Data (required) — The raw JSON data to append when using 'Raw' data mode, formatted as an array of string arrays representing rows.
- Values to Send — A fixed collection of column-value pairs when using 'define' data mode, specifying exact columns and values to append.
- Options — Additional options including 'Index' to specify the insertion position, 'RAW Data' to control output formatting, and 'Data Property' to name the output property for raw data.
Output shape
a list of rows appended with details, formatted as JSON objects mapping table columns to appended values
Supports three data modes for input mapping and includes an option to return raw or parsed response data. Rows are appended at the end by default or at a specified index shifting rows downwards.