Question

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

  • 2 May 2024
  • 1 reply
  • 16 views

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: 

 


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.

Reply