(I apologize ahead of time if this has already been covered somewhere)
My co-worker sends me Outlook emails with candidate’s name as the subject, telling me that they have passed their background check. We have candidates in a spreadsheet, one row per candidate. I would like to automatically email the candidate to inform them that their background check is complete.
Question: how do I ask Zapier to find the candidate e-mail address in my spreadsheet based on the subject (candidate name) of an incoming message?