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.
Question
How do I create a Google Sheets filter to add unique data to a second sheet?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
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.
ZapConnect 2026 is coming
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.