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

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

1 reply

Useful links

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