Hi,
I am hitting a wall when trying to append data into spreadsheet what is the best to handle this, I know spreadsheet is Write to file and that is why it is not appending.
I know google sheet has the option but there should be an other way to handle this so I can share it with others.
It looks like your topic is missing some important information. Could you provide the following if applicable.
what exactly is happening? The community needs more information in order to help you troubleshoot the error you are receiving.
Sorry for the late reply when I am getting the data it reads it and creates the file and then doesn’t save the loop data but overwrites the file instead of adding it to the next line.
You need to read the file first, merge input data with the data from file into n8n data structure, append new data, and write the entire file.
Without seeing your current workflow it is hard to tell if you really need the Loop node to append the data. Alternative could be a Code node or Set node that would do this for all new data at once. Depends on structure of the input.
Try posting your workflow. See the tip at the top of the message editing box on how to accomplish this. Real workflow is worth 1000 words.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.