N8n Google Sheets node unexpectedly overwrites data instead of appending

Other Questions N8n
1

Using my Sheets connector in n8n, data overwrites the first row instead of appending. For example:

insertRow('SheetAlpha', recordInfo, { mode: 'append' });
2

I encountered a similar issue while working on an integration with Google Sheets. In my case the problem was due to an underlying misconfiguration with the Sheet range setting. The function call did not properly target the end of the dataset, which led to overwriting the first row. Reviewing the range parameter and ensuring it was set to point at the correct location solved this for me. I recommend checking for any hidden configuration details, and comparing against the documentation to ensure all parameters are correctly defined for appending data.

3

hey i got a similar shock. turned out my range config was off. had to change settings so it appends after last row instead of overwriting row one. hope this helps u sort it out.

4

I too encountered an issue with using the append mode in n8n and it turned out that the problem was not entirely due to the insertRow function itself. In my case, the issue arose because the underlying configuration in my Google Sheet caused the range detection to be off. I resolved this by doing a pre-check on the last filled row and manually setting the range for the new entry. Adjusting the workflow to accommodate this check helped ensure that each new row was added to the end of the dataset without overwriting the data already present.

5

I faced a similar issue and managed to solve it by digging deeper into the row detection mechanism within my workflow. Instead of relying solely on the default append parameter, I implemented a small logic check to find the last non-empty row in the sheet before inserting new data. This approach ensured that the node correctly identified the appropriate row index, thus eliminating the overwriting problem. It was a simple yet effective fix that improved the reliability of the integration without needing to drastically change my overall setup.

6

hey, i ran into this too. updating n8n and double-checking sheet settings did the trick for me. might be a version bug causing the append mode to misfire. hope this helps!