Skip to main content
Question

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

  • 4 February 2025
  • 1 reply
  • 5 views

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?

1 reply

Troy Tessalone
Forum|alt.badge.img+14