Problem with "Append or update a sheet" node in Microsoft Excel integration

[Uwe_Clement]

Hi everyone,

I am trying to use the “Append or update a sheet” node with Microsoft Excel in n8n.
My setup:

• Workbook: n8n_UCL_Reddit

• Sheet: Users

• Column to match on: Login

• Value to match: clement@gmx.de (should be a new entry/row)

  
  

• Values to send:

  • Firstname → Peter

  • Lastname → Clement2

In my Excel file the columns are: Login, Firstname, Lastname.

When I execute the node, I get the following error:

Bad request - please check your parameters
The number of rows or columns in the input matrix does not match the size or dimensions of the range.

Screenshots are attached: one of the n8n configuration and one of the Excel file.

Does anyone know why this error occurs? Is there something wrong with how I mapped the columns, or do I need to format the sheet differently (e.g. convert to a table)?

Thanks in advance!

[Uwe_Clement]

I found now by myself a solution. Important is to turn on the radiobutton “Append After Selected Range”

[Uwe_Clement]

The solution didn’t work. Anybody has a working “Update Or Append” MS Excel node? I use this workaround now as a sub-workflow, but i don’t like it because i need 5 nodes, instead of 1: