I am currently using n8n to grab data from the St Louis Federal Reserve API and sending it to Supabase and Sheets. The data I get works great except when it is sent to Sheets all the data is being appended with '. So all the dates and values come into sheets as 'Date and 'Value. This is not happening with the data going to Supabase which is coming from the same node. The way it’s coming into Sheets is breaking a couple of array formulas used to calculate other values from the data. Wondering if anyone has any ideas?
Adding the option “Value Input Mode” and set it to “User Entered” should do what you want.
Perfect. Thanks.