Best answer

Is there a way I can add an action to delete or avoid duplicated Google Sheet rows in my Zap?

  • 27 May 2022
  • 2 replies
  • 52 views

Hi,

I have a zap to move reports our CRM send me regularly to a single Google Sheet. The problem is that each new report contains old data, plus new data. So every time a new reports come, all the old data that is on the spreadsheet is duplicated on the table. I want to know if there’s a way I can add to the zap an action to delete duplicates, or just to avoid adding duplicates rows.

icon

Best answer by Troy Tessalone 27 May 2022, 00:50

View original

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

2 replies

Userlevel 7
Badge +14

Hi @Ozzie G 

Good question.

Try using a UNIQUE formula function in a different GSheet tab: https://support.google.com/docs/answer/3093198?hl=en

Userlevel 7
Badge +8

Hey @Ozzie G! Just curious if you were able to solve this using Troy’s formula suggestion or if you’re still needing help on this one. Let us know!