Hello,
I would like to know how to set up a process to trigger a notification if an email body has a specific word that matches a value from an excel sheet.
Context: I receive a lot of newsletters. I do not want to manually go through all these newsletters daily. Instead, I have an excel sheet with a long list of relevant company names and I would like to be notified if an email contains one of these names. There are too many names to set up a manual rule for each one.
What I’ve done so far and the obstacle: I have formatted the email to split the words so they can be looked up individually instead of using the whole email body as a lookup value when searching the spreadsheet. I have figured out how to check a single separated word against the spreadsheet, however I can’t figure out how to loop all remaining words through the same process. Maybe this approach is all together ineffective?
Apologies if there is already another thread out there that discusses this, but I searched and couldn’t find one.
Thanks!
