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

  • 2 May 2024
  • 1 reply


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.

How it should be:

The issue: 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @lamarcheeduardo 

For 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.