Skip to Content
Raydo

Troubleshoot spreadsheet workflows

Inspect the workbook shape and verify the target of an edit or export.

  1. For spreadsheet.inspect, check that sourcePath points to an available file. For CSV or TSV previews, inspect the rows and the truncated flag before using the preview as input to another step.
  2. 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 with workbook.sheets and inspect valid and issues for details such as duplicate sheet names or missing rows.
  3. 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.

On this page

Troubleshoot spreadsheet workflows