Hello there! Pretty new to Zapier. I have a Zap that takes a new email message, pulls the sender, recipient, subject, etc, and inserts that info into a spreadsheet (Smartsheet). The mailbox that it is pulling from has multiple SMTP addresses assigned, so the recipient part is important. I have stored all of these SMTP addresses in a Zapier table along with the “Pretty” name of the recipient. For example, “sales-sandiego@contoso.com” would be in the Table with the “Pretty” name of “San Diego Sales”. I’m using a Lookup to get the Pretty name and insert that into the Smartsheet. Here’s my challenge. I’ve found that actual SMTP address might end up in the CC line, or even in the BCC. So my v1 Zap has a lot of Paths. If the Lookup for the recipients in the To: line returns false, then it does another lookup for the CC: line, etc. It’s working, but it seems I could clean it up.
My thought for to make this a little more elegant would be to store all recipients in the TO: and CC: lines somewhere (a Zapier Table?) and THEN do the lookup. I’m not sure how to do this. Is it using Looping to go through all email addresses in the TO: line, and then the CC: line? Seems like a Zapier Table isn’t really meant for storing temporary data. What can I use instead? Is Zapier Email Parser a better solution than reaching into the Exchange mailbox?
