Documentation Overview

Zeto Sheet Automation creates the center of your workflow by connecting Google Sheets to the tools you use every day.

To set up an automation, you need to configure three components:

1. Trigger: The event that starts the process (e.g., "When a cell updates").
2. Condition: The rules that must be met (e.g., "If Status equals Approved").
3. Action: The task to perform (e.g., "Send an email").

Installation

Get Zeto Sheet Automation from the Google Workspace Marketplace.

Once installed, open a Google Sheet, go to Extensions > Zeto Sheet Automation > Launch.

Update Triggers

These triggers fire when data is manually changed in the spreadsheet.

Specific Row Updated

Triggers when any cell in a specific row index is modified.

Specific Column Updated

Triggers when a cell within a specific column is modified. Useful for "Status" columns.

Specific Range Updated

Monitor a specific block of cells (e.g., A1:B10). The automation only runs if edits happen here.

On Sheet Updated

The broadest trigger. It runs whenever anything on the specific tab changes.

New Row Added

This trigger monitors the sheet for newly inserted rows. This is distinct from editing an existing empty row; it specifically listens for the "Insert Row" event.

Form Responses

Google Form Response

Runs automatically when a linked Google Form submits a new entry to the sheet.

3rd Party Forms

If you use tools like Typeform or JotForm that push data to Sheets, use the New Row Added trigger or the dedicated 3rd Party Form trigger if available.

Scheduled Time

Run workflows on a timer rather than user activity.

• Hourly: Checks conditions every hour.
• Daily: Runs once a day at a specified time.

Column Condition

Validates the value of a specific column in the triggering row.

Example: If the trigger is "Row Updated", check if Column C (Status) equals "Complete".

Range Condition

Checks the value of a static cell (e.g., H1) regardless of which row triggered the event. Useful for global "ON/OFF" switches in your sheet.

Variable Condition

Advanced. Allows you to use Aliases (like {{EditValue}}) to create dynamic logic rules.

Send Email

Send customized HTML or Text emails via Gmail.

You can use Aliases in the Subject and Body to personalize the message.

Subject: Update regarding {{A}}
Body: Hello, The status of item {{B}} has changed to {{EditValue}}.

Slack, Discord & Teams

Send messages to channel webhooks.

To use this, you must generate a Webhook URL from your chat application (e.g., Slack Incoming Webhook) and paste it into the Zeto action configuration.

Row Operations

Automate data management within the sheet:

• Update Row: Change values in the triggering row automatically.
• Copy Row: Duplicate the row to another sheet (Archive workflow).
• Hide Row: Hides the row if conditions are met.
• Protect Row: Locks the row so no further edits can be made.
• Delete Row: Removes the triggering row.

Call Webhook

Send a JSON payload containing row data to any external URL (Zapier, Make, Custom API).

Supported Aliases (Variables)

Use these placeholders in your Actions (Emails, Slack messages, etc) to insert dynamic data.