Currently if the sheet in question has columns A, B and C and say 5 rows...
and you update it with just column A, B and 4 rows...
then the data of the 5th row and the entire column C remains...
This might be a bit risky.
Find a proper solution for this.. and if one can't be found. Switch to a delete beforehand and then do a create + update
Currently if the sheet in question has columns A, B and C and say 5 rows... and you update it with just column A, B and 4 rows... then the data of the 5th row and the entire column C remains...
This might be a bit risky. Find a proper solution for this.. and if one can't be found. Switch to a delete beforehand and then do a create + update