Update: The issue appears to have something to do with the format of the CSV itself. We’re converting to a new inventory system and I’ve used this workflow with the old system with no issue, but the new system formats the document header differently.
In my previous system the CSV had a title row followed by commas so the number of columns in the table were consistent.
In the new system, the CSV has 3 rows of titles with no trailing commas, making them not part of the table.
If I manually delete the first few rows, then Sheetgo recognizes the file again. However manually editing the CSV is not a viable option for automation. Is there any way around this?