Turn changing spreadsheet metrics into follow-up
A changed total, count, average, minimum, or maximum can prompt a focused Dart review task.
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
Create Task
Tool to create a new task in DART with title and optional metadata. Use when you need to add a task to a workspace.
Why this helps
A moving business metric may need investigation, but its change can go unnoticed among other sheet data.
- Make metric changes easier to notice and investigate.
- Keep review work in Dart.
- Include the new result in a clear follow-up task.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Dart once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Tell Notis what metric changes deserve a task and what review context to include.
- 4Choose the Aggregate Metric Changed trigger and a report channel.
- 5Test with one real metric change.
Questions about this workflow
Which aggregate calculations are supported by this trigger?
The trigger supports SUM, COUNT, AVG, MIN, and MAX calculations.
Can I specify what metric change merits follow-up?
Yes. Describe the decision rule in your instruction, using information available from the trigger.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Dart. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Dart actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Task Comment
Tool to create a new comment on a DART task. Use when you need to add feedback, notes, or discussion to a specific task. Supports markdown formatting and threaded replies via parentId.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add Task Time Tracking
Tool to add a time tracking entry to a DART task. Use when you need to record time spent on a specific task. The finishedAt timestamp must be after startedAt.
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 Doc
Tool to create a new doc in Dart. Use when you need to record a new document that the user intends to write down. By default, the created doc will be in the Docs folder unless a specific folder is specified.
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.
Create Task
Tool to create a new task in DART with title and optional metadata. Use when you need to add a task to a workspace.
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 Doc
Tool to move an existing doc to the trash where it can be recovered if needed. Use when you need to delete a doc without permanently removing it.
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.
Delete Task
Tool to delete an existing task in Dart by moving it to trash. Use when a task needs to be removed but can be recovered later.
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.
Get User Space Configuration
Tool to retrieve workspace configuration including dartboards, folders, types, statuses, and more. Use when you need to understand available options in the workspace.
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.
Get Doc
Tool to retrieve an existing doc with metadata and content. Use when you need to access a specific document's details including title, folder, and text content.
Connect any two apps with Notis in the middle.
Google Sheets and Dart, 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 Dart.