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

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

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