Troubleshoot spreadsheet workflows
Inspect the workbook shape and verify the target of an edit or export.
- For
spreadsheet.inspect, check thatsourcePathpoints to an available file. For CSV or TSV previews, inspect the rows and thetruncatedflag before using the preview as input to another step. - Compare actual sheet names and column positions with the next node’s mapping. Normalize variable headers in a declared transform. For
spreadsheet.validate, supply a workbook object withworkbook.sheetsand inspectvalidandissuesfor details such as duplicate sheet names or missing rows. - Before using
spreadsheet.edit, confirm the target workbook and sheet and inspect the requested changes. Afterward, open the resulting workbook or exported file and check the affected cells. If a run stopped after an edit, examine the workbook before retrying.