How do I import data to Google Sheets without clearing a specific column via Zapier?

Question

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:

Troy Tessalone · Answer

Hi @lamarcheeduardoFor us to have more context, post screenshots with how your Zap steps are outlined and configured along with the top 3 rows of your GSheet.The Zap action for GSheets - Add Row will add a new row to the bottom of the GSheet, it does not populate an existing empty row.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded