topic Workato CSV action: Can we insert a custom row before headers? in Workato Pros Discussion Board

Workato CSV action: Can we insert a custom row before headers?

DChandanaDevi — Mon, 01 Sep 2025 08:02:30 GMT

Hi All,

I have a scenario where I need to send a CSV file to the source in the following structure:

Row 1 contains a note
Row 2 contains the column headers
Row 3 onwards contains the actual data

However, in Workato the CSV action always treats the first row as the header, which causes issues. I don’t want to generate an Excel file — I specifically need to send a CSV file in this format.

Is there a way in Workato to add a custom first row (note) before the header row, or do I need to use a workaround?

Re: Workato CSV action: Can we insert a custom row before headers?

Bhagya_pola — Mon, 01 Sep 2025 17:00:46 GMT

Hi @DChandanaDevi
Please go through this below post, it might help you

Re: Issue with Google Sheets: Workato Assumes Head... - Systematic Community - 10533

Thanks,
Bhagya Sri

Re: Workato CSV action: Can we insert a custom row before headers?

GouthamP — Tue, 02 Sep 2025 13:14:40 GMT

Hi @DChandanaDevi
Workato’s CSV actions always assume the first row = header, so you can’t directly insert a “note” row above it.

Workaround: Use formula mode to manually prepend your custom note line to the generated CSV string.