Using n8n to insert entries into a Google Sheet named ‘M2’ unexpectedly overwrites the first row. How can I accomplish proper appending without replacing existing data?
hey, looks like u might be using the wrong mode. try adjustin your n8n config to use append mode instead of update. sometimes a simple change in the node settings fixes it all. hope this helps!
I encountered a similar issue while working with n8n and Google Sheets. It turned out that the problem was due to how the Google Sheets node was configured. In my case, checking and double-checking the node settings resolved the problem. Instead of using a general update, the node needed to be explicitly set to append mode. Reviewing my spreadsheet’s setup also helped ensure that the correct range was selected, which prevented overwriting. I recommend verifying both settings and column configurations in your node.
Based on my experience, the key was to ensure that the node was set to use append functionality and that the sheet range settings were correctly configured. I found that if the configuration wasn’t precise, n8n would default to targeting the first row, thus overwriting it. After modifying the node settings and verifying that my Google Sheet’s header was not part of the data range, the issue was resolved. This adjustment in the workflow prevented data loss and enabled the desired appending of new entries properly.