I am trying to append my retrieved data to a Google Sheet.
To do so, I first used the “SET” node. For now I get 7 items and the flow works well until that step:
Then, I tried to append the data into a Google sheet but received this message:
I tried to convert the 7 items into 1 item with the function node, I tried to format the columns in my Google sheet, I tried to rename the range and/or the key row, I tried to first create then append data, merge data, but nothing worked.
Does someone have any suggestion?
Thank you in advance.