Append in new google sheets node

[gfrts]

Describe the issue/error/question

When we choose the append operation on the new google sheets node, now we have to select the “Data Mode” field.
In my case, I put the input node variables with the same names as the worksheet columns, and selected the “Auto-map Input Data to Columns” mode. The flow ran successfully and correctly filled the spreadsheet columns with the values, but for the subsequent columns, it filled with “blank” information. This is bad, because in that column there is a formula, and when I run the workflow the formula is deleted.
Is this expected behavior? When we choose the append operation on the new google sheets node, now we have to select the “Data Mode” field.
In my case, I put the input node variables with the same names as the worksheet columns, and selected the “Auto-map Input Data to Columns” mode. The flow ran successfully and correctly filled the spreadsheet columns with the values, but for the subsequent columns, it filled with “blank” information. This is bad, because in that column there is a formula, and when I run the workflow the formula is deleted.
Is this expected behavior? How to make only the columns in which there is a variable with the same name to be filled?

[Jon]

Hey @gfrts,

I have just given this a go and for me it is overwriting the other columns, Can you share the version of n8n you are using, your workflow and maybe the output of the sheets node?

[gfrts]

Hey @Jon, thanks for the answer.
In your case did it also fill subsequent columns with blank values? Is this the expected behavior? Imagine the following scenario: we have columns A (id), B (name), C (age) and D (classification). In column D I have a formula already defined, which depends on the data that will be entered in the previous columns.
If I build a stream so that the google sheets node only sends the information for columns A, B and C (and obviously correctly mapping the same variable names), when the stream runs it fills in columns A, B and C correctly, however it fills column D with blank value, thus replacing the formula and breaking the worksheet.
Maybe now I managed to explain the problem better.