I have a table in Google Sheet with titles and borders with 8 columns, but when I run the Google Sheets node with append or update row, it inserts the data at the end of that table and does not replace the data in each cell.
This happens because the Google Sheets node’s “append” operation adds new rows below existing data. To update existing cells instead:
1. Use the “Update Row” operation
2. Set the “Range” field to your table’s exact range (e.g., “Sheet1!A2:H10”)
3. Make sure your input data matches the table’s column order
If you need to dynamically find the table range, you might want to first use a “Get Rows” operation to identify the current boundaries.
I cant do that because is a empty form only with title and borders, color. I dont have a field to match