Make spreadsheet metric changes easier to interpret
Get a plain language update when a key aggregate changes, with the business context you want Notis to consider.
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
Text Chat Completion
Tool to generate text completions or chat responses using a specified llm model. use after assembling the conversation history to produce the next response.
Why this helps
A changed total or average can demand attention, but the number alone may not tell you what decision to make next.
- Notice changes to monitored aggregate calculations.
- Generate a plain language update from the available metric details.
- Add your own thresholds or business context to the prompt.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Ai ml api once in the Notis portal.
- 2Create an automation in the portal or tell Notis in plain language from any channel.
- 3Describe the outcome in one instruction: summarize the changed aggregate and apply any thresholds or context you supply.
- 4Pick the Aggregate Metric Changed trigger and choose where run reports go.
- 5Test with one real example metric change.
Questions about this workflow
Which calculations can trigger this workflow?
The trigger supports SUM, COUNT, AVG, MIN, and MAX calculations.
Can it determine the cause of a metric change?
It can interpret information provided to it, but the cause must be present in the trigger data or supplied context.
Does it send a message to my team?
The workflow produces a run report in the channel you choose during setup.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Ai ml api. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Ai ml api actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Moderation Completion
Tool to classify input text or image for safety using a moderation model. use after receiving user-generated content to filter out unsafe material.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Text Chat Completion
Tool to generate text completions or chat responses using a specified llm model. use after assembling the conversation history to produce the next response.
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.
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.
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.
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.
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.
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.
Connect any two apps with Notis in the middle.
Google Sheets and Ai ml api, 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 Ai ml api.