Hi,
I have a personal financial google spreadsheet that I’m working on and I am wondering if there’s a way to import a row of data from Zapier into Google Sheets without overriding the values in one of the existing columns. (For example, I need to ignore COL$E always). My current sheet uses a dropdown in dynamic dropdown in Column E that relies on the Column D selection and it is being overridden by empty data. So everytime I run the zap, there’s nothing appearing in the dropdown.
Images:
How it should be:

The issue:
