Renaming columns in a spreadsheet

Hey, I am new to N8N I am trying to pull a csv from a onedrive location, read the content, rename the columns, create a new spreadsheet and save back to onedrive.

I am having issues with renaming the columns. I put the data from the spreadsheet into “Item List” then I use “Rename Keys”. This works until I need to rename something like “Name” to “[required] Phase: Name” and due to the brackets it messes up the output as you can see in the photo.

Overall workflow excluding the write to spreadsheet then upload to onedrive

Managed to sort it. Instead of writing the expression like “[Required] Phase: Name” I wrote it like “[”[Required] Phase: Name"] " and that sorted it out.

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.