Skip to main content
Question

How do I create a Google Sheets filter to add unique data to a second sheet?

  • August 25, 2023
  • 1 reply
  • 19 views

Farber

I am trying to create a data filter. When new data is inserted into a google sheet, data is checked against a 2nd sheet, only data that is NOT in the 2nd sheet will be added to the 2nd sheet. 

Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14

Hi @Farber 

Good question.

Try adding this Zap action: GSheets - Lookup Row

Then as part of the step config, check the checkbox at the bottom to create a new row.

Thus the logic becomes find row else create row.