search

dcolley / integromat-facebook-support

0 stars 0 forks source link

[QUESTION: how to - if email doesn't exist in Google Sheets column A, send ... #141

Open dcolley opened 2 years ago

dcolley commented 2 years ago

Source: copied from https://www.facebook.com/groups/integromat/permalink/3971609892949614/

[QUESTION: how to - if email doesn't exist in Google Sheets column A, send email]

Whenever we have big transaction value over X amount, an ID check takes place to match ID with credit card holder. The email addresses of those who have been correctly matched are stored in a sheet with 1 column only.

If the email address doesn't exist in the column, I want to send an email.

It sounds easy but I just can't seem to wrap my head around it today.

Any thoughts?

dcolley commented 2 years ago

Comment ID: 3971655509611719 What filter you are using will you please share screenshot

dcolley commented 2 years ago

Comment ID: 3975288302581773 Te result of Google Search module will be 1 (or more if the email is duplicated) if it find something, or 0 if not.

In the filter before the email module, just add the “number of bundles” equal to 0 and the scenario will go through.