I am following the Control Flow in Studio web module. When I use the Write Row activity for google sheets as directed in the guide steps with Overwrite and Headers available, it is not behaving as expected.
When the existing columns (already filled columns) are not mapped under the column mappings of Individual fields, it replaces the existing data cell with blank cells and writes the new columns on the respective columns.
So I mapped the exisitng columns as well, then those values are also written. But in both cases data is written starting from the 1st row itself, by overwriting the headers row. I tried by setting Row Position field with CurrentRowIndex, CurrentRowIndex + 1, Sheets row index. But nothing works.
Actually I created new google sheet file and tried the same with new columns. Added a for each row activity and then just write row activity inside the loop with hardcoded values for Col_3 and Col_4. But it is behaving the same.
Also, I tried by just adding a write row activity without the for each row and providing hardcoded values to the overwrite column values, then it just clears the respective row cells. Doesn’t write the new values.
