How I can perform a data validation (name or number already exist) on a Google sheet?
I'm receiving user's data using a Webhook and adding it to a Google Sheet and sending it via email. But, I'm receiving duplicates if the same user refills the form/webhook again.
Comment ID: 3973172376126699
You can use google sheet search module and first you can see if the data coming from webhook exists in google sheet or not if not exists then only add it sheet and send email
Source: copied from https://www.facebook.com/groups/integromat/permalink/3972170009560269/
How I can perform a data validation (name or number already exist) on a Google sheet?
I'm receiving user's data using a Webhook and adding it to a Google Sheet and sending it via email. But, I'm receiving duplicates if the same user refills the form/webhook again.