Product guide

Zeto Sheet Notification & Alerts

Build proactive checkpoints inside Google Sheets that monitor changes and immediately notify the right team via email, Slack, Microsoft Teams, Discord, or custom webhooks—no code required.

How it works

Zeto rules follow a simple IF → THEN framework. Select a trigger, add conditions, and Zetomation will execute the actions every time the criteria are met.

Trigger

Choose the sheet tab that Zetomation should watch for edits, new rows, or form submissions.

Conditions

Define the IF logic. Combine column checks, range lookups, or dynamic variables to decide when alerts should run.

Actions

Select the destinations—Email, Slack, Teams, Discord, or Webhooks—and craft the message to send when everything matches.

Step 1: Rule name & trigger

Give the rule a descriptive name (e.g., “Sales Target Reached”) and pick the sheet you want to monitor. Zetomation automatically listens for edits, inserts, and form submissions on that sheet—no extra event configuration required.

Step 2: Conditions (IF)

Add the filters that must be true before the notification fires. You can combine multiple conditions; all must pass (AND logic).

Column letter – looks at the edited row (e.g., Status column equals “Done”).
Specific cell – checks a static cell anywhere in the workbook.
Range – scans any value inside a defined grid.
Variable – compares dynamic placeholders such as {{UserEmail}} or {{Timestamp}}.

Step 3: Actions (THEN)

Stack one or more notifications. Mix email, chat messages, and HTTP webhooks to fan out updates when the rule hits.

Condition target types

Mix and match target inputs to capture the exact scenario you care about. All conditions use AND logic when combined.

Target input	Description	Example use case
Column letter	Checks the specific cell in the row that was edited.	If column C (Status) changes to ‘Done’.
Specific cell	Evaluates an absolute cell regardless of where the edit happened.	If D5 (Grand Total) is greater than 1000.
Range	Looks for a match anywhere inside the range you provide.	If any cell in A1:B10 contains ‘Error’.
Variable	Compares dynamic placeholders such as {{UserEmail}}.	Run only when {{UserEmail}} equals admin@company.com.

Comparison operators

Text

Equals
Contains
Starts With
Matches Regex
One Of

“One Of” accepts comma-separated values such as Done, Approved, Final.

Numbers

Greater Than
Less Than
Between
Valid Number

Dates

Before
After
Equal To

Supports smart inputs like Today, Yesterday, or Tomorrow.

Notification channels

Chain multiple actions if needed—for example, email leadership and ping a Slack channel at the same time.

Email

Send a rich-text notification with subject, body, and optional recipients in CC/BCC.

Slack / Discord / Teams

Post structured messages to incoming webhooks for real-time chat alerts.

Webhook

Deliver raw JSON payloads to Zapier, Make, or your own APIs.

Dynamic variables

Personalize messages with live data pulled from the triggering row or other cells. Use them in conditions, subjects, body copy, and webhook payloads.

Event variables

{{TriggerRow}}	Row number where the edit or change occurred.
{{EditValue}}	The latest value entered into the cell.
{{UserEmail}}	Email address of the user who triggered the rule.
{{Timestamp}}	Exact date and time the rule executed.

Data variables

{{Sheet1!A1}}	Value from a specific cell using A1 notation.
{{Header:Status}}	Looks for “Status” in row 1 and returns the value from that column for the triggering row.

Example scenarios

These blueprints demonstrate how to combine triggers, conditions, and variables for common operations use cases.

Notify sales when a deal closes

Trigger: Sheet = Sales_Data
Conditions: Status (column C) equals Closed Won AND Amount (column E) is greater than 5000
Action: Send email to manager@zeto.com with contextual details such as {{Header:Amount}} and {{TriggerRow}}

Monitor inventory levels

Trigger: Sheet = Inventory
Condition: Range Q1:Q100 is less than 10
Action: Send Slack message warning that stock is critical

Admin-only configuration alerts

Trigger: Sheet = Configuration
Conditions: {{UserEmail}} contains @admin.com AND column B equals Critical Change
Action: Send email explaining a critical update just occurred

FAQ & troubleshooting

I set up a rule but didn't get an email. What should I check?

Look in your spam folder—first-time alerts can land there.
Confirm the condition logic and capitalization match exactly (e.g., Done ≠ done).
If the rule depends on formulas, make sure the calculation finishes before the trigger fires.

Can I monitor multiple sheets?

Yes. Create separate rules for each tab. Zetomation manages triggers independently per sheet.

Is there a limit to how many automations I can create?

Google enforces a limit of 20 active triggers per user across all spreadsheets. Zetomation will alert you if you reach it.

How do I obtain a Slack, Discord, or Teams webhook URL?

Slack: Visit the Incoming Webhooks page at api.slack.com and create a webhook for your channel.
Discord: Open Server Settings → Integrations → Webhooks and generate a new one.
Microsoft Teams: Right-click a channel, choose Connectors, and configure an Incoming Webhook.
Paste the generated URL into the Zetomation action configuration.

Need help?

Our team can assist with complex logic, webhook payloads, or Workspace-wide deployments.Contact supportto start the conversation.