Writting to Google Sheets seems to be unreliable

[tomjwise]

I have been writing to specific cells in Google Sheets, but I am finding it unreliable. What am I missing?

I can ‘Create Row’ succesfully, but ‘Update Value’ is failing.

To understand this more, I have simplified down to this, which is not working for me. I does not reach “done”:

Whether the ‘for row id’ is given as a Math block or Text block does not change the result.

Thank you for your thoughts and time.
(I am using Chrome)

[tomjwise]

Ioannis from support helped me on this.

The answer is simply that ‘Update Value in’ will not write to an empty cell.

‘Create Row’ will write to empty cells.

Note that ‘Update Value in’ will number the cells from the header rather than use the Google Sheets index row number. So ‘for row ID’ ‘5’ goes to Google Sheets Row 6.

You can use either the Text field or the Math field to input the Row ID.

[ioannis]

Hello @tomjwise
Thank you for sharing more information and the solution!