cancel
Showing results for 
Search instead for 
Did you mean: 

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

DChandanaDevi
Deputy Chef II
Deputy Chef II

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?

2 REPLIES 2

Bhagya_pola
Deputy Chef III
Deputy Chef III

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
Deputy Chef I
Deputy Chef I

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.Screenshot 2025-09-01 185800.png