If I use regular references to cells with data, then after the 1st cycle it becomes inoperative because it contains the values of the cells with data themselves.
Hey @maksilo , your question does not seem to be related to GSheet specifically but rather how to get the variable name instead of its value. The variable name appears to be a spreadsheet column name. Is that name not constant? Why don’t you just hardcode it instead of using an expression?
Anyway, to get the name of the variable if you know its value, you can use the following expression
I finally figured it out and inserted the variable name in the form {{ $json.col_1 }}.
But I still don’t understand why the Google block counts lines starting from the second, in the first it does not write the line number but simply the text row_number.
So I had to move all the data down one line, but that’s okay. I think the ticket can be closed, thanks for the answer!
