transform.xlsx-to-json, Convert XLSX spreadsheet to JSON array of row objects for use in scripts or downstream steps
Configuration
Configuration goes inside the step’swith: block.
File input - template expression e.g. {{input.document}} resolving to fileId or file path descriptor
Sheet to read: 0-based index or sheet name. Omit for first sheet.
If true, also write CSV to storage and include fileId in output
Output CSV filename when outputCsv is true - supports LiquidJS e.g. {{filename}}.csv
Output
Array of row objects (first row = headers as keys)
File ID of stored CSV when outputCsv is true