Workflow Updates Wrong Google Sheets Columns

Bug Reports
1

Bug: Google Sheets “Update Row” ignores destination column names.

I was trying to run a workflow to bulk update rows, but I wanted to test in google sheets first to make sure I got my conditions correct (since I’m more comfortable with sheets than softr native db).

I ran a workflow to search for records matching a condition, and then set a loop to go through them.

Using a random student number, 48260, and the scores I wanted to update, I tested the update. When I went to go look on the google sheet, it had updated the wrong columns.

My hypothesis is that the Google Sheets Update-Single-Row Workflow Step updates columns in order right after the searched column, instead of updating the columns you ask it to. (like, if I ask it to update columns 4, 5, and 6 based on column 1; it’d update columns 2, 3, and 4 based on column 1 instead).

Steps to reproduce:

  1. Create a google sheet with headers (Assignments 1-5):
    Student # | Actual Assignment 1 Score | Actual Assignment 2 Score | Actual Assignment etc.. | Workflow # | Workflow Assignment 1 | Workflow Assignment 2 | Workflow Assignment etc...

  2. Configure Update Row:

    • Search by Student #

    • Update:

      • Actual Series 1 Score = A

      • Workflow # = Workflow: 48260

      • Workflow Series 1 = B

      • Workflow Series 3 = C

    Run the workflow.

Expected:

  • Values are written to their named columns.

Actual:

  • AAA → Actual Series 1 Score

  • Workflow: 48260 → Actual Series 2 Score

  • BBB → Actual Series 3 Score

  • CCC → Actual Series 4 Score