Skip to main content
Question

How do I conditionally insert 'and' in an email body based on spreadsheet data using Zapier?


Hi all,

I am creating a zap where it will pull data from a spreadsheet and send an email. In my spreadsheet, I have a “Guest 1 First Name” field and a separate “Guest 2 First Name” field.

In my email body, I want it to say “Hello [Guest 1 First name] and [Guest 2 First Name” but only if there is an actual name for guest 2. If the Guest 2 Field is blank, it would only say “Hello [Guest 1 First Name]”. 

I am trying to add the word “and” only if there is a guest 2 first name. If I add the and in the actual email and there is no guest 2 first name, it would say “Hello [Guest 1 First Name] and” which is weird.

I have tried to split to two fields and then join them with a word but its not working. Not sure what else in formatter I can use.

Thank you in advance!

Did this topic help you find an answer to your question?

2 replies

Troy Tessalone
Forum|alt.badge.img+14

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7274 replies
  • February 11, 2025

Hi ​@l_buzzbee! 👋

Were you able to get things sorted using one of the options Troy suggested here? Or did you find a different solution?

Want to make sure you’re all set, so keep us updated on how things are going!