Record changes to spreadsheet data validation
Keep a useful record when the rules for entering sheet data change.
Trigger
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.
Action
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.
Why this helps
A changed validation rule can affect future entries, and teammates may not know what changed.
- Make validation changes easier to review.
- Keep a concise record with the rest of the project context.
- Help teammates understand updated entry rules.
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 to summarize each validation rule change in a Dart doc.
- 4Choose the Data Validation Rule Changed trigger and a report channel.
- 5Test with one real validation rule change.
Questions about this workflow
What kind of validation changes are detected?
The trigger detects rules that are added, updated, or removed.
Does this update an existing doc?
This workflow creates a new doc for the change summary.
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.