I need to have such automation working in make.com - if a new row appears in table A (there I have columns filling time, color, email), then it should check if such emails already exist in the entire table (to know if it is a new client or an existing one).
And depending on that - either send an email to my mailbox with a notification “New client”, or send an email to my mailbox with a notification “Existing client”. Find me a video on Youtube about that.
P.S.: I understand that its like 15 minutes of work for pro`s but I am newbie. Please help.
Hey Volodymyr,
start with a custom mailhook module and copy the address as a forwarding address in your email tool of choice.
When a new email arrives the mailhook will trigger → follow that with a search module to check the sheet if the email address exists → follow that with a router → have a filter on each route to check if the search module found anything or not → do what needs to be done depending (I assume add it to the sheet and send an email if it doesnt exists on one route and just send the email if it already exists on the other route).
3 Likes
Thnx! I did it! The settings is still not user friendly.