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

[DChandanaDevi]

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?

[Bhagya_pola · Accepted solution]

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

[GouthamP]

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.