Zeto Sheet Notification & Alerts

Welcome to Zeto Sheet Notification & Alerts. This add-on allows you to turn your Google Sheets into a powerful automation engine. Monitor changes, track goals, and send instant alerts to Email, Slack, Discord, and more—without writing a single line of code.

1. How It Works

Zeto operates on a simple IF / THEN logic rule engine:

  1. Trigger: You select a Sheet to watch.
  2. Conditions (IF): You define specific criteria (e.g., "Column C equals 'Approved'").
  3. Actions (THEN): You choose who to notify and what message to send.

The add-on automatically handles all event types—whether you edit a cell manually, paste a range of data, add a new row, or receive a Google Form submission.

2. Creating a Rule

Step 1: Rule Name & Trigger

  • Rule Name: Give your rule a descriptive name (e.g., "Sales Target Reached" or "New Support Ticket").
  • Sheet: Select the specific sheet tab you want to monitor.
Note: Zeto automatically watches for Edits, Row Insertions, and Form Submissions on the sheet you select. You do not need to configure specific event types.

Step 2: Conditions (The "IF" Logic)

Conditions determine when the rule should run. You can add multiple conditions; all of them must match (AND logic) for the notification to be sent.

Target Types

When defining a condition, you can target data in four ways:

Target Input Description Example Use Case
Column Letter (e.g., A, C) Checks the specific cell in the row that was edited. "If the Status column (C) changes to 'Done'..."
Specific Cell (e.g., A1, D5) Checks a fixed, absolute cell value, regardless of where the edit happened. "If the Grand Total cell (D5) is greater than 1000..."
Range (e.g., A1:B10) Checks if ANY cell in this range matches your value. "If any cell in the project grid contains 'Error'..."
Variable (e.g., {{UserEmail}}) Compares a dynamic system value using placeholders. "If {{UserEmail}} Equals admin@company.com" (Run rule only for Admin).

Comparison Operators

Zeto supports smart comparison for different data types:

  • Text: Equals, Contains, Starts With, Matches Regex, One Of (e.g., Done, Approved, Final).
  • Numbers: Greater Than, Less Than, Between (e.g., 1, 10), Valid Number.
  • Dates: Before, After, Equal To.
    Smart Date Support: You can compare dates against dynamic values like `Today`, `Yesterday`, or `Tomorrow` without needing to update the rule daily.

Step 3: Actions (The "THEN" Logic)

When all conditions are met, Zeto executes the actions. You can chain multiple actions together (e.g., Send an Email AND post to Slack).

Email Sends a rich-text email notification.
Slack / Discord / Teams Sends a message via Incoming Webhook.
Webhook Sends a raw JSON payload to any API (Zapier, Make).

3. Using Dynamic Variables (Placeholders)

You can make your messages dynamic by using Placeholders. Zeto will replace these with real data from the spreadsheet when the notification is sent.

Use these variables in your Conditions, Email Body, Subject Line, or Message Text.

Event Variables

Variable Description
{{TriggerRow}}The row number where the edit or change occurred.
{{EditValue}}The specific value that was just typed/pasted (if available).
{{UserEmail}}The email address of the user who made the change.
{{Timestamp}}The exact date and time the rule was triggered.

Data Variables

Variable Description
{{Sheet1!A1}}Pulls the value from a specific cell (e.g., {{Sales!B5}}).
{{Header:Status}}Powerful Feature: Looks for the column named "Status" in Row 1, and pulls the value from that column for the row that was triggered.

4. Examples

Scenario A: Notify Sales Manager when a Deal is Closed

  • Trigger: Sheet = Sales_Data
  • Condition 1: Target C (Status Column) Equals Closed Won
  • Condition 2: Target E (Amount Column) Greater Than 5000
  • Action: Send Email to manager@zeto.com
    • Subject: Big Deal Closed!
    • Body: "Hey, we just closed a deal for ${{Header:Amount}} in row {{TriggerRow}}. Great job!"

Scenario B: Monitor Inventory Levels

  • Trigger: Sheet = Inventory
  • Condition: Target Q1:Q100 (Stock Level Range) Less Than 10
  • Action: Send Slack Message
    • Message: "Warning: Stock level critical in one of the items. Please check the inventory sheet."

Scenario C: Admin-Only Alert (Using Variables)

  • Trigger: Sheet = Configuration
  • Condition 1: Target {{UserEmail}} Contains @admin.com
  • Condition 2: Target B Equals Critical Change
  • Action: Send Email
    • Body: "An admin just made a critical change to the config."

5. FAQ & Troubleshooting

Q: I set up a rule, but I didn't get an email.

  • Check your spam folder.
  • Ensure the condition logic is correct. Remember, the comparison is case-sensitive (e.g., "Done" is not the same as "done").
  • If using a formula-based cell, ensure the calculation completes before the trigger fires.

Q: Can I monitor multiple sheets?

Yes. You can create different rules for different sheets. Zeto handles the triggers for each sheet independently.

Q: Is there a limit to how many automations I can have?

Zeto uses Google's underlying trigger architecture. Google limits a single user to 20 active triggers across all their spreadsheets combined. If you reach this limit, Zeto will alert you.

Q: How do I get a Slack/Discord Webhook URL?

  • Slack: Go to Slack API > Incoming Webhooks.
  • Discord: Go to Server Settings > Integrations > Webhooks.
  • Teams: Right-click a channel > Connectors > Incoming Webhook.
  • Copy the URL provided and paste it into the Zeto Action field.