Specific Row Updated
Runs when any cell within a specific row or set of rows is edited.
- Single row: 5
- Range: 1-10 (rows 1 through 10)
- List: 1, 3, 5 (rows 1, 3, and 5 only)
Product guide
Zeto Sheet Automation
Build if-this-then-that style workflows directly in Google Sheets. This guide covers the pillars of Zetomation—triggers, conditions, actions, and dynamic variables—plus real-world recipes you can deploy today.
Core concepts
Every automation rule has three parts: Triggers decide when to run, Conditions filter the data, and Actions define what happens next. You can test rules before publishing and stack multiple actions in one workflow.
Trigger
Pick what activity wakes the automation—edits, new rows, form responses, or timed schedules.
Conditions
Add AND logic to keep noise low. Combine column checks, range switches, and system variables.
Actions
Send alerts, move data, protect rows, or call external systems—all in the order you arrange.
⚡ Triggers (when this happens...)
Triggers determine when the automation engine wakes up. Scope them to a worksheet tab or run them globally across the file.
Specific Column Updated
Runs when any cell within a specific column is edited—ideal for status or priority changes.
- Single column: A
- Range: A-C (columns A, B, and C)
- List: A, D, F
Specific Range Updated
Runs only when an edit occurs within the defined A1 range.
- Example: A1:C10
On Sheet Updated
Runs on any edit made anywhere in the selected worksheet—useful for audit logs or catch-all workflows.
On New Row Added
Runs when a new row is inserted into the sheet by a user or integration.
Google Form Response Received
Runs immediately after a linked Google Form submits a new response into the sheet.
Form (3rd-party) Response
Runs when external tools such as Zapier, Make, or Typeform push data into the sheet.
Scheduled Time
Runs on an automated cadence regardless of user edits.
- Frequencies: Hourly, Daily, Weekly, Monthly
- Choose the exact local time for execution
🔍 Conditions (logic checks)
Conditions act as filters. When you stack multiple conditions they use AND logic, meaning every requirement must pass before actions run.
Column
Checks the value of a specific column in the row that triggered the automation.
Example
Column C equals 'Approved'
Range
Checks the value of a static cell, often used as a master switch.
Example
Settings!B1 equals 'ON'
Variable
Compares dynamic variables like user email or timestamp.
Example
{{UserEmail}} contains '@company.com'
Comparison operators
equals
does not equal
contains
does not contain
starts with
ends with
is empty
is not empty
regex matches
is greater than
is less than
🚀 Actions (then do this...)
Automations can execute multiple actions sequentially. Mix communication tasks with data clean-up and advanced integrations.
📧 Communication
Deliver updates to inboxes and chat tools the moment data changes.
Send Email
- Configure To, CC, BCC, Subject, and Body fields.
- Supports HTML templates and dynamic variables such as {{Name}}.
- Optionally attach the triggering row or sheet as a PDF.
Slack / Discord / Teams
- Post a structured message to a webhook URL.
- Include row data and custom payloads for channel context.
📝 Data Management
Keep spreadsheets accurate by transforming rows in real time.
Update Row
- Map column letters to new values, e.g., set column D to “Processed”.
Create Row
- Insert a new row in a target sheet with full data mapping and placement controls.
Copy Row
- Duplicate the triggering row to another sheet for archival or reporting.
Delete Row
- Remove the triggering row when it no longer needs to stay on the sheet.
🎨 Formatting & Organization
Highlight what matters and control sheet visibility.
Format Row
- Change text or background colors to signal state.
Hide / Protect Row
- Hide rows from view or lock them so only owners can edit.
Sort Sheet
- Automatically sort a sheet or range by a selected column (A→Z or Z→A).
🌐 Advanced / Export
Connect Zetomation to external systems and archives.
Call Webhook / HTTP Request
- Send a JSON payload of row data to external APIs.
Export Row
- Generate a PDF or HTML snapshot of the row and save it to Google Drive.
🧩 Dynamic variables
Use variables in emails, chat messages, webhook payloads, and data mappings to insert live spreadsheet values.
| Variable | Description |
|---|---|
| {{TriggerRow}} | Row number where the edit occurred (e.g., 5). |
| {{TriggerSheet}} | Name of the active sheet (e.g., Sales). |
| {{A}}, {{B}} | Values from the triggering row by column letter. |
| {{Header:Status}} | Looks up “Status” in row 1 and returns the value for the current row. |
| {{UserEmail}} | Email address of the user who made the edit. |
| {{EditValue}} | New value typed into the cell. |
| {{OldValue}} | Value of the cell before the edit. |
| {{Timestamp}} | Current date and time in ISO format. |
| {{Sheet1!A1}} | Absolute reference to any cell (Sheet1 cell A1 in this example). |
💡 Automation recipes
Jump-start your rollout with proven workflows. Use them as-is or tailor the actions and conditions to match your process.
Email customers as soon as a Google Form response hits the sheet.
Auto-Response Email on Form Submit
- Trigger: Google Form Response Received
- Action: Send Email to {{C}} with subject “We received your request!”
Keep active sheets clean by archiving completed work.
Move Completed Tasks to Archive
- Trigger: Specific Column Updated (e.g., column E)
- Condition: Column E equals Done
- Actions: Copy Row to Archive sheet, then Delete Row
Alert sales leadership when a large deal closes.
Slack Notification for High-Value Sales
- Condition: Column D is greater than 10000 and Status equals Closed Won
- Action: Slack message “🚨 Big Deal! {{UserEmail}} closed ${{D}} with client {{B}}.”
Keep scheduling sheets chronologically sorted.
Auto-Sort Data by Date
- Action: Sort Sheet by column A (ascending).
Ping operations when inventory drops below threshold.
Inventory Low Stock Alert
- Condition: Column D < 10
- Actions: Send Teams alert and format row red.
Protect rows once accounting approves an invoice.
Lock Approved Invoices
- Action: Protect Row and apply green formatting.
Deliver a morning summary snapshot.
Daily PDF Report
- Trigger: Scheduled Time (08:00)
- Action: Export PDF of sheet.
Capture who edited a lead and when.
CRM Timestamp
- Action: Update column Z with {{Timestamp}} and column AA with {{UserEmail}}.
Copy new records into a master spreadsheet.
Sync to Master Sheet
- Action: Create Row in “Master” sheet with mapped values.
Keep rejected applications accessible but hidden from view.
Hide Rejected Rows
- Action: Hide Row.
Next steps
Combine these building blocks to orchestrate end-to-end operations. Need help implementing an idea?Contact our support team.