Keep task details aligned with a tracked row
When a row you track changes, carry the relevant update into its Dart task.
Trigger
Spreadsheet Row Changed
Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row appears, or when the row disappears.
Action
Update Task
Tool to update an existing task in DART with new properties. Use when you need to modify a task's title, status, assignees, or other attributes. Only properties specified in the request will be updated.
Why this helps
The spreadsheet has the latest details, while its Dart task still reflects an earlier state.
- Reduce stale task details when a tracked record changes.
- Bring important status changes into Dart.
- Cut down on manual cross-checking.
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 which Dart task to update and which changed row details matter.
- 4Choose the Spreadsheet Row Changed trigger and a report channel.
- 5Test with one real row change.
Questions about this workflow
How is the row found?
The trigger monitors a row located by searching for a query value in a specified range.
How does Notis identify the Dart task?
Specify the task or provide its identifier in your instruction.
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.