Bug [GoogleSheets] PullCellData is never called on empty cells

Hi,

On 0.9.0-preview I noticed that on GoogleSheets.MergePull there is a filter for empty cells when Calling columnMapping.PullCellData(), and as a result cells that are deleted from the spreadsheet are not updated back on unity. This will affect locale columns as well as custom metadata columns.

GoogleSheets.MergePull:

 

RemoveMissingEntries works if I delete the whole row from the sheet. This case is when I delete the value of a single cell but leave the row with the key data and all other columns untouched.


For example, on the following sheet I deleted the values from "Portuguese.." and "Tags" columns:


In this case I would expect that the portuguese translation would be emptied from the table on unity and that I get a callback to clean my custom metadata for the Tags column but that doesn't happen due to the check on GoogleSheet.MergePull

Since I'm using a modified version of the library I was able to fix the problem on my end. Here is my diff:


Edit:
I understand that this is very unlikely to happen for locale columns but it would be a much more common case for custom columns.