Skip to main content

Hi Zapier Community - 

 

I’m very new to Zapier - but trying to create an automation that will:

  1. Search my incoming GMAIL emails with specific search criteria (Done Successfully)
  2. Search Airtable to find the existing record based on MATCHING the “TO EMAIL” field (This is the one I’m having Trouble With - See Below)
  3. And Finally, Update a Record (Done Successfully)

The problem I am having is that there are two email addresses in the “To Email” field - because one is an automatic email added so that administrators receive a copy of the email. I want to have Zapier only include the first email address from the “To Email” in the “Search Value” field 

…….. Anyone know how I can accomplish this?

Hi @ronnieO 

Good question.

You can use Formatter > Utilities > options related to line items to isolate the first email address.


@Troy Tessalone - that worked like a dream!!!! Thanks so much!!