Hi! My scenario is:
Webhook → sheets → clickup task
What I want to do:
When a data sent to webhook, verify if the data (like phone number) is on any row of sheet, if not, add new row, if exists, do not add a row.
How can I create a filter to do that?
Welcome to the Make community!
That’s what the error directive Resume allows you to do. First, you use a Search module to see if it exists, then Create a new item if it doesn’t exist. In the Create field, you use an if-statement to “ignore” a required field if there are search results, throwing an error and allowing you to “skip” the creation module.
The if (not-exist-create-ignore) throws the error (ignore if exists), which the Resume directive can be used to return the item from the Search module (to check if it exists).
I explained this in a similar older post Can I skip a module based on a filter? - #3 by samliew
