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
Fires when a spreadsheet aggregate metric changes.
Action
Send Email
Immediately sends an email; sending is irreversible.
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 or removes labels on an email message.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create email draft
Creates a new email draft.
Aggregate Metric Changed
Fires when a spreadsheet aggregate metric changes.
Batch delete Gmail messages
Permanently deletes multiple Gmail messages without moving them to the trash; this cannot be undone.
Cell Range Values Changed
Fires when values in a monitored cell range change.
Create label
Creates a new email label.
Conditional Format Rule Changed
Fires when conditional formatting rules are added, changed, or removed.
Batch modify Gmail messages
Adds or removes labels on multiple Gmail messages.
Data Validation Rule Changed
Fires when data validation rules are added, changed, or removed.
Delete Draft
Permanently deletes an email draft, which cannot be recovered.
Developer Metadata Changed
Fires when developer metadata is added, changed, or removed.
Delete message
Permanently deletes an email message.
Filtered Range Values Changed
Fires when values in a filtered range change.
Create Gmail filter
Creates a Gmail filter to organize incoming messages automatically.
Connect any two apps with Notis in the middle.
Google Sheets and Gmail, or any other combination from 1,500+ 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.