I have a simple ZAP with a slightly unique demand in it.
Goal: ‘Add New Item to Monday Board’ when ‘New Spreadsheet Row is Added to Google Sheets’
It is single column spreadsheet (automatically pasted), and it will commonly have DUPLICATED and that is the issue. I would only want UNIQUE rows to paste.
Example:
Missing Files:
a
b
a
a
b
c
Output I hope for:
a
b
c
I thought I was smart and figured it out with the Zapier Filter option to do “only continue if the value ‘DOES NOT EXIST.’ But now I realize that just means that it would be blank.
I am thinking there are a few ways we could do this - could anyone help and make a suggestion - it would pay off greatly as we enter ‘CyberMonday’ and this task it automated!!
There isn’t a way to check if an item already exists with Zapier, at least on the monday side.
However, perhaps you can implement this logic by checking if the row already exists in your Google sheet. I found some Zapier actions that will return the spreadsheet row that matches a specific column value: