So I have a client I’m helping send out Messages to Twilio
Basically what I’m doing is I have a custom form that’s 24/7 collecting information on Google Sheets
(Names & Phone Number) then using Google Sheets Trigger (Custom Node from : n8n-nodes-google-sheets-trigger - npm) once a new row is detected a message is sent to that new Number.
Essentially the messages being sent are “Hi [[username]], thanks for filling out our Form. We’ll get back to you shortly”
So everything’s working well to that end, the thing is some of the customers are in a situation where they have to fill in 2 or more Questionnairs thereby getting 2 or more “Thank you Messages” (I’m trying to avoid spamming)
I’d like to know if there’s a way I can filter out (using ‘IF Node’ maybe? 'Date/Time Node maybe?) numbers that are already existing not to be sent the message
i.e if number has been sent a Thank you message in the past 24hours, don’t send message.
The Nodes are GoogleSheets Trigger > Set Node > Twilio