The difference between a noisy automation and a dependable one is conditional logic. In this guide we explore how to combine column and range conditions with Zeto actions so only the right people are pinged.
Column conditions for row-level context
Column conditions evaluate the row that triggered your automation. They are perfect for approvals, escalations, and exception handling.
Scenario: Expense approvals. Watch column B (Amount) and only run actions when the value exceeds 500.
- Trigger: Specific Column Updated (Column B)
- Condition: Column Condition, operator set to Greater Than, value
500 - Actions: Send an email to finance and notify the manager in Slack
Range conditions as master switches
Range conditions check static cells elsewhere in the sheet. Designate cell Z1 as your Automation On/Off toggle. If the value equals “ON”, the workflow runs; if it equals “OFF”, every action is skipped.
Combining conditions for precision
Layer column and range checks to keep the signal high. For example:
- Column condition: Amount > 500
- Range condition: Z1 equals ON
- Range condition: C2 (Current Quarter) matches the sheet value
This ensures finance only hears about high-value expenses while the automation stays dormant during scheduled maintenance windows.
Testing and rollout
Before going live, clone the sheet and run the automation in Test Mode. Validate that the logs show the expected condition results. Once satisfied, deploy to production and monitor the execution history for the first few days.
Next steps
Combine these conditions with our chat notification recipes to build a complete approval command center.