Investigate metric shifts with Box AI
A changed total can prompt a focused question about the Box documents behind your process, without a manual search detour.
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
Ask question
Sends an ai request to supported llms and returns an answer specifically focused on the user's question given the provided context.
Why this helps
A metric moves, but finding the documents that might explain it takes time and context switching.
- Start a focused document review when a monitored aggregate changes.
- Ask a consistent question about a known Box file or folder.
- Reduce the time between spotting a metric shift and investigating it.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Box once in the Notis portal.
- 2Create an automation from Automations, New Automation, or tell Notis what you want in plain language.
- 3In one instruction, ask Box AI a specific question about a known relevant Box file or folder when the aggregate changes.
- 4Pick Aggregate Metric Changed as the trigger and configure its metric and optional filter in the trigger settings.
- 5Choose a report channel, then test with one real metric change and relevant Box content.
Questions about this workflow
Will this identify which documents caused a metric change?
No. The aggregate trigger reports a changed calculation. Your instruction must identify relevant Box content and ask a question that the content can help answer.
Can the metric be filtered?
The trigger supports an optional search column and value filter.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Box. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Box actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add classification to file
Adds a classification to a file by specifying the label of the classification to add. this api can also be called by including the enterprise id in the url explicitly, for example `/files/:id//enterprise 12345/securityclassification-6vmvochwuwo`.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add classification to folder
Adds a classification to a folder by specifying the label of the classification to add. this api can also be called by including the enterprise id in the url explicitly, for example `/folders/:id/enterprise 12345/securityclassification-6vmvochwuwo`.
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.
Add domain to list of allowed collaboration domains
Creates a new entry in the list of allowed domains to allow collaboration for.
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.
Add initial classifications
When an enterprise does not yet have any classifications, this api call initializes the classification template with an initial set of classifications. if an enterprise already has a classification, the template will already exist and instead an api call should be made to add additional classifications.
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.
Add or update user avatar
Adds or updates a user avatar.
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.
Add shared link to file
Adds a shared link to a file.
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.
Add shared link to folder
Adds a shared link to a folder.
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.
Add shared link to web link
Adds a shared link to a web link.
Connect any two apps with Notis in the middle.
Google Sheets and Box, 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 Box.