I am trying to write a complete range to a Google Spreadsheet. I am using the Google Spreadsheet Activities for doing so.
But when I am writing to my existing Google spreadsheet, that already has data, the Write Range activity is not overwriting the existing text, in the cases when a blank is present in the data table.
So I am getting an incorrect output in my Google spreadsheet since text is present in the cells that should actually be blank.
Is there any method using which I can write the blanks present in my data table to my Google Spreadsheet?
Thanks in advance.