Synology Sheets icon

Synology Sheets

Create, read, write, and manage Synology spreadsheets via Docker API

Actions14

Append Rows

AI-generated

Summary

Append one or more rows to a specified sheet in a Synology spreadsheet, either by providing manual cell values or by mapping input fields to sheet columns.

Inputs

  • Spreadsheet ID (required) — The unique ID of the spreadsheet to modify.
  • Sheet ID (required) — The ID of the target sheet within the spreadsheet (e.g., sh_1, sh_2).
  • Input Type (required) — Select how to input the data: 'Manual Values' to provide JSON arrays of values directly, or 'Column Mapping' to map input data fields to columns.
  • Values (required) — When using 'Manual Values' as Input Type, provide the data as a JSON array of arrays representing rows and cells to append.
  • Auto-Detect Headers — When using 'Column Mapping' as Input Type, optionally read the first row as headers to assist mapping.
  • Column Mapping — When using 'Column Mapping', specify one or more mappings of column letters to input field names to extract values from incoming data.

Output shape

a single record

Returns the API response from the Synology Sheets service indicating the result of the append operation. Errors will throw unless 'Continue On Fail' is enabled, in which case errors are returned as JSON objects.

Examples

Example 1: Append rows by providing manual JSON arrays of values

Specify Spreadsheet ID, Sheet ID, select 'Manual Values' for Input Type, and provide rows as a JSON array of arrays in 'Values'. The specified rows will be appended to the sheet.

Example 2: Append rows by mapping input fields to sheet columns

Specify Spreadsheet ID, Sheet ID, select 'Column Mapping' for Input Type, configure mappings between sheet columns and input field names, and optionally enable 'Auto-Detect Headers'. The node will append a single row composed from the input data according to the mapping.

Links

Discussion