I have set up an n8n workflow that should add new data to my Google Sheets document whenever a webhook gets triggered. My target worksheet is called ‘M2’ and I configured the Google Sheets node to use the Append mode.
The problem is that my data keeps overwriting the existing content starting from row 1, including my header row. I expected it to find the last used row and add my new data below it. I also tested with the Append or Update setting but got the same result.
The workflow runs without errors and connects to Google Sheets successfully. However, the behavior is completely wrong. My original data gets wiped out and replaced with the new incoming data.
Has anyone experienced this issue before? I must be missing something in my configuration but I can’t figure out what.
It seems that your Google Sheets integration might be misconfigured, which is causing it to overwrite existing data instead of appending. I faced a similar issue initially, and what helped was setting the ‘Data Mode’ explicitly to ‘Append’. It’s crucial not to rely solely on the default setting. Additionally, avoid using specific fixed ranges such as A1:Z10, as this can lead to overwriting; instead, use open ranges like A:Z or leave the range field blank. Lastly, ensure there are no empty rows above the desired insertion point since n8n can misinterpret gaps as empty sheets.
I encountered a similar issue recently with n8n and Google Sheets. The problem usually stems from incorrect permissions or misconfigured settings. Make sure your service account has editor access to the Google Sheet, and double-check that the worksheet name, ‘M2’, is entered correctly, respecting case sensitivity. Additionally, specify the range in your Google Sheets node, like ‘M2!A:Z’, to avoid defaulting to overwrite behavior. If the ‘Header Row’ option is enabled, consider disabling it as that can also interfere with data detection during appending. Once these adjustments are made, the append functionality should work as intended.
sounds like the node’s detecting your sheet as empty somehow. try adding dummy data in a few rows first - see if n8n picks up the actual last row correctly. also check for formatting issues or merged cells that might be confusing the detection.
This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.