Question

How to define a condition to continue zap only if Google Sheets cell is not blank?

  • 18 September 2021
  • 2 replies
  • 27 views

Hello,

 

I think this should be a fairly simple question but I have been testing many times and can figure out the answer.

 

I have a Zap that is copying information from a Google Sheet to MailChimp but I want to trigger the Zap only if the email column as a value that is not null (because email is a mandatory field in Mailchimp). What’s the right way to define the condition please?

 

Thank you so mucu guys!


2 replies

Userlevel 7
Badge +11

Hi @Trifabbb 

Check out this help article: https://zapier.com/help/doc/common-problems-with-google-sheets-on-zapier#new-or-updated-spreadsheet-row-trigger-behavior

Userlevel 3
Badge +4

Hi @Trifabbb ,

 

You can add a filter like below. 

 

 

Reply