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.
Best answer by Troy TessaloneBest answer by Troy Tessalone
Hi
Good question.
Try using a UNIQUE formula function in a different GSheet tab: https://support.google.com/docs/answer/3093198?hl=en
+14Hi
Good question.
Try using a UNIQUE formula function in a different GSheet tab: https://support.google.com/docs/answer/3093198?hl=en
+9Hey
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
