Hello ! In a workflow, I want to automatically log errors into a Google Sheets document (columns A = URL, B = Workflow, C = Error).
Each new error should be added to the first empty row within that table, without inserting new rows and without modifying column D (which contains checkboxes).
What is the best way to achieve this ?
hey, so for this you’ll want to use the **Google Sheets node** with the “Append” operation - it automatically finds the first empty row and adds your data without shifting anything around.
set it up like this:
1. in the google sheets node, choose your sheet and set operation to “Append”
2. map your columns: URL → column A, Workflow → column B, Error → column C
3. leave column D untouched since append only writes to the columns you specify
the append operation respects your existing data and won’t touch column D, so your checkboxes stay safe. if you need to be extra careful, you can also manually specify which range to append to (like `A:C`) to explicitly exclude column D. lmk if you hit any issues setting it up