Conditions

Decide whether a workflow should run when it is triggered.

This is an optional step that lets you set up a set of conditions to decide whether a workflow should be executed. You can use conditions to fine-control an automated workflow, for example, only run the automation when range A5 is larger than 100.

Conditions are optional. You can skip this step by not adding any conditions in this step. Remember to remove all added conditions if you don't intend to use any conditions.

Once you have added one condition, you will see an option that lets you choose "When all/any of the conditions are/is met." If you choose "all," the automation will only run if all of the conditions you have set are met. If you choose "any," the automation will run if at least one of the conditions you have set is met.

When this value

In this field, you can type in the value that you want to compare. Usually, you will need to use a merge tag to refer to the dynamic data in your spreadsheet or in the context of an automation run. For example, {{Range A1}} will give you the value of cell A1. If you are using an edit trigger, {{new value}} will give you the new value when a cell is edited.

Condition

The Condition dropdown menu here refers to the operator of the comparison you want to make. Here are all the operators you can choose:

  • is equal to

  • is not equal to

  • is greater than (numbers)

  • is greater than or equal to (numbers)

  • is less than (numbers)

  • is less than or equal to (numbers)

  • contains

  • does not contain

  • is empty

  • is not empty

Value

The value to compare to. The following configuration will let the automation run only when cell A1 is greater than 100.

Last updated