Email templates with conditional content from Airtable.

Question

Hi, I have created a zap using Gmail and Airtable. The email gets sent to my print vendor and is triggered from a view in Airtable that is named “Send To Print”. Most orders have 1 item that is going to print, but some have items that we call “Add Ons”. They basically accompany the primary print piece.

My question is: Can I customize the email template, so that it will list “Add On” items, only if there are any? If not, the entire section (outlined in red below) would be left out of the email. Or, only the item that had a quantity filled in, would be sent in the email.

I’ve attached screenshots of the email, the zap as it currently is, and a record in Airtable.

I hope this makes sense.

Email:

Zap:

Airtable Record where the data is pulled from:

icon

Best answer by Danvers 7 April 2020, 16:35

View original

Danvers · Accepted Answer

Hi @Nate_B! Yep, you’ve got it - you can create two Zaps: one that will run if there is something in those fields and one that runs if it doesn’t.

If you’re on the Professional Plan or higher, you can also do this with one Zap, using Paths. Paths allow you to logic to the Zap that says ‘if this condition is met, do these actions’. If you’re not on a Professional Plan, and only have two conditions (eg there’s Add on’s or there aren’t) then two Zaps and filter will do the job just as well 🙂

Nate_B · Answer

Hi there@Nate_B- Thanks for writing in. Have you checked out Filter by Zapier with specifically a focus on using filters to fix empty field values? Please give this a shot and let us know if it worked for you!  Actually, I see how this could possibly work. But it would require me to basically make the same zap over and over, and then use the filter to decide which email template to send. Thanks for the suggestion.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded