How do I customize Gmail email content based on Airtable form responses using Zapier?

Question

Hi,

I’m trying to use zapier/gmail to onboard a new group of people but I’m having trouble figuring out how to change some of the content in the email so that people are only getting information relevant to themselves.

I used an airtable form and people were able to (multi)select from 3 options so some people choose none, one or a combination of all 3 and I want to send 1 email that has links to sites that correspond to their choice without having to send multiple emails (since there are a lot of different combinations). Is that possible to do?

Troy Tessalone · Answer

Hi ​@ATLWorksOptions:Lookup Table:https://community.zapier.com/how-do-i-3/lookup-tables-resources-19811Zapier Tables:https://zapier.com/apps/zapier-tables/integrations#triggers-and-actionsAction: Zapier Tables - Find RecordsUsed to find the matching email content for each selected optionFormatter > Utilities > Line Items to TextUsed to format the email content for the email bodyPaths:https://zapier.com/apps/paths/integrations#helpDifferent path for the possible email templates based on the selected combosNoneABCABACBCABCCode:https://zapier.com/apps/code/integrations#helpCustom code can be used to do the dynamic logic and prep the email contents

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded