I am trying to write info retreived by “get data“ google sheets node hovever no matter what I do it allways writes less data than it outputs. I tried many different inputs. Tried Tel, tried name, tried other variables, tried to output just the letter X 4 times yet every time the node outputs 4 items and google sheets only writes 2. This is the only node with this behaviour, tried deleting and replacing it, restarted docker container, allways the same behaviour. Is this a bug or am I doing something wrong?
Hi @Benedict1, welcomo to the n8n community !! From what it looks like, you are using Append or Update with a match column. When multiple input items share the same value in that column, the node updates the same row instead of creating new ones, which is why you see fewer rows written than items processed. In cases like this, I usually add a unique key to avoid collisions. If you want to always write every row, use Append instead of Append or Update, or make sure the match column has unique values per item.
Hi @Benedict1 Welcome!
Have you tried using Append Row instead of Append or Update Row, please consider trying Append row only and make sure to give data fetched from the HTTP node, let me know if this works.
I have tried just apending function as well - also returns 2 items. As well as if you look at the 4 outputs of the node you can notice they are all uniqe yet apend or update function still only writes 2 despite outputing 4
@Benedict1 It looks like the node is overwriting rows because it is inheriting the row reference from the Get Data node. Clearing the item before using Append usually fixes this. I normally do this by adding a Set node before the Google Sheets node, and after that the issue tends to disappear.
@Benedict1 have you tried testing this with some mock data using code node that does it even write or the HTTP node is giving 4 items so in case are those 4 items even writable in the excel? Let me know after confirming this and you can attach your workflow JSON as well.
hi @Benedict1 can you try adding in your gsheet node the option to let gsheet format data and see the output? It might be that for some reason the 2 other input format is not recognized as same as the 2 others
Tried, unsuccessfully. I narrowed down the cause. This only happens when working in a setup of multiple documents or a document with multiple sheets. When attempting to use data from one to write in another one this happens. It just happened to me in another use case where output is 5 uniqe items but it only writes 3 in APEND mode (not apend or update)
New development - my header row was 3 rows thick. Reducing it to 1 fixes the issue, makes sense why both times it deleted 2 items. I tried keeping it 3 rows thick and using HEADER ROW = 3 in google sheets node however it did not work.
!! From what it looks like, you are using Append or Update with a match column. When multiple input items share the same value in that column, the node updates the same row instead of creating new ones, which is why you see fewer rows written than items processed. In cases like this, I usually add a unique key to avoid collisions. If you want to always write every row, use Append instead of Append or Update, or make sure the match column has unique values per item.