Stay alert to pipeline changes in real time
Your pipeline SUM changes? Notis sends an alert. Miss no metric shift, no context-switching needed.
Trigger
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Action
Send Email
Sends an email via gmail api using the authenticated user's google profile display name, requiring `is html=true` if the body contains html and valid `s3key`, `mimetype`, `name` for any attachment.
Why this helps
Checking sheet metrics manually eats time. Missing a revenue drop or a major opportunity closes until the next all-hands.
- Instant notification when deal metrics hit milestones
- Monitor SUM, COUNT, or AVG without manual tracking
- No sheet-checking habit needed
- Stay responsive to pipeline shifts
Setup
Build it in a few focused steps.
- 1Link your Google Sheets and Gmail to Notis.
- 2Create an automation: 'When my total deal pipeline value (SUM of [Column]) changes, send me an email alert.'
- 3Set the trigger to 'Aggregate Metric Changed' and specify the calculation (SUM of deal values, AVG of deal size, COUNT of open deals, etc.).
- 4Optionally filter by stage or date range (e.g., 'only watch deals in Proposal stage added this quarter').
- 5Test by adding a new deal row or changing an existing deal value, then confirm the alert arrives.
Questions about this workflow
How sensitive is the trigger? Will small changes spam me?
Set a threshold in your prompt: 'only alert if the total changes by more than $10k' to avoid noise from minor adjustments.
Can I track multiple metrics?
Yes. Create separate automations for deal count, win rate, or average deal size. Notis handles each independently.
What if I want the alert at a specific time, not instantly?
Use a Cron trigger instead to batch alerts (e.g., daily at 9am) rather than real-time notifications.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Gmail. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Gmail actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Modify email labels
Adds and/or removes specified gmail labels for a message; ensure `message id` and all `label ids` are valid (use 'listlabels' for custom label ids).
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create email draft
Creates a gmail email draft, supporting to/cc/bcc, subject, plain/html body (ensure `is html=true` for html), attachments, and threading.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Create label
Creates a new label with a unique name in the specified user's gmail account.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Delete Draft
Permanently deletes a specific gmail draft using its id; ensure the draft exists and the user has necessary permissions for the given `user id`.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Delete message
Permanently deletes a specific email message by its id from a gmail mailbox; for `user id`, use 'me' for the authenticated user or an email address to which the authenticated user has delegated access.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Fetch emails
Fetches a list of email messages from a gmail account, supporting filtering, pagination, and optional full content retrieval.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Fetch message by message ID
Fetches a specific email message by its id, provided the `message id` exists and is accessible to the authenticated `user id`.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Fetch Message by Thread ID
Retrieves messages from a gmail thread using its `thread id`, where the thread must be accessible by the specified `user id`.
Connect any two apps with Notis in the middle.
Google Sheets and Gmail, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Gmail.